page contents
Tag Archives: 2014

SQL Server Compatibility Levels

Have you ever wondered what versions of SQL Server related to the compatibility levels? This article will show you the levels and also how to change existing databases to different SQL releases. This is a list of all SQL Server Compatibility Levels: Product Database Engine Version Compatibility Level Designation Supported Compatibility Level Values SQL Server […]

Leave a comment Continue Reading →

Upgrading from SQL Server Evaluation Edition

This article will provide you with a step-by-step set of instructions on how to upgrade a SQL Server 2012 or 2014 evaluation edition to an Enterprise edition. Similar steps can be used to upgrade to any other licensed editions, Developer, Standard or Enterprise. Long story short, changing an edition from an evaluation version to another one does […]

Leave a comment Continue Reading →

HOW TO: Determine SQL Server Evaluation Period

Today, I want to talk about how you can determine if you using an evaluation copy of SQL server and also how to determine when that period is over, before you get the pop warning listed below: If you are like me, you are constantly building systems and then tearing them down for testing. In […]

1 Comment Continue Reading →

SQL Saturday #493 (Silicon Valley)

I have been really lucky the past two weeks as I was able to attend two separate SQL Saturday events back to back. For me, it is a day where I can both learn and talk with others about my passion with Microsoft SQL Server. The latest SQL Saturday #493 in Mountain View, CA (Silicon […]

2 Comments Continue Reading →

How to: Move SQL Databases (System)

This is the second article about moving system databases and I just got motivated writing it after reading Erik Darling‘s article Moving Databases with ALTER DATABASE. I wrote my rough draft in an earlier article (that I ended up putting up on my site) on how to move system databases in SQL Server 2008R2. In […]

2 Comments Continue Reading →

Cannot connect to WMI provider. You do not have permission or the server is unreachable.

  Recently, I had an issue where I installed SQL server with the default users to start the services. Later when I tried to change the service accounts to my active directory accounts, I got the following error message when trying to open SQL Server Configuration Manager.   I read that message “Cannot connect to […]

3 Comments Continue Reading →
Copy Protected by Chetan's WP-Copyprotect.