Compare database schemas can be tricky, here I show you how I managed to compare thousands of databases’ schemas at once Working with databases is always fun and you never know what…
Category: SQL-G Hacks
You will need these hacks to be a Real SQL-G
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…
T-SQL Tuesday #112 – Dipping into your Cookie Jar
In this post I want to share those scripts that I use probably every day This post is part of the T-SQL Tuesday, which is a monthly blog party on the second…
T-SQL Tuesday #104 – Finding tables and columns in SQL Server
In this post I want to share a script that I use quite often because its flexility This post is part of the T-SQL Tuesday, which is a monthly blog party on…
Getting perfmon data into SQL Server, Part III
In this post I show you how to deploy in a simple way the solution previously proposed to Getting perfmon data into SQL Server to multiple servers running multiple SQL Server instances. I…
Getting perfmon data into SQL Server, Part II
This week we will retake my last’s post topic to finish that job off and get in and out our Perfmon data to and from our SQL Server. This week we will retake…
Getting perfmon data into SQL Server, Part I
In this post I want to show you how to create Data collectors in the Performance monitor and the different options we have to get the output and later on inserting in…
Using tokens in SQL Agent Jobs and renaming output files
In this post, I want to tell you about some useful feature that can be used within SQL Agent jobs in SQL Server This post I want to tell you about an error…
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…