page contents
Tag Archives: 2012

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 →

Navigating easier with the Windows 8.1 Start Menu

Windows 8/Server 2012 changed the way, user interacted with the desktop and safe to say at this point, a lot of people were unhappy with the new design. Personally, I feel it is a shame, because I feel that Windows 8/Server 2012 is the best operating system that Microsoft has released to date. I am […]

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

PowerShell Script to create a Shutdown/Restart/Logoff Windows 8 Tile for the Start menu

One of my more popular articles on this site, is the Finding the Start Menu in Windows Server 2012. It walks you through the basic changes of the new start menu. Most of the complaints that I have heard is that it hard to quickly reboot, shutdown or logoff a system or it is hard […]

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

Hyper-V limits with Windows Server 2012

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 that book. (Limits and new features) Here is a simple comparison of the different limits between Windows Server 2008 R2, Windows Server 2012 Release Candidate 1 […]

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

HOW TO: Go from Minimal Interface to CORE in Server 2012

In my last article, I spoke about a new cool feature of Windows Server 2012. The ability to go from a server GUI to Server CORE (or vice versa) without having to re-install the Operating System! You may ask yourself, “Why would I care about that?” To be blunt, Server CORE is very similar to the way most Linux […]

1 Comment Continue Reading →

HOW TO: Go from GUI to CORE and back to GUI in Server 2012

I have been preparing to upgrade my Windows and SQL certifications for 2012. I was checking out an article on switching from Server GUI to Server core. This article was written for Windows Server 8 Beta and was called How to Turn the GUI Off and On in Windows Server 2012. It gave me the […]

2 Comments Continue Reading →

Improvements with SQL Server 2012 SP1 CU2 and Sysprep

Good news came out earlier this month when Microsoft released Cumulative update package 2 (CU2) for SQL Server 2012 Service Pack 1. It can be downloaded here and if you are new to CU packages, there are not like a regular Service pack or Windows update. These CU fixes are not as tested as regular […]

Comments Off on Improvements with SQL Server 2012 SP1 CU2 and Sysprep Continue Reading →

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 →

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 →

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