Blog » Entries from 9/3/2009
September
-
SQL SERVER – Designing SQL Server 2005 Analysis Services Cubes for Excel 2007 PivotTables
In my recent Business Intelligence Training Roadshow August September 2009 I quite often get request to provide more details about Analysis Service Cubes for Excel 2007 PivotTable. Here is the white paper on the same subject.
Microsoft Office Excel 2007 takes advantage of most of the features in Microsoft SQL ... -
Meta-data for linked servers and collation compatible
Have you ever encountered a situation where you wondered when was this linked server created and who created it. Unless you have a co-worker/colleague just like Jonathan Kehayias and see his post on good documentation, you might have faced it at some point of time and wondered where is ...
-
Thoughts on the 24 hours of PASS
From all indications, the first 24 hours of PASS was a resounding success. Hundreds of attendees for each session, minimal technical glitches. All in all, it went very well.
The first session I attended (well, part thereof) was Greg’s discussion on Spatial data. I would really have loved to ...
-
Fast, Cheap, and Easy
Jeremiah Peschka claims to have quickly and easily put together this post on how to attend the PASS Summit on the cheap. In my book, that is his way of saying he is fast, cheap, and easy, but he claims that he has only two of those three traits.
If ...
-
It's Official. I am the 2009 Exceptional DBA of the Year!!
I want to thank everyone who voted for me. I am ecstatic and honored to be this years 'Exceptional DBA of the year'. Here is a link to the official announcement.

-
VIDEO: Server Side Trace
Here is the video to accompany the article I wrote for SQLServerPedia.com, "The Server-side Trace: What, Why, and How"...
Any time you open SQL Server Profiler and run a trace, you're running a client-side trace. Even if you open SQL Profiler on the server and run it there ...
Get Syndicated on SQLServerPedia
Have you been blogging for six months or more? Want to see your own posts here on SQLServerPedia too? Follow these easy steps to increase your visibility in the community and attract more visitors to your blog.
-
Create a Blog Category for Syndicated Posts
Using your blogging software, create a new category for posts that should be syndicated on SQLServerPedia and add a few posts to it. (This allows you to keep off-topic posts from being syndicated.)
-
Find the URL to Your Syndicated Posts Feed
Most major blogging platforms will create a RSS or Atom feed for each category you create. On WordPress blogs, the feed can be accessed by appending
/feed/to the category page URL. On Blogger blogs, the feed for a label is athttp://<yourname>..blogspot.com/ feeds/ posts/ default/-/ <categoryname> -
Email Us with Your Feed URL, a Picture, and a Bio
Once you're ready to set up syndication, send us an email introducing yourself. Include the URL to your feed, a headshot of yourself, and a short professional bio.