T-SQL Tuesday #56: Assumptions
I assume that since it’s the second Tuesday of the month that it’s time for T-SQL Tuesday. And you can...
2014-07-08
850 reads
Blog Posts
Upcoming Free PASS VC Webcasts
Here is a list of upcoming webcast presented by various PASS Virtual Chapters that are always free. Some are recorded...
2014-07-08
599 reads
Which One’s Better?
During a recent webcast, someone asked if, in an EXISTS query, it is better to use “SELECT *”, “SELECT ‘1’”, or...
2014-07-08
497 reads
Worst Day of a DBAs Life
Red Gate Software is running a campaign around coping with the worst day of a DBAs life. We’ve been posting...
2014-07-08
867 reads
[BP017] DELETE statement without WHERE clause
Sometimes people ask me: "What wrong with following code? Why issue BP017 is registered?"
delete d
from dbo.Data d innerjoin #ids i...
2014-07-07
663 reads
Collaborated Training: What Legacy Will You Leave?
My very first IT job was a bit daunting for me. I really wanted to do my best but I...
2014-07-07
543 reads
Editorial: Cloud Skills
Cloud Skills is the editorial today, thinking about the changes we see in the boxed product versus the cloud and...
2014-07-07
1,013 reads
Free SQL Training In Sacramento
In a few short days the newest SQL Saturday event. This one will be on the far West coast of the United States. This marks the first time for...
2014-07-07
8 reads
Free SQL Training In Sacramento
In a few short days the newest SQL Saturday event. This one will be on the far West coast of...
2014-07-07
474 reads
How to change TempDB system Database files location?
Steps to change TempDB system Database files location :- 1) Check current file location of TempDB Exec SP_helpDB TempDB You can use below query as well for file location...
2014-07-07
16 reads
Blogs
PostgreSQL: Diagnosing and Fixing a Sequential Scan with No Filter Predicate
A sequential scan is not always a problem — PostgreSQL's planner often chooses one...
Giving AI Agents Visibility Into SQL Server with MCP
I’ve been thinking a lot lately about what it actually takes to make an...
The Book of Redgate: Profits
By Steve Jones
Redgate is a for-profit company. We look to make money by building and selling...
Forums
Stop Prompting Your AI Agent. Give It a Playbook.
Comments posted to this topic are about the item Stop Prompting Your AI Agent....
Finish the quote
Comments posted to this topic are about the item Finish the quote
Everything I Needed to Know Used to be Found in One Book
Comments posted to this topic are about the item Everything I Needed to Know...
Question of the Day
Finish the quote
Finish this quote (for a fun Memorial Day question):
Do not try and bend the spoon. That's impossible. ...See possible answers