page contents
Tag Archives: r2

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

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 →

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

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 →

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

Comments Off on How to Fix: 0x800F0906 and 0x800F081F Error Messages while installing .NET Framework 3.5 in Windows 8/8.1 Continue Reading →

Windows 8.1 Update: Improvements and Changes

As you are aware, the last few articles that I wrote about are regarding the Windows 8 Start Menu. I talked about creating new shortcuts and how to navigate easier with the start menu. On April 15, 2014, Microsoft released this software, which you could get the latest update from with Windows Update or from […]

Comments Off on Windows 8.1 Update: Improvements and Changes Continue Reading →

Adding Shortcuts to the Windows 8 Start Menu

One of the main concerns with the Windows 8 Start Menu is that it changed the end user experience and software behavior that people had gotten used to with Windows. Last week, my article discussed how you can navigate easier with Windows key shortcuts, like using the Windows+X. (As seen below) In addition to using […]

3 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 →

Hardware Changes in Windows 2012 RS VM’s

I have been reading a few of the latest Ebooks from Microsoft press lately: Introducing Windows Server 2012 R2 Introducing Windows Azure for IT Professionals In this book, I felt it gave one of the better summaries of the new changes with Hyper-V and I am just copying a section from them as seen below. […]

1 Comment Continue Reading →

HOW TO: Find the Physical host of a VM in Hyper-V

With the rising popularity of virtual machines, you may find yourself one day logging into a server troubleshooting an issue. Then all of a sudden it occurs to you that you are not sure if this machine is Physical or Virtual. Better yet you know this is a VM, but you are not sure which […]

2 Comments Continue Reading →

Creating a SQL Server mirror on an existing mirror

This is an article that I have been meaning to write for months. It was very exciting for me when I was trying to solve this issue and I was even more pleased with performing this task when I found a few DBA’s had never attempted this operation. I want to share that knowledge with […]

1 Comment Continue Reading →

Extend Windows 2008 R2 “activation grace” period

If you are like me, you might be testing new machines in a lab environment or making videos or blogs about new features. Virtualization has helped in numerous ways to facilitate this new learning. It helps to spin up new machines to test or validate these many different configurations. You also might be like me […]

7 Comments Continue Reading →

Update to an earlier article… Ola Recommendations for his script

Hey everyone, sorry for the delay in writing new content, but a lot of stuff has been going on for me. For the meantime, I will just say that the change of everyday life and the challenges (or opportunities depending on your point of view) that it will present you as we do our best to get […]

1 Comment Continue Reading →

Introduction to SQL Server Recovery Advisor

Backup and more importantly Restore operations are essential database maintenance tasks. I think Buck Woody said it best; we do not have a backup strategy as much as a restore strategy that defines our worth to an organization. You can watch his comment here Session1: Blitz! SQL Server Takeovers Having a good backup and restore plan in […]

1 Comment Continue Reading →

OLA Recommendations for his script

In an earlier article, I spoke about Ola Hallengren’s highly recommended database maintenance scripts. Today, I want to talk a little bit more about configuring his script in hopes that you don’t just download it and click execute without making some changes. Before I even think about executing Ola’s maintenance script, I configure SQL server to […]

3 Comments Continue Reading →

HOW TO FIX: RESTORE cannot operate on database because it is configured for database mirroring.

Recently a friend of mine asked me for help when he was not able to get a database out of restoring mode. When he tried to restore the database to the latest backup, he got this error message below: Msg 3104, Level 16, State 1, Line 1 RESTORE cannot operate on database ‘VirtualManagerDB’ because it […]

Comments Off on HOW TO FIX: RESTORE cannot operate on database because it is configured for database mirroring. Continue Reading →

SQL Server Default Database Backup Syntax Values

Every so often I see an article talking about TSQL Database backups and they give an example like the one below: BACKUP DATABASE [AdventureWorks]  TO DISK = N’C:\MSSQL11.MSSQLSERVER\MSSQL\Backup\AdventureWorks.bak’ WITH NOFORMAT, NOINIT, NAME = N’AdventureWorks-Full Database Backup’, NOSKIP, REWIND, UNLOAD, STATS = 10  GO Or I may run into a co-worker or friend who passes along a SQL backup job and I see the […]

Comments Off on SQL Server Default Database Backup Syntax Values Continue Reading →
Copy Protected by Chetan's WP-Copyprotect.