T-SQL Tuesday #102: Giving Back
Last month we had the opportunity to discuss some of the most important tools for a data professional. I took...
2018-05-09
290 reads
SQL RNNR
T-SQL Tuesday #102: Giving Back
This is my diatribe about service and giving back to the community. When done properly, there is a natural born effect of enhancing one's personal life equal in some...
2018-05-09
2 reads
Change SQL Server Collation – Back to Basics
One of my most favorite things in the world is the opportunity to deal with extremely varying database and environment...
2018-04-19 (first published: 2018-04-12)
2,741 reads
Change SQL Server Collation – Back to Basics
Every now and again we have to deal with a sudden requirements change. When that happens, we sometimes just need to take a step back and evaluate the entire...
2018-04-12
112 reads
T-SQL Tuesday #101: Essential Tools
What are the tools you love to use? What are the tools that maybe need a little sharpening? What tools...
2018-04-10
371 reads
T-SQL Tuesday #101: Essential Tools
What are the tools you love to use? What are the tools that maybe need a little sharpening? What tools do you have that maybe you wish were the...
2018-04-10
4 reads
Syspolicy Phantom Health Records
SQL Server comes with a default SQL agent job installed (for most installations) to help manage the collection of system...
2018-04-17 (first published: 2018-04-06)
4,117 reads
Syspolicy Phantom Health Records
SQL Server comes with a default SQL agent job installed (for most installations) to help manage the collection of system health data. I would dare say this job is...
2018-04-06
71 reads
SQL Server Extended Availability Groups
It may come as no surprise to many that Microsoft has hastened the SQL Server development cycle. Furthermore, it may...
2018-04-01
410 reads
SQL Server Extended Availability Groups
It may come as no surprise to many that Microsoft has hastened the SQL Server development cycle. Furthermore, it may be no surprise to many that Microsoft has also...
2018-04-01
12 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