page contents
Tag Archives: sql

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 […]

Comments Off on Upgrading from SQL Server Evaluation Edition 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 →

SQL Saturday #511 (Redmond)

One of the things I really look forward to recently is SQL Saturday as it is a day where I can both learn and talk with others about my passion with Microsoft SQL Server. The latest SQL Saturday #511 in Redmond on 2 April 2016 was no exception to this wonderful community of SQL server […]

Comments Off on SQL Saturday #511 (Redmond) Continue Reading →

FIX: SQL Server Management Studio and 4k Monitors

With the latest releases of Intel processors and especially starting with the 4th generation (“Haswell” processors) to the latest 6th generation (“Skylake” processors) that are shipping with graphic cards that allow for 4k resolution. Well, most people are happy with the extra high definition, there are many others who state that the only complaint is […]

Comments Off on FIX: SQL Server Management Studio and 4k Monitors 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 →

How to: Move SQL Databases (User)

This is an article that I have been meaning to write for a while 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 […]

Comments Off on How to: Move SQL Databases (User) Continue Reading →

Moving the System Databases in SQL Server 2008R2

One of the more common tasks you will encounter in moving a system or user database from one physical location to another location. For example, Microsoft recommends that we place our backups, data files, transaction logs and tempdb files on four separate drives. However, the installer by default will place the system databases (Master, Model […]

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 →

How TO: Create SQL Central Management Server and Server Group

One of the cool things that was added a few years back was the Central Management Servers feature. It was introduced in the Standard and Enterprise editions of SQL Server 2008. This feature helps DBAs to maintain multiple SQL Server instances across an enterprise environment and provides two major benefits when multiple SQL Server instances […]

5 Comments Continue Reading →

Configuring SQL Server 2012 Always On Lab- Part 4

In my last article I talked about setting a domain for my lab environment for a SQL Server 2012 AlwaysOn Availability Group. This is the last article of a 4 part series that covers the entire process. Initial Setup Domain Setup Cluster (Shared nothing) Setup SQL Install The first thing I do when creating a […]

1 Comment Continue Reading →

Configuring SQL Server 2012 Always On Lab- Part 3

In my last article I talked about setting a domain for my lab environment for a SQL Server 2012 AlwaysOn Availability Group. This is the third of a 4 part series that covers the entire process. Initial Setup Domain Setup Cluster (Shared nothing) Setup SQL Install One of the really cool new features is the […]

1 Comment Continue Reading →

Configuring SQL Server 2012 Always On Lab- Part 2

In my last article I talked about setting a lab environment for a SQL Server 2012 AlwaysOn Availability Group. This is the second of a 4 part series that covers the entire process. Initial Setup Domain Setup Cluster (Shared nothing) Setup SQL Install I begin this process by installing the following VM’s (all with the […]

3 Comments Continue Reading →

Configuring SQL Server 2012 Always On Lab- Part 1

This is a long overdue topic that I have wanted to cover for a couple of years and have finally got a chance to setup for a lab environment. I wanted to expand upon Brent Ozar’s article: How to Set Up SQL Server 2012 AlwaysOn Availability Groups. I also used Brent’s SQL Server 2012 Availability […]

8 Comments Continue Reading →

Types of MSSQL Joins

In Microsoft SQL Server, we have four types of joins. We use these joins to fetch data from multiple tables that are based on a condition. A join condition is a relationship among some columns in the data tables that take part in SQL join. Basically data tables are related to each other with keys. […]

1 Comment Continue Reading →

Language components of Structured Query Language (SQL)

Recently, I have been working on improving my querying ability in Microsoft SQL and have been reading Itzik Ben-Gan’s book. I thought I had written this topic in an earlier and to my surprise I was wrong. A good fundamental bit of information to know as I progress through data structures and the language used to […]

Comments Off on Language components of Structured Query Language (SQL) Continue Reading →

How does Instant File Initialization Help Your Databases?

In an earlier article, I spoke about a Best Practice called File Initialization. I walk you through setting it up I pointed you to a blog by Kimberly Tripp. Today, I want to show you how much time it will save you. I know this may seem like a silly question, but don’t you want […]

1 Comment Continue Reading →

Improvements with SQL Server 2012 SP1 CU2 and Sysprep

Good news came out earlier this month when Microsoft released Cumulative update package 2 (CU2) for SQL Server 2012 Service Pack 1. It can be downloaded here and if you are new to CU packages, there are not like a regular Service pack or Windows update. These CU fixes are not as tested as regular […]

Comments Off on Improvements with SQL Server 2012 SP1 CU2 and Sysprep Continue Reading →

Troubleshooting a SCVMM 2012 transport error

Last week, I had someone reach out to me asking for help with a new SCVMM 2012 server. It was a new installation and for the most part it worked well for them during the past month. However, recently they started seeing the error below, which prevent them access to the Virtual Machine Manager: At […]

Comments Off on Troubleshooting a SCVMM 2012 transport error Continue Reading →
Copy Protected by Chetan's WP-Copyprotect.