Cannot install SQL Server 2005 after SQL Server 2008 on Windows Server 2008? Microsoft’s update KB950636 is the fix for resolving conflict between the two.
SQL SERVER – Identifiers As Valid Object Names
Chi-Ho Min found you can skip parts of a four part name with dots, like servername…tablename. Here is how identifiers work as valid object names.
SQL SERVER – Is Cursor Database Object or Datatype?
Whenever we want to loop something we always look for logic like WHILE LOOP or FOR LOOP. Trust me on my word that both of them are cursor when it is about SQL Server.
SQL SERVER – Generate Foreign Key Scripts For Database
Madhaiyan Seenivasan’s stored procedure lets you generate foreign key scripts for a whole database, handy when you drop all foreign keys and add them back.
SQLAuthority News – My Favorite Link of This Blog
After 500 articles, readers ask which link I click the most. My favorite link opens a random article of this blog, and I would love to hear where you land.
SQL SERVER – 2008 – Row Constructors – Load Temp Tables From Stored Procedures
Load temp tables from stored procedures with a simple INSERT INTO EXEC instead of a loopback OPENQUERY. Here is the before and after code.
SQL SERVER – Surface Area Configuration Tools Reduce Exposure To Security Risks
My SQL Server Magazine article explains how Surface Area Configuration tools reduce exposure to security risks on your SQL Server.
SQL SERVER – SQL Slammer (Computer Worm)
Is there any virus associated with SQL Server? A DBA’s question led me to SQL Slammer, the computer worm that slowed down Internet traffic in January 2003.
SQL SERVER – 2008 – Important Resources
At a speaking event I promised to list Important Resources for SQL Server 2008: links on data programmability, spatial data, webcasts, labs and training.
SQL SERVER – 2008 – Download Presentation and Whitepapers
Download presentation and whitepapers for SQL Server 2008 sessions, covering the new manageability improvements, the Business Intelligence platform and more.