Category Archives: Windows

Get a taste on the cloud: MS Azure Free Trial

Continuing with the inevitable move to the sky, and trying to self-quote myself here (well, self-post actually), I’m back to tell you that you can have one month of free experimentation with all Azure platform for free. You can set-up … Continue reading

Posted in Azure, BI, Cloud, SQLServer, Windows | Tagged , , , , , , | Leave a comment

How to install DSA.MSC on Windows 7 and Server 2008 / 2012

For Windows 7 you will need to download a package from Microsoft: Remote Server Administration Tools for Windows 7 with Service Pack 1 ¬†. Follow the great instructions in this link: http://tweaks.com/windows/40075/install-group-policy-and-ad-tools-on-windows-7/ For Windows Server 2008 and 2012, it’s just … Continue reading

Posted in Windows | Tagged , , , | Leave a comment

How It Works: SQL Server I/O Presentation by Bob Dorr

Once upon a time, in a server farm far far away… enough talk. I was researching some warning messages on my SQL boxes and came to this 2010 paper by one of the ¬†Microsoft Customer Service and Support (CSS) SQL … Continue reading

Posted in SQLServer, Windows | Tagged , , , , | Leave a comment

Tips for Exam 70-462: make your labs using Azure trial

The complexity of certification exams is climbing up lately – up to the clouds. Gone are the days where a simple 3 VM lab was enough to try out every new tech release to newer versions of some product – … Continue reading

Posted in Cloud, SQLServer, VMware, Windows | Tagged , , , , , | 2 Comments

MS SQL: New ways to test disk performance

Sometimes things get easier, better or simples. Actually we became spoiled to expect this kind of evolution from everything in the world, and this is not always the case. But sometimes it is. Jokes aside, a while ago I opted … Continue reading

Posted in SQLServer, Windows | Tagged , , , | Leave a comment

Red-Gate SQL Monitor: issues with Windows Registry

Earlier today I opened a topic on Red-Gate forums, about one issue I found while testing the soon-to-be-discontinued SQL Monitor Hosted service. That is a great service, and it was free while in beta, but unfortunately I did not have … Continue reading

Posted in SQLServer, Windows | Tagged , , , | Leave a comment

SQL: Database Mirroring over different domains

Soooooooo I’m back. I’ve never went away, actually. But time to write is always more rare. Today I wanted to share a small post about Database Mirroring. It’s one of the simplest ways to have “High Availability” for your databases, … Continue reading

Posted in SQLServer, Windows | Tagged , , , | Leave a comment

Using VS 2012 and SSMS 2012 together (SSIS bug)

Sometimes when you work with data, you have to move a lot of data around. And one of the best tools to do it is SSIS (Sql Server Integration Services). It’s a flexible solution to move almost anything to almost … Continue reading

Posted in SQLServer, Windows | Tagged , , , | Leave a comment

SQLServer: Unable to restore database – Msg 5118, Level 16, State 3

Nowadays storage is cheap (relatively) and the problems of shortage of space are less frequent. But sometimes they do happen. And some of these times, someone could think enabling NTFS Folder Compression is a good idea. Maybe it is, but … Continue reading

Posted in SQLServer, Windows | Tagged , , | Leave a comment

What is the latest SQL Server Service Pack?

I don’t know. But it seems we won’t have as much SPs as once we did. I just read a great article at SSC (short for SqlServerCentral, a great source of research) with this same question. And I agree with … Continue reading

Posted in SQLServer, Windows | Tagged , , , , , | 1 Comment