Azure. Business Intelligence. SQL Server. Nerd Stuff.
Analytics Platform System (APS)
by Bradley Schacht · Published September 11, 2012 · Last modified October 13, 2015
The SQL Server PDW (Parallel Data Warehouse) is a beast of a machine. Spreading workload across multiple nodes inside the PDW provides a huge performance gain over a traditional SQL Server; however, when laying out tables it is a little...
NOTE: Always create a backup before doing any type of Windows registry modifications!!!! With the full public release of Windows 8 right around the corner it is inevitable that people will want to get in there and check it out....
I recently decided to move over to Windows 8 so I can take advantage of Hyper-V and get off a third party tool for virtualization. In the process I decided to rebuild my VM set up and modify the layout...
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...
by Bradley Schacht · Published August 21, 2012 · Last modified October 13, 2015
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...
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...
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...
BCP, or bulk copy program, has been around in SQL Server for a long time. It is a great way to export large quantities of data very quickly from SQL Server. It can be used to export entire tables or...
Color expressions in SSAS allow you to build an MDX expression to control the color of text displayed in a calculation. This property can be found in the Calculations tab of the cube editor when working in BIDS. Simply select...
If you follow anything outside the regular SQL Server world coming from Microsoft it should be Office and more importantly SharePoint. The two follow the same release cycle and as of today (July 16th actually) they have released a public...
