I like to disable guest account access in SQL Server unless there is a real need for it. Here is why the guest user can be a serious security issue.
Translating Oracle CONNECT BY Queries to Recursive CTEs
Translate CONNECT BY into recursive CTEs with root selection, depth, paths, sibling ordering, cycle checks, and a recursion limit.
SQL SERVER – Case Sensitive Database and Database User – Fix: Error: 15151 – Cannot find the user , because it does not exist or you do not have permission.
Jeff hit Error 15151, cannot find the user, even though the user existed. The cause was a case sensitive database, and here is the fix.
SQL SERVER – Solution Part 2 – A Quick Puzzle on SQL JOIN and NULL – SQL Brain Teaser
Part 2 of the solution to my puzzle on SQL Join and NULL. Readers still email me answers every day, so here are more of the good ones they sent.
Numbers Table vs GENERATE_SERIES: Building Rows on Demand
Learn numbers table in SQL Server with practical examples, clear checks, common traps, and guidance for your own database.
T-SQL Errors and Reactions in SQL Server: SQL in Sixty Seconds #002
T-SQL errors and reactions are the subject of this early SQL in Sixty Seconds episode with Rick Morelan. The tests here show which errors stop one statement, which stop the whole batch, and how XACT_ABORT, TRY CATCH and THROW change the reaction.
What Is Big Data? A Simple Explanation for Database People
What Is Big Data? It is the point where data outgrows one machine, and the fix is to scale out. This post explains the failures of one server and walks through 40 TB split across 8 nodes.