Tag Archives: Powershell


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 →

JIRA SQL Server Network error IOException

JIRA SQL Server

Was running into the following error while installing JIRA: “Network error IOException: Connection refused”. It seems that the SQL Server Express installer doesn’t enable the TCP/IP protocol by default.

Read More →

Azure Subscription Selection

Azure Subscription Selection

When the Azure PowerShell commands aren’t returning any data well then you might have to select a default Azure subscription. I tend to forget the Azure Subscription Selection step and therefore created this post. Just to remind myself and perhaps a couple of others.

The following page will guide you to the process of setting up on how to install and configure Windows Azure PowerShell http://www.windowsazure.com/en-us/documentation/articles/install-configure-powershell/ however you will need to make sure to select the correct subscription.

Read More →