Latest Posts
-
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 ...
-
T-SQL Tuesday #155 –The Dynamic Code Invitation
In this post I’d like to share my views about Dynamic SQL 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 ...
-
FillFactor, the Untold Story
I love SQL Server internals, I do and I just said it. Why? because thanks to all the tools, documentation and community members that share their knowledge, folks like me can understand how a ...
-
How I Compared 1000’s of database’s schemas at once
Working with databases is always fun and you never know what can be knocking on your door, even when you think everything is under control. As the title of this post states, today I...
-
How to Update SQL Server Stats The Right Way
Here I am, trying to get back my habit and write about something useful I was working on the other day. If you ask me which SQL Server feature I love the most these days I’d say, without ...
-
Back In Business
Hello my Dear Readers! It’s been a while since I last wrote a blog post here, so I believe it’s time to change that. As some people that follow me on Social Media might...
-
T-SQL Tuesday #112 – Dipping into your Cookie Jar
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 SQL Server. This ...
-
Managing SQL Logins in different environments
Speaking of security, in SQL Server we have the possibility of authenticating in two different ways, one it is based on Windows Authentication and allow Windows users (from a local computer or ...
-
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]”...
-
T-SQL Tuesday #104 – Finding tables and columns in SQL Server
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 SQL Server. This ...