Just Check ALL the Boxes
Today I ran into something on a client server I unfortunately see too often. The DBA goes through the trouble...
2017-10-05 (first published: 2017-09-27)
1,661 reads
SQLEspresso
Hmmm… What’s This?
OK So, I am doing some digging and peaking around again in SQL Server and came across a database option...
2017-09-27 (first published: 2017-09-20)
2,048 reads
What does this little check box do?
Ever wander around SQL Server properties and wonder what these little check boxes turn on? I do, and I get...
2017-09-13
346 reads
Please Don’t Do This!
Please, please, please Admins do not leave your default index fill factor at 0. This means you are telling SQL...
2017-09-18 (first published: 2017-09-06)
3,896 reads
System-Versioned Temporal Tables
Every once in a while, I like to take a moment and learn something new about the latest SQL Server...
2017-08-30
1,192 reads
VLFs the Forgotten Foe
How many of you check the amount of Virtual Log Files (VLFs) your transaction logs have?
Working as a consultant now,...
2017-09-07 (first published: 2017-08-23)
2,052 reads
TIL: Microsoft Azure Part 2
Last week I started a multi-part series on Today I Learned (TIL) about Microsoft Azure. This is part two of...
2017-05-24
935 reads
TIL: Microsoft Azure Part 1
I thought maybe it would be a good idea to start a multi-part series on Today I Learned (TIL) about...
2017-05-17
531 reads
Blogging at SQLPerformance.com
I am honored to be a Guest Blogger at SQLPerformance.com. As a member of the SentryOne Product Advisory Council (PAC)...
2017-04-18
370 reads
Time for a Change
I am ecstatic to say I have joined Denny Cherry and Associates Consulting.
Lone No More
I am happy, excited, and nostalgic...
2017-04-17
359 reads
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers