Announcing Minion CheckDB release date!
Minion CheckDB is the third piece of our free backup and maintenance tools, rounding out the list with Minion Backup...
2016-11-28
1,056 reads
SQL Awesomesauce
Fight harassment: be the “Backup” at PASS Summit
Harassment is a problem at some of the conferences we go to. What can we, as attendees and speakers and...
2016-10-11
401 reads
Step by Step: WHERE, GROUP BY, and HAVING
People new to SQL often have trouble with the difference between WHERE, GROUP BY, and HAVING…three separate clauses in the...
2016-10-07
617 reads
PASS Summit 2016: Recommendations and Invitations (#sqlpass #sqlsummit)
The last week of October, we’ll be at the PASS Summit in Seattle, WA. As some of you already know – and as I...
2016-09-06
499 reads
October precon in Orlando: “The Lifecycle Approach: Maintenance Problems & Solutions”
On October 7 we will be presenting a full day of maintenance and backup learnin’! Register here: https://www.eventbrite.com/e/sql-saturday-564-the-lifecycle-approach-maintenance-problems-solutions-tickets-26867268724 And while you’re at...
2016-09-05
470 reads
Conference speakers: Why do you teach at events?
I’ve put up a Twitter poll to find some answers to the question: Why do speakers teach at events? Especially at...
2016-08-29
834 reads
An MCM teaches COMMENTS at SQL Saturday OKC
Edit: SQL Sat OKC has come and gone, but the new session on comments is recorded and up on the MidnightDBA Events...
2016-08-26
485 reads
Tricky TSQL: NOT IN (NULL)
We’ve done this before, but we can go one better this time. Let’s take this step by step. NULL means...
2016-08-11
1,030 reads
Slash star, dash dash: Be obsessive about comments
I’m working on a new session* that I’ve named “T-SQL’s Hidden Support Feature”. It’s about comments. I’ll get to the...
2016-08-12 (first published: 2016-08-08)
1,987 reads
Feasel’s Grand Analysis of the PASS 600 mile radius rule
UPDATE: Last week, PASS announced an update to the 600 mile radius announcement: “…we will be piloting the 600-mile driving radius...
2016-08-10 (first published: 2016-08-01)
1,174 reads
Blogs
How to find free space in Azure PosgreSQL
I wanted to figure out how big (or approximately how big) my dump file...
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
Announcing SQL Server 2025
Comments posted to this topic are about the item Announcing SQL Server 2025
Running Steve's Code
Comments posted to this topic are about the item Running Steve's Code
New SQL Server 2022 Functions
Comments posted to this topic are about the item New SQL Server 2022 Functions
Question of the Day
Running Steve's Code
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc]
AS
SELECT Consumer_ID ,
Trend_Category ,
Bit_Trace
FROM NewWorldDB.dbo.MarketTrend;
GO See possible answers