page contents
Archive | SQLServerPedia Syndication RSS feed for this section

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 →

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 →

Microsoft Access Data Types

As stated on Monday, I have started a series on different database types for various data programs. (Microsoft SQL Server, MY SQL and Access) My goal here is to document the different data types and categories that reflect basic information about them. This is the Microsoft Access Data Types (for old school reasons) Data type […]

Comments Off on Microsoft Access Data Types Continue Reading →

MySQL Data Types

As stated yesterday, I have started a series on different database types for various data programs. (Microsoft SQL Server, MY SQL and Access) My goal here is to document the different data types and categories that reflect basic information about them. Here are the MySQL data types and the three main types are Text, Number, […]

Comments Off on MySQL Data Types Continue Reading →

SQL Server Data Types

I am going to start a series on different database types for various data programs. (Microsoft SQL Server, MY SQL and Access) My goal here is to document the different data types and categories that reflect basic information about them. For more detailed information, please see this article Data Types (Transact-SQL)  and also Paul S. Randal did […]

7 Comments Continue Reading →

Preparing for interview loops

As usual, the views and opinions expressed in this article are mine and do not necessary state or reflect those of Microsoft. This is part two of this series and you can look at part one here to get caught up. Today, we will talk about getting ready for a hiring loop, which is basically a three-step […]

1 Comment Continue Reading →

Navigating Microsoft’s employment opportunities

Have you ever wanted to work at Microsoft Corporation, but was a little taken back by the process? One question that I have received a lot is what is it like to interview with Microsoft or what the environment is like or the sheer amount of contractors, etc. Some people have expressed interest in these opportunities and […]

1 Comment Continue Reading →

1 year anniversary as a blogger

Hard to imagine that a web site (this one) that I decided to put together is now 1-year-old. On December 6, 2011, I wrote my first article, which was called a Brief Introduction to Windows Azure and I was exposed to the world. After that first blog post, I continued to write many more articles with […]

Comments Off on 1 year anniversary as a blogger Continue Reading →

Sorry for the silence…

Hello everyone and I hope all is going well with you. Some of you may have been wondering where I went or trying to figure out the reason for my MIA status during the past month and a half.  This article will solve some of that mystery. 🙂 A month ago I took a new job […]

Comments Off on Sorry for the silence… Continue Reading →

How To: Upgrade SQL Server 2012 (RC) to Release (RTM)

If you’ve been working with the Release Candidate (RC) version of SQL Server 2012 (formerly code-named “Denali“), you are likely aware that the final release is now available as an evaluation download here, or from MSDN with in the Standard, Business Intelligence, and Enterprise editions. If you want to perform a straight upgrade from the […]

1 Comment Continue Reading →

VIDEO: VPC to VPC with OpenSWAN

The information provided in this video is meant as a tutorial. It is not the final word on security or setup for your particular case. In Simpler terms: USE at your own risk. That said, I hope it helps. Loading the player … Notes for VPC-to-VPC-with-OpenSWAN: yum install openswan chkconfig ipsec on *********************************************************** Singapore Setup […]

11 Comments 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 →

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