#tsql2sday is a monthly blog party on the second Tuesday of each month. Everyone is welcome to participate, so no matters you are an experienced blogger or you just want to start…
Category: Articles
Articles mostly focused on SQL Server technologies
Successful Anti-Patterns, Using Deprecated Data types
From time to time it’s good to remind people about the complexity of a product such as SQL Server. The internals are so wide and complex that we easily get lost and…
Spring cleanup, LOB considerations
For DBA’s it is important to have the ability to recover databases quickly in case of disaster. In order to maximize the potential we need to have our databases ready but sometimes…
Not the typical story about key lookups
Query plans are very useful to tune queries, but some operations are usually avoided or blamed for performance problems when not always are the culprit, let me show you one of those…
T-SQL Tuesday #88 – The security audit WTF
In this post I want to share the stored procedure I wrote to audit the different logins and server permissions within an instance. This post is part of the T-SQL Tuesday,…
Benchmarking storage using Diskspd.exe
One of the most important things when something goes wrong is to have an idea how your environment looks like in a normal day. Let me show you how to easily get…
Statistics and Data types, What can go wrong?
One of the most interesting things in SQL Server are Statistics. Today I want to write about the creation and update. One of the most interesting things in SQL Server from my point…
Playing with Azure, File Snapshot backups
This week I want to go another step into moving databases to the cloud and start using some advanced features that Azure offers Last post, we explored how to move part of our…
Playing with Azure, Stretching Databases
Whether we like it or not, the cloud is more and more present in our life as DBAs, so it is a good time to try understand some of the possibilities it…
In-Memory logging, much cooler than disk based
This week I want to look at one of the most important parts, in my opinion, that allow In-Memory to outperform and scale better than the traditional engine, and this is the…