Monthly Archives: September 2011

Microsoft SQL Server Reference Architecture and Appliances

Microsoft has made available SQL Server appliances and reference architectures that allow customers to deploy data warehouse (DW), business intelligence (BI) and database consolidation solutions in a very short time, with all the components pre-configured and pre-optimized.  These appliances include all the … Continue reading

Posted in Appliance, Data warehouse, Fast Track, PDW/APS, SQL Server, SQLServerPedia Syndication | 11 Comments

Consultants: 1099 or W-2?

As a consultant or contractor, you can sometimes be faced with the decision when taking a new contract of whether to go 1099 or W-2.  Essentially, the question is in what manner will you be paid by your client.  Having faced that decision a … Continue reading

Posted in Career, Consulting, SQLServerPedia Syndication | 46 Comments

What is a Microsoft Regional Director?

First off, they don’t work for Microsoft.  A Microsoft Regional Director (RD) is an unbiased third-party evangelist of Microsoft products and services.  Regional Directors are members of an elite, worldwide group of technology thought-leaders known for their national and international speaking … Continue reading

Posted in Microsoft, SQLServerPedia Syndication | 2 Comments

Microsoft Partner Network explained

I’m sure in your travels in the field of IT, you have seen or heard of companies being called a “Microsoft Partner”.  If you were like me, you had no idea what that really meant.  Was it something a company … Continue reading

Posted in Microsoft, SQLServerPedia Syndication | Comments Off on Microsoft Partner Network explained

Miss 24 Hours of PASS ? No problem, all videos are online

All the videos for the sessions at 24 Hours of PASS are available for free.  Check the session schedule for a complete list.  Some great stuff!

Posted in PASS, SQL Server, SQLServerPedia Syndication, Videos | 1 Comment

Context-sensitive menus in PerformancePoint

Frequently I see a bit of confusion from business users when using an analytic grid on a dashboard in PerformancePoint.  The confusion comes when you right-click on the analytic grid and see a context-sensitive menu.  When you right-click on any … Continue reading

Posted in PerformancePoint, SQLServerPedia Syndication | Comments Off on Context-sensitive menus in PerformancePoint

Building a Visual Studio project from an existing SSAS database

Imagine you join a company, and there is an existing SSAS database that contains a few cubes that are working nicely.  You are asked to add an enhancement to one of the cubes, so you poke around in source control for the … Continue reading

Posted in SQLServerPedia Syndication, SSAS, Visual Studio 2008 | 14 Comments

Ways to save money on Microsoft Software

If you are a developer and are on your own, or working for a company that does not have an MSDN subscription and you are looking at using a bunch of Microsoft tools, you can wind up spending a ton of … Continue reading

Posted in SQLServerPedia Syndication | 3 Comments

SQL Server 2012 (“Denali”): Installing on a Virtual Machine

With CTP3 for SQL Server 2012 (code name of “Denali”) available, a lot of us want to play with all the new cool features, as well as the new tools, such as Crescent and Juneau.  The steps below are what I took to … Continue reading

Posted in SQL Server 2012, SQLServerPedia Syndication | 3 Comments

How to prevent blocking in your SQL Server database

As a SQL Server DBA, usually the largest databases in size and in number of users that I had to manage was an ERP database, such as Microsoft Dynamics AX.  And because these types of database typically have a lot of users, database blocking … Continue reading

Posted in SQL Server, SQLServerPedia Syndication | 3 Comments