Category Archives: Sql Server


SQL Server & JSON data

SQL Server, SQL Azure & JSON

At the moment, I’m working on a simple web reporting project. Given that this is a small-scale project, I’ve decided to try something new. Creating a tiny DAL responsible for retrieving and deserializing SQL Server generated JSON.

Read More →

SQL Server Connector – Azure API App – Part 1

SQL-Server-Connector

Within this series (well just two posts) I want to cover some of the available configuration options of the Azure API SQL Server connector. The connector simply enables you to connect with a SQL Server (as well as on-premises instances) or Azure SQL Database and perform various actions. This includes; executing stored Procedures, Poll data (triggers) and the option to retrieve, create, update and delete database table entries without having to write SQL.

Read More →

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 →