I was recently making some changes to my laptop setup and installing SQL Server 2008R2 and SQL Server 2012 directly on the computer rather than on my VM. In the case of my setup I had already installed the client tools for 2008R2 and 2012 on my laptop. So in… Read more

If you have done a lot of work with SQL Server Analysis Services (SSAS) you may have seen this message:

We’ve all been there. A build error. I tend to get this because I like to forget commas when modifying calculations in the MDX section of the cube editor. It’s… Read more

Modifying the Windows host file can be a great way to ensure that you don’t accidentally modify production while doing development or just redirecting traffic on your computer. For instance, while at a client’s office I was able to access a server by entering just the server name, but when… Read more

We have all been there; you need to take a look at the data inside a file. Sure you can open it in Notepad if it is under 20-30MB, bigger than that and you may run into problems depending on the computer. Sometime WordPad will handle the larger files, again… Read more