Determining Default Trace Location
While working on some scripts against SQL Server’s default trace, I wanted to develop a sure fire way to find...
2013-01-09
1,810 reads
StrateSQL
Index Analysis Update – January 2012
In the past couple weeks, I’ve gotten a couple reports of issues with sp_indexanalysis. The update today fixes those issues....
2013-01-08
755 reads
SQL Saturday Fargo Update
It’s been a while since I mentioned anything about the SQL Saturday in Fargo. So I thought I would let...
2013-01-08
579 reads
January 2013 – Monthly SQL Server Checklist
Today is the first Monday of 2013. Do you know if your servers are ready to take on the first...
2013-01-07
683 reads
Last Weeks Top 10 “Reading” Links #14
Throughout the week, I like to tweet links to the things that I’ve been reading. Since they all come out through out...
2013-01-07
909 reads
Reblog: December 28 to January 3
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-01-04
1,040 reads
Last Weeks Top 10 “Reading” Links #13
Throughout the week, I like to tweet links to the things that I’ve been reading. Since they all come out through out...
2012-12-31
1,730 reads
Wrapping Up 2012
Last year, I did a wrap up post of the year to see where I landed from where I wanted...
2012-12-31
1,631 reads
Index Analysis Post Christmas Update
Last week I mentioned that I had put up a few new versions of my index analysis script. Turns out...
2012-12-28
704 reads
PASSMN Presentation Materials
Last week, I presented on extended events at the Minnesota SQL Server user group (PASSMN). The turnout was quite excellent...
2012-12-28
741 reads
Blogs
Data Skew in Data Engineering: What It Is and How to Fix It
You kick off a distributed job expecting it to finish in minutes — but...
SQL Server instance metadata inventory with PowerShell and SMO
By SQLPals
SQL Server instance metadata inventory with PowerShell and SMO The purpose...
5 SQL Tricks Worth Remembering Before You Close the Laptop
Disclosure: this post may contain links to books as an affiliate link. If you...
Forums
Fuzzy String Matching in SQL Server 2025
Comments posted to this topic are about the item Fuzzy String Matching in SQL...
Representing Money
Comments posted to this topic are about the item Representing Money
Celebrating 30 years of PostgreSQL, A Thank you message
Comments posted to this topic are about the item Celebrating 30 years of PostgreSQL,...
Question of the Day
Representing Money
Which types of currency does the money data type represent?
See possible answers