What is the difference between a candidate key and a primary key? A table can have many candidate keys, but only one of them becomes the primary key.
SQLAuthority News – Blog Makeover – New Banner – New Color
My blog makeover is here: a new banner with a brighter photo and new colors. This time, please leave your feedback as a comment, not an email.
SQL SERVER – Fix : Error : SQLDUMPER library failed initialization. Your installation is either corrupt or has been tampered with. Please uninstall then re-run setup to correct to correct this problem. in a modal dialog with the title SQL Writer
SQLDUMPER library failed initialization in a SQL Writer dialog does not mean you must reinstall SQL Server. Remove SQL Server VSS Writer and reboot.
SQL SERVER – Interesting Observation of Logon Trigger On All Servers
I created a Logon Trigger to audit every successful login for a client, and one login was recorded several times on different threads. The script and what I saw.
SQL SERVER – Find Hostname and Current Logged In User Name
Connected to many servers in SSMS? HOST_NAME() and SUSER_NAME() show the hostname and current logged in user for any query window.
Reading System Procedures With OBJECT_DEFINITION
Use OBJECT_DEFINITION and sys.system_sql_modules to read visible SQL Server system procedure text and learn how built-in tools work.
SQL SERVER – Introduction to Business Intelligence – Important Terms and Definitions – 2
Important terms and definitions in business intelligence, explained in plain words and grouped by how data moves from source systems to reports.