page contents
Archive | EC2 RSS feed for this section

HOW TO: Use ROBOCOPY to Move SQL Files

As you know I recently blogged an article about attending SQL Saturday #493 in Mountain View, CA (Silicon Valley) and this is where I met Tim Ford (Blog | Twitter) for the first time. During his presentation, he asked for fellow bloggers to write about entry level topics. He stated that from time to time […]

Leave a comment Continue Reading →

Understanding the configuration file order for Wyse Thin Clients

Problem In an earlier article, I went over how you can configure your system to use a FTP server with DHCP option tags to automatically configure the device. Today, I am going to go over these configuration files, plus the processing hierarchy. My hope is that you will end up with the same conclusion that […]

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

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

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

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