page contents
Archive | August, 2012

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 →

New Tool: Microsoft® SQL Server® 2012 Performance Dashboard Reports

I been meaning to blog about this great feature for some time. It was released earlier this year, like way back in March of 2012. It is a report of your SQL server’s health in a very quick method and it is very simple, plus easy to install. Overview The SQL Server 2012 Performance Dashboard […]

Comments Off on New Tool: Microsoft® SQL Server® 2012 Performance Dashboard Reports Continue Reading →

Update: Creating the Windows 8/Server 2012 Start Menu

In an earlier article, I talked about Finding and then Creating the Start Menu for both Windows Server 2012 and Windows 8. In those earlier articles, I talked about Microsoft wanting to rid themselves of the Start Menu and clearly pointed out this one from CNET news. Well, today I want to confirm that it appears that […]

1 Comment Continue Reading →

Set the Command line properties (i.e. Quick Edit) with PowerShell

If you are like me, you get annoyed at having to do the same thing over and over… especially, if it is tedious and goes on for hours, I am sorry, but I get bored very easily in that situation. One thing I get to do a lot on a daily basis is log into many different […]

Comments Off on Set the Command line properties (i.e. Quick Edit) with PowerShell Continue Reading →

HOW TO: Use the Database Engine Tuning Advisor in Microsoft SQL Server

Before we begin, I want to provide a little background on this tool. Database Engine Tuning Advisor (DTA) is a component of SQL Server Management Studio, which is an integral part of Microsoft SQL Server, the database management application. This tool is used for improving query performances by examining the way queries are processed and […]

Comments Off on HOW TO: Use the Database Engine Tuning Advisor in Microsoft SQL Server Continue Reading →

Hyper-V limits with Windows Server 2012 Release Candidate

As stated in an early article of mine, there is a great free book from Microsoft Press that talks in good depth about Windows Server 2012. Today, I wanted to share some of the information that I learned from the book. (Limits and new features) Here is a simple comparison of the different limits between Windows Server 2008 R2, Windows Server 8 […]

Comments Off on Hyper-V limits with Windows Server 2012 Release Candidate Continue Reading →

SQL Server Maintenance Solution by Ola Hallengren

I have been meaning to talk about this topic for a while now and tonight I made sure that I put out the good news. Today, I want to introduce you to the SQL Server Maintenance Solution by Ola Hallengren which is a script that will create a series of scripts that will perform SQL agent jobs […]

1 Comment Continue Reading →

Announcing Better IOPS for Amazon EBS‏ Volumes‏

Provisioned IOPS are a new EBS volume type designed to deliver predictable, high performance for I/O intensive workloads, such as database applications, that rely on consistent and fast response times. One of the biggest complaints about Amazon Web Services has been disk performance. In order to get fast performance it has been necessary to use […]

Comments Off on Announcing Better IOPS for Amazon EBS‏ Volumes‏ Continue Reading →

Windows Server 2012 Release Dates

I got some great news for you and it is straight from a Microsoft’s blog Windows Server 2012 final release timing and that news is that they have provided release dates to Windows Server 2012. Release To Manufacturing (RTM): First week of August 2012 Release to General Public: 4 September 2012 These dates were also confirmed by another Microsoft […]

Comments Off on Windows Server 2012 Release Dates Continue Reading →

Free version of Hyper-V Server 2012: Game changer in the making

With Virtualization gaining more traction in all phases of business, competitors are getting better with their products. Most Virtualization vendors offer some sort of free Virtualization software today, that is capable of handling a small to medium load. With that being said, the free hypervisor space is a very important segment for IT pros getting […]

Comments Off on Free version of Hyper-V Server 2012: Game changer in the making Continue Reading →
Copy Protected by Chetan's WP-Copyprotect.