Tag Archives: Database Administration


Detecting T-SQL code smells – Part 3

Detecting T-SQL code smells – Part 3

This is The third and last part of the Detecting T-SQL code smells series. Within this post I will cover how the solution can be customized by adding new validation rules

Read More →

Detecting T-SQL code smells – Part 2

Detecting T-SQL code smells – Part 2

For the second part of this series, I’m relying on a project hosted on codeplex which can be found by the name TSQL Code Smells Finder.  The solution consists out of 3 files (one PowerShell script, a text file containing a list with possible errors and a whitelist file) and build within PowerShell, therefore it’s not that complicated to extend the solution later.

Read More →

Detecting T-SQL code smells – Part 1

Detecting T-SQL code smells – Part 1

When moving a new SQL server database into production or taking over maintenance duties for large and heavenly used databases, you might want to perform some audit’s allowing you to ask some additional questions when the development team is still available or just being aware of possible performance issues / special maintenance routines etc.

Read More →

SQL Server List auto-shrink enabled databases

SQL Server List auto-shrink enabled databases

I won’t cover why enabling AutoShrink is such a bad idea. There are numerous articles on the web, pointing this out in great detail. However, as a DBA you might want to know how many AutoShrink databases are active on your servers.

Read More →

Monitoring failed SQL Server login requests

Monitoring failed SQL Server login requests

Personally, I like to keep a close eye on my servers and users/customers. However, not like to do everything manually. This is not only very time consuming, but also most likely to find important issues rather late, hence the script below.

Read More →

Get-Hotfix command – check installed hotfixes

Get-Hotfix command - check installed hotfixes

Very short and simple post however, oh so important especially when a software vendor requires using specific version / hotfix.

Read More →

Executing SQL Statements using PowerShell

Executing SQL Statements using PowerShell

The SQL Server SMO client API can be used query and alter settings and objects within your SQL Server instances, however in case you want to query your user database, you will run into some limitations. The client API simply isn’t aware of your data objects and therefore not exposing a typed scheme. Fortunately, it’s pretty easy to accomplish when using the SQL Server PowerShell Module (SQLPS)

Read More →