How to Fail a Phone Screen
It’s funny to me how easy it is to fail a phone screen – both as the interviewer, and as the...
2013-11-29 (first published: 2013-11-18)
4,153 reads
SQL Awesomesauce
Compare tables to find missing rows
Let’s talk about the case where you want to compare tables to see what’s missing. We might be comparing a...
2013-11-14
917 reads
Quick note: Redgate SQL Data Compare using the command line
I’ve been working on an automated data compare process for one client. I’ve been struggling a little with odd hangups...
2013-10-22
1,140 reads
Liveblogging PASS Sumit Day 1 Keynote with Quentin Clark (#SQLPASS #Summit13)
Welcome to the live blog! Have some resources to start: Watch the keynote live here: http://www.passsummit.com #sqlserver Take a look at...
2013-10-16
513 reads
Next Week, in or out of Charlotte (#sqlpass #Summit13 #SQLHighTea #TooManyHashtags)
Welcome to Tuesday. We hope you enjoy your stay! Edit: We have been informed that today is actually Wednesday. We...
2013-10-09
533 reads
MidnightSQL Server Evaluation script, version 1.0
Server evaluations are a major part of my consulting business. I need to get up to speed very quickly on...
2013-09-30
1,255 reads
Interviews with Great SQL People – Authors, MVPs, many more
I’m trying really hard to write a blog that goes over all the great #sqlpass interviews we’ve done, but work...
2013-09-27
1,263 reads
SQL Tip: Get Log Space with DBCC SQLPERF(LOGSPACE)
Every so often I’m reminded that the “basics” aren’t really basics. None of us go to take “How to be...
2013-09-19
692 reads
Hit Fast Forward: Converting and deploying DTS packages
This one is just a quick shout-out to Pragmatic Works, and to Sean. Pragmatic Works made DTS xChange, which I...
2013-09-19
517 reads
#TribalSQL: A new book by new voices in SQL Server
Two years ago, we were talking about how cool it would be to get a bunch of unpublished authors to...
2013-09-17
519 reads
Blogs
Troubleshooting SQL Server – Starting with the Error Log
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
From OLTP to Analytics: Bridging the Gap with Modern SQL Architectures
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Solving SQL Server Mysteries with a Whole Gang of Sleuths -Scooby Dooing Episode 4
One thing I’ve always loved about the Scooby-Doo cartoon is that he never solved...
Forums
SQL Server 2025 Jobs
Hello SQL Server 2022 16.0.4212.1 running on a Windows Server 2025 Std,V 24H2, SO...
how to optimise whole database full of table and sp in one go using githubcopilo
i have subscription of github copilot which i can access in vs 2022 comunity...
Password Guidance
Comments posted to this topic are about the item Password Guidance
Question of the Day
Using table variables in T-SQL
What happens if you run the following code in SQL Server 2022+?
declare @t1 table (id int); insert into @t1 (id) values (NULL), (1), (2), (3); select count(*) from @t1 where @t1.id is distinct from NULL;See possible answers