Pulse » Recent Items from 5/19/2009
Welcome!
Pulse has a simple goal: to give you a quick view of what's happening in the SQL Server community.
-
Browse
Finding interesting content on Pulse is easy – you can drill down to a specific time period (by clicking on the bars of the chart), toggle different types of content on and off, and sort the results by popularity or recency.
-
Vote
Discovered an informative blog post or a hilarious tweet? Tell the rest of the community about it by voting it up or down. Behind the scenes, our popularity algorithm will make sure it rises to the top of the list.
-
Comment
When a simple up-or-down vote isn't enough, voice your opinions in a comment. Or check out what others are saying about something you posted or tweeted.
-
Determine the Last Start Date for a SQL Server Instance
Today I had a friend on Facebook ask if I knew of a DMV or DMF that provided the date upon which the SQL Service was last started. What I use instead in any of my queries is the create date of the tempdb database. Why? Well simply put, tempdb ...
-
SCRUM, Source Control and the SQL Server Developer (Part 1)
(If you’re just visiting me from SQLServerPedia, thanks for stopping by!) I recently responded to TJay Belt’s post about his Release Management process, and thought it would be better to fully explain our development cycle here. Although I come from a DBA background, I currently work on the ...
-
SQL Server – Download PDF SQL Server Cheat Sheet
I had a gala time at TechEd India 2009 event! Meeting with great people is an experience of a lifetime. My session was well attended and well appreciated, which also gives me another reason to feel happy. Moreover, my SQL Server Cheat Sheet gained unpredicted popularity at the event. Let ...
-
Snacks and Keyboard Shortcuts
At the risk of stealing his thunder, I think I'll make my first blog post about Sean's latest greatest idea, the Midnight Snacks. We'll soon be offering daily video snippets, or "Snacks", for your edification. I've just recorded a few vids on one of the great ...
-
PASS Summit DBA Abstract Reviews - Done!!! :)
176 abstracts reviewed and I must say that there are going to be some amazing sessions at this years Summit. I spent a good portion of my long weekend (Victoria Day in Canada) finishing up the ratings and it’s going to be very hard picking which sessions make it ...
-
Early Arriving Facts, Late Arriving Dimensions, Inferred Dimensions
Most ETL systems (at least that I have seen/studied/worked on) that populate data warehouses run something like 1) Load Dims a) populate an unknown b) populate dim data 2) Load Facts a) join/lookup to dim’s, and if no match, set as “unknown” dimension record 3) Process ...
-
May PASSMN Meeting Today
It probably won’t be as interesting as Old School, but come out this afternoon if you are in the Twin Cities for the PASSMN meeting you could attend. It starts at 3:00 PM and we meet at 2:30 PM for snacks and socializing. And by snacks, I ...
-
Call for Speakers and Abstract Tips
I have now been on both ends of the process. Submitting abstracts for conferences and selecting them in this year’s SQL PASS process. First, I would like to applaud PASS for taking a huge step forward in two areas. First is marketing. They have grow the submissions, sessions and ...
-
PASS Webinar Today
When was the last time you rolled your own…anything? Brent Ozar is going to show you how you can roll your own replication during this free webinar. Rolling Your Own Replication Speaker: Brent Ozar Tuesday, May 19th, 1:00pm ET SQL Server’s built-in replication has made great strides ...
Pulse is a section of SQLServerPedia that gives you a quick view of what's happening in the SQL Server community.