T-SQL Tuesday #108: New Horizons Beyond SQL Server
There comes a point in one’s career when a change is requisite. Big or small there always seems to be...
2018-11-21 (first published: 2018-11-13)
2,129 reads
SQL RNNR
T-SQL Tuesday #108: New Horizons Beyond SQL Server
There comes a point in one's career when a change is requisite. Big or small there always seems to be a tipping point that mandates some sort of change....
2018-11-13
3 reads
Audit Database Offline Events
Knowing when an event occurred within the database environment is a very important thing. Being able to act quickly when...
2018-11-13
996 reads
Audit Database Offline Events
Knowing when an event occurred within the database environment is a very important thing. Being able to act quickly when certain events occur is equally as important. Sometimes, we...
2018-11-13
7 reads
Refresh SQL Modules
As is true in most facets of life, things tend to get stale and old. Sometimes this staleness can be...
2018-11-09
2,307 reads
Refresh SQL Modules
As is true in most facets of life, things tend to get stale and old. Sometimes this staleness can be visibly represented as the wrinkles on your face. Other...
2018-11-09
28 reads
Cannot Use the Special Principal – Back to Basics
I recently had a client call me out of the blue because he happened to be getting an error while...
2018-11-21 (first published: 2018-11-07)
2,579 reads
Cannot Use the Special Principal – Back to Basics
Cannot use the special principal 'dbo'. This error message can be misleading. This article will take you on a journey of common mis-steps along with the appropriate fix for...
2018-11-07
441 reads
Quickly Change SQL Job Owners
It is not unusual to find a server where some random user created a bunch of jobs to be run...
2018-07-26 (first published: 2018-07-16)
2,487 reads
Quickly Change SQL Job Owners
It is not unusual to find a server where some random user created a bunch of jobs to be run by SQL Agent. Sometimes, the user creating the job(s)...
2018-07-16
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