My wife asked me to install a named instance of SQL Server 2005 Enterprise Edition x64 on top our existing SQL Server 2008 R2 Enterprise x64. HA! As a SQL Server MCT (besides the fact that I did quite a few installs in my time) I should have known better how to do it. So … Continue reading Side-by-side installation of SQL 2008 R2 and SQL Server 2005
As I was playing in SSMS (SQL Server Management Studio), I created a table using the plain-old T-SQL, and then I decided to create a primary key, the "wizard" way, so to speak. Let's have a repro here: CREATE TABLE [dbo].[Employees] ( [empID] [int] NOT NULL , [firstname] [varchar](30) NOT NULL , [lastname] [varchar](30) NOT … Continue reading Is the primary key always clustered in SQL Server?
Today I'll post a quick one, since a simple Google search (yeah, Bing, sorry) did not yield too many useful results. Just as a quick note, make sure you have a chat with your sys admins; they can tell you whether the protocols are needed or not anymore. Okay, on with the tip: Go to … Continue reading How to Disable NetBIOS on the SQL Server Box
I must admit that I'm a huge fan of technology, but only from a distance. I decided to build my own mini-server at home, mainly to be able to run various things in a virtualized environment. Okay, how about Windows 2008R2 and Hyper-V? Good to go, since I have it for free as an MCT. … Continue reading Hypervisor not running and Intel not carrying
http://www.solidq.com/ce-en/News/Pages/Data-Quality-and-Master-Data-Management-with-Microsoft-SQL-Server-2008-R2.aspx - for those who know about Solid Quality Learning, you know what you'll get. For the rest of you out there, it doesn't get any better than this.