Over the last 30+ years of working with SQL Server, I have seen a lot of interview questions relating to SQL Server. I have been… Read More »What is your favorite SQL Server Developer Interview questions?
Current Stedman Solutions SQL Course Coupon Codes. Save Up to 65% Off our Popular Online SQL Server Courses, a Once a Year Type Savings! 65%… Read More »SQL Course Coupon Codes
When I first created this JOIN Types poster or cheat sheet back in 2013 I didn’t realize there was such a need for it. I… Read More »JOIN Types Poster Applause
Joining tables in SQL Server can be confusing and hinder your performance. I know because I have helped many confused people to understand their JOINs.… Read More »Understanding JOINs Month
Here is a quick CTE that can be used to generate all the dates in a range. This is handy to use when trying to… Read More »CTE to Find Dates in a Range
At Stedman Solutions, we do a lot of work with SQL Server replication, mostly transactional and merge replication. The other day I needed a query… Read More »TSQL To Show All Merge Replication Articles
One possible cause of the “Cannot resolve the collation conflict” error message is that your database collation doesn’t match the TempDB Collation. Recommendation for cannot… Read More »Cannot resolve the collation conflict
As part of documenting the craziness of this storm I have created a script that I run every 5 minutes that pushes data into a… Read More »Pulling PSE Outage Data Into SQL Server
One of the feature differences between SQL Server Express Edition and the other paid versions is the ability to schedule jobs or tasks using the… Read More »Using OSQL.EXE to run a scheduled task on SQL Server Express Edition
TL;DR summary: Don’t do it. Stop reading here if you want, but just don’t do it. This post refers to shrinking your database files (mdf,… Read More »DBCC ShrinkDatabase – I want to shrink my database.