Closed Object Explorer by mistake or moved windows around? Here is a cool trick for restoring the default SQL Server Management Studio window layout.
SQL SERVER – guest User and MSDB Database – Enable guest User on MSDB Database
I advise disabling the guest user in user databases, but it should stay enabled in the MSDB Database. Here is why, and how to enable it again if it was turned off.
SQL SERVER – Detecting guest User Permissions – guest User Access Status
Is the guest user enabled or disabled, and what is the default? I answer reader questions and show ways to detect guest user access status.
SQL SERVER – T-SQL Constructs – Declaration and Initialization – SQL in Sixty Seconds #003 – Video
In SQL in Sixty Seconds #003, Vinod Kumar shows T-SQL constructs for declaration and initialization of variables, a simple trick to save time.
SQL SERVER – Force Removing User from Database – Fix: Error: Could not drop login ‘test’
Error 15434: could not drop login ‘test’ because the user is logged in. A reader ran my demo on production; here is my Force Removing User fix, no restart needed.
SQL SERVER – Disable Guest Account – Serious Security Issue
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.