Azure. Business Intelligence. SQL Server. Nerd Stuff.
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...
The preview for Office 2013 is live!! You can hop over to the Microsoft website and grab it here: http://www.microsoft.com/office/preview/en/try-office-preview. Naturally I am eager to see all the BI features in both Office and SharePoint. If you have ever used PowerPivot...
I’m not exactly sure when this happened, but it looks like Microsoft has moved past the PowerPivot 2008R2 and PowerPivot 2012 model and is now just offering PowerPivot on their website. Previously there were two options as I just mentioned...
Business Intelligence / SQL Server
by Bradley Schacht · Published July 12, 2012 · Last modified October 13, 2015
If you are using Change Data Capture (CDC) it can be very useful to look at the CDC State table to understand what is happening. I am writing this in the context of using SSIS 2012 CDC components; in this...
Business Intelligence / SQL Server
by Bradley Schacht · Published July 10, 2012 · Last modified October 13, 2015
Change data capture was introduced in SQL Server 2008 and has been pretty popular ever since. The basic concept behind it is that all changes (inserts, updates, deletes) are captured and the details made available in a consumable manner. This...
I’ll be honest, I contemplated a lot about whether to write this blog or not for fear that it may come off the wrong way or just not convey the point I want, but here we are…in a hotel room...
