Latest SQL Server Blog Posts
- TSQL Output Clause Course
The output clause is one of the wow factor query items, where when people see you use it the just go WOW, I did not know you could do that. I can remember working with a client and showing that to them and getting that same reaction of WOW. Have you seen our SQL short… Read More »TSQL Output Clause Course - SQL Server Connections by Database: Who Owns the Count?
When the instance connection total jumps, SQL Server connections by database shows which application is holding them. Here is how to read the split. - The SQL Login Nobody Remembers: Finding Accounts With the Password Policy Turned OffVendor installers leave behind SQL logins with CHECK_POLICY off, which means no complexity, no expiry and no lockout. Here is why they survive every review, what they cost, and how to fix them without breaking the application.
- Master Database Size: Read This Row Before the Megabytes
Is your master database size normal? Read the object count first, then the used and free split in each file, and only then the file size itself. - SQL Join Types Poster
Learn more about the Join Types poster. Compatible with SQL Server (TSQL) and MySQL. Check out the poster, it is a versatile, print-on-demand resource which you can customize according to your preference of size. This tool has been tailored to serve as a useful reference for both SQL Server developers and database administrators, simplifying the… Read More »SQL Join Types Poster