SELECT *
FROM Posts
WHERE Tags IN ('SQL Server')

Jan
2
2023

T-SQL Tuesday #158, Implementing Worst Practices

#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 writing about SQL Server, this is a real good chance…

Continue Reading »

Jul
18
2018

SQL Server system databases 101

It was the other day during the networking time in my SQL User group meeting when someone told the story of the new DBA that was joking about running “DROP DATABASE [master]”…

Continue Reading »

Jul
3
2017

T-SQL Tuesday #92, Lessons learned the hard way

ql2sday 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 writing about SQL Server, this is a real good chance to add something to the community Hello all and welcome to a new #tsql2sday…

Continue Reading »

Apr
26
2017

Successful Anti-Patterns, Using Deprecated Data types

From time to time it’s good to remind people about the…

Continue Reading »

Mar
14
2017

T-SQL Tuesday #88 – The security audit WTF

  This post is part of the T-SQL Tuesday, which is a monthly blog party on the second Tuesday of each month. Everyone is welcome and have the chance to write about…

Continue Reading »

Feb
9
2017

Statistics and Data types, What can go wrong?

One of the most interesting things in SQL Server from my point of view are Statistics and how the optimizer interprets them to produce optimal query plans. But today I want to write about something…

Continue Reading »

Jan
3
2017

Playing with Azure, Stretching Databases

It’s been a while since my last post, and I wanted to keep exploring some of the new features that SQL Server 2016…

Continue Reading »

Nov
3
2016

Database Design Matters, Real World Scenario

Disclaimer: This is how I solved a particular problem after analyzing and understanding my data….

Continue Reading »

Sep
21
2016

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…

Continue Reading »

Sep
6
2016

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…

Continue Reading »