Unwanted dependency between different parts of the code
Small systems tend to grow with new functionality and new access points. When the system grows, the need for data...
2012-08-16
1,129 reads
Blog Posts
Where’s My Certificate Backup?
If you’re like me, you take advantage of the default backup paths in SQL Server. It makes my code cleaner,...
2012-08-16
1,957 reads
#meme15: Reasons I Like My Job
When Jason ( B | T ) posted this assignment, I thought it would be a fun topic to write on. Before I...
2012-08-15
507 reads
At the End of One Chapter and the Beginning of a New Chapter
I have been told by hundreds of DBAs that I have the best DBA job in the world as Director...
2012-08-15
1,107 reads
Being Right, the Other Side
I read an excellent article by Camille Fournier about the importance of recognizing that being right is not the only...
2012-08-15
842 reads
Dealing with negative session ids
Hello? Mr. DBA? Have you got a moment?
So there you are, enjoying one of the few quiet moments of your...
2012-08-15
5,295 reads
Dear #SQLAwesomesauce: Is this idea batsh** crazy?
I’ve been out of town and off the grid – nothing like 10 days of family camping and roadtripping to unwind!...
2012-08-15
867 reads
Excel 2013 and BI
On July 16, 2012, Office 2013 Preview was released to the public (download). Excel 2013 now includes a lot of the...
2012-08-15
1,853 reads
Find failed SQL Agent jobs using Transact-SQL script
Today, I’m sharing the following T-SQL script which you can use to find which SQL Server Agent Jobs failed yesterday....
2012-08-15
2,303 reads
JSSUG Speaker Idol 2012
The Jacksonville SQL Server User Group (JSSUG) has always encouraged new talent to be added to the pool of local...
2012-08-15
1,103 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