Once upon a time there was a database. The database was perfectly designed with beautiful tables and views accompanied by good-looking...

SQL Server 2012 is best known for its bombastic new features: AlwaysOn, Columnstore indexes, Window functions enhancements, Extended...

24 Hours of Pass is tomorrow. If you haven’t registered yet, now is a good time. I expect to: Have little to no sleep time See some cool...

It’s important to write the right code on the right server, since each mistake can be very expensive in this area. Below are a few common...

Imagine the following scenario: After a very nice weekend, you get up in the morning with a smile on your face, get to work and drink...

Cursors (and partially while loops) have a really bad reputation in the SQL Server world. Basically, there are three good reasons that...

Before I became a SQL Server DBA, I used to be a web developer in ASP3. Since then, I sometimes maintain the websites I still have. Fix...

Dynamic Search Queries SQL Injection is a widely known issue with databases that work as back-ends for websites and applications. In the...

SQL Server 2012 introduced a new feature – code snippets inside Management Studio. And even better, you can create your own snippets....

I came across Bob Beauchemin’s post, stating that the SQL Azure default isolation level is read committed snapshot. This is generally...