DBCC Shrink Fails with Error
Recently when shrinking a SQL Server data file, I ran into the following error: Before I get any grief about how bad shrinking databases is,… Read More »DBCC Shrink Fails with Error
TSQL Basics Part 5: SEMI JOIN – Video Explanation
This is part 5 “semi JOIN” of a 19 part series on TSQL Basics. You will first gain an understanding of the differences between each… Read More »TSQL Basics Part 5: SEMI JOIN – Video Explanation
TSQL Query to find the user the SQL services run as
Occasionally I need to look up what user the SQL Server services are running as, and when this happens, you can either run a quick… Read More »TSQL Query to find the user the SQL services run as
May Blog Post Wrap-up
TSQL Basics Part 4: RIGHT OUTER JOIN – Video Instruction Thu, 27 May 2021 This is part 4 of a 19 part series on TSQL… Read More »May Blog Post Wrap-up
Uninstalling R, Python and Java on SQL Server 2019
So you have upgraded to SQL Server 2019, and figuring that you got the new version, you may as well install all the features, including… Read More »Uninstalling R, Python and Java on SQL Server 2019
TSQL Basics Part 4: RIGHT OUTER JOIN – Video Explanation
This is part 4 “right outer JOIN” of a 19 part series on TSQL Basics. You will first gain an understanding of the differences between… Read More »TSQL Basics Part 4: RIGHT OUTER JOIN – Video Explanation
Checking job history log size with TSQL
One of the important settings on SQL Server is the job history log size and the maximum rows per job. Without these set accurately you… Read More »Checking job history log size with TSQL
TSQL Basics Part 3: LEFT OUTER JOIN – Video Instruction
This is part 3 on left outer JOIN of a 19 part series on TSQL Basics. You will first gain an understanding of the differences… Read More »TSQL Basics Part 3: LEFT OUTER JOIN – Video Instruction
Cannot drop the database because it is being used for replication
I have been doing more and more replication work lately, and when recently testing some replication work I needed to create and drop some test… Read More »Cannot drop the database because it is being used for replication
TSQL Basics Part 2: Inner Join – Video Explanation
This is part 2 “inner JOIN” of a 19 part series on TSQL Basics. You will first gain an understanding of the differences between each… Read More »TSQL Basics Part 2: Inner Join – Video Explanation