Author: Bradley Schacht

PASS Summit 2012 0

PASS Summit 2012

It’s finally here, PASS Summit 2012. Everything kicks off tomorrow and Tuesday with a couple days of pre-cons then the regular sessions on Wednesday to Friday. I’ve been in Seattle since late on Friday with a handful of Pragmatic Works...

0

Find Skew in Distributed Tables

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...

21

Cisco VPN Client 5 on Windows 8

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....

0

Modify Host File on Windows 7

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...

2

View Flat File Contents Using PowerShell

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...

3

Exporting Data Using BCP

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...

5

Color Expressions in SSAS Calculations

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...