#tsql2sday is a monthly blog party on the second Tuesday of each month. #tsql2sday is a monthly blog party on the second Tuesday of each month. Everyone is welcome to participate, so…
Tag: SQL Server
SQL Server system databases 101
In this post I want to give a basic explanation of what system databases are and things we can or cannot do with them It was the other day during the networking time…
T-SQL Tuesday #92, Lessons learned the hard way
#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…
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…
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,…
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, 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…
Database Design Matters, Real World Scenario
Sooner or later the more you know how SQL Server works will help you come up with more and more ideas to solve your daily problems, let me show you what one…
Database Design Matters, choosing the Clustering Key
There has been a permanent debate about which is the right clustering key for our tables since the beginning of the time, this time I’ll get a bit deeper to show you…
Database design Matters, choosing the right data type
This is not the first time I write about best practices or how a good design can help even from a performance point of view, but today I’ll go to an earlier…