Today is the first birthday of this blog: 365 posts in one year, one a day. Thank you to my readers, my family and SQL Server Magazine.
SQL SERVER – Importance of Master Database for SQL Server Startup
I have received following questions. I will list all the questions here and answer them together.
What is the purpose of Master database?
SQL SERVER – Business Intelligence (BI) Basic Terms Explanation
Business Intelligence basic terms explained in plain words: BI, data warehouse, data mart, cube and more, so the BI vocabulary is easier to follow.
SQL SERVER – Disable All Triggers on a Database – Disable All Triggers on All Servers
How to disable all triggers on a database and on the server, which kind of trigger each command touches, and how to turn them back on safely.
SQL SERVER – 2008 – Server Consolidation WhitePaper Download
A Microsoft white paper on Server Consolidation with SQL Server 2008, plus the checks I make before I move many databases onto one server.
SQL SERVER – 2005 – Get Current User – Get Logged In User
How to get current user for a query in SQL Server 2005: SELECT SYSTEM_USER returns the name of the current context, which helps with debugging and security.
SQL SERVER – Deterministic Functions and Nondeterministic Functions
Deterministic functions like ABS, DATEDIFF and ISNULL always return the same result for the same input. Nondeterministic functions like NEWID and RAND do not.