During a live demo, SQL Server refused to connect after a config change. Here is how to start SQL Server Service without tempdb. Never try this in production.
SQL SERVER – Scripting Tip: PowerShell to Identify Last Bootup Time
A friend from the networking team asked when his server was last started. Here is a quick PowerShell script to identify the last Bootup Time of a machine.
Interview Question of the Week #059 – What are the Limitations of User Defined Functions (UDF) ?
Interview Question of the Week – What are the Limitations of User Defined Functions (UDF) ? Let us learn about that in today’s blog post.
SQL SERVER – Starting Up Database – Why Multiple Times in Errorlog?
My instance took unusually long to come up, and the ERRORLOG showed ‘Starting up database’ many times for the same database. Here is why that happens.
COMPRESS_ALL_ROW_GROUPS: Forcing Delta Rowgroups Into Columnstore
One command turns an open delta rowgroup into compressed storage. Here is what it leaves behind, and why not to run it after every small load.
SQL SERVER – Attaching and Restoring Database in Clustering Generates An Error – Notes from the Field #115
Attaching or restoring a database on a cluster and getting an error? In Notes from the Field #115, Eduardo Castro explains what goes wrong with Clustering.
SQL SERVER – FIX Error 18456, Severity: 14, State: 6. Login failed for user
A reader hit Error 18456, Severity: 14, State: 6 while logging in. Here is what state 6 means and how to fix this login failed error.