page contents
Tag Archives: microsoft

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

Leave a comment 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 […]

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

Leave a comment Continue Reading →

How to: Download files with Internet Explorer 11

A lot of people are dealing with the progressive nature of Microsoft, where products are being either introduced or updated (on average) every three years. It is both a blessing and a pain in the butt to deal as you navigate through the business world of today. Internet Explorer is no different and with the […]

Leave a comment 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 […]

Leave a comment Continue Reading →

How to Fix: 0x800F0906 and 0x800F081F Error Messages while installing .NET Framework 3.5 in Windows 8/8.1

Windows 8/8.1 is one of the newer Microsoft Operating systems and it comes built-in with the .NET 4.5 framework. However, there are many 3rd party software programs which still require .NET Framework 3.5 installed on your system. (Such as my personal favorite application SQL Server) In such cases you need to install the .NET Framework […]

Leave a comment 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 →
Copy Protected by Chetan's WP-Copyprotect.