When not to use Management Reporter
Management Reporter is easy to use to create Management Reports and it does not require a developer to do it....
2017-07-16
456 reads
How to display more text in SSMS
Today’s blog post is going to be a short one but can be very helpful if you’re new to SQL...
2017-07-28 (first published: 2017-07-14)
12,344 reads
Friday Reading 2017-07-14
Fun week, and what a Lions final test last weekend. Still can’t believe it!
Here’s what I’ve been reading…
STOPAT And Date...
2017-07-14
294 reads
SQL Server 2017 – DMV – sys.dm_os_host_info
I always love to get my hands dirty with new features of SQL Server. I was exploring SQL Server on...
2017-07-27 (first published: 2017-07-14)
2,189 reads
My Evening With SQL Tool Service
Hello!
I’ve been writing a PowerShell Module that will handle deploying SQL Server Agent Jobs by using the Agent namespace in...
2017-07-13
245 reads
No, Binary Collations are not Case-Sensitive
Quite often people will use, or will recommend using, a binary Collation (one ending in “_BIN” or “_BIN2“) when wanting...
2017-07-13
2,154 reads
Default reports in SSMS
As DBAs our stock in trade is information and there is certainly an impressive amount available. The diagnostic views are...
2017-07-27 (first published: 2017-07-13)
2,635 reads
Point Counterpoint: Why Virtualize a SQL Server?
I get asked all the time – “why virtualize SQL Server if I’m content with my physical servers today?” The normal...
2017-07-24 (first published: 2017-07-12)
3,127 reads
LocalDB DSC Script
Hello!
So, there are many different product SKUs of SQL Server available, and generally when developing it’s probably best to use...
2017-07-12
295 reads
Be Wary of Date Formatting in T-SQL
Today’s public service announcement is a reminder to be wary of date formatting in SQL Server. On a recent mailing...
2017-07-12
159 reads
Blogs
Flyway Tips: Object History
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Forums
Looking for old SQL Server 1.x - 4.21 disks, manuals, boxes, etc.
Hi everyone, I'm hoping some of the longtime SQL Server professionals here might be...
Checking the Error Log II
Comments posted to this topic are about the item Checking the Error Log II
Parameter Sniffing on SQL Server 2025: A Walkthrough with Real Numbers
Comments posted to this topic are about the item Parameter Sniffing on SQL Server...
Question of the Day
Checking the Error Log II
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers