Monthly Archives: May 2009

AdventureWorks Database Backup

Here is a link to a compressed backup of the AdventureWorks sample OLTP database on SkyDrive that I need for my MCIS-4428 class.

Posted in Teaching | 3 Comments

SQL Server 2008 R2 (a.k.a. Kilimanjaro) Announced

During the TechEd 2009 Keynote on May 12, Microsoft started talking publicly about SQL Server 2008 R2, which is due to be released in the first half of 2010, probably to coincide with the Office 2010 release. The R2 release … Continue reading

Posted in SQL Server 2008 | 2 Comments

Microsoft Announces System Requirements For SharePoint Server 2010

Microsoft has announced the system requirements for SharePoint Server 2010 on the SharePoint Team Blog. A couple of interesting points are that it will be 64-bit only, on 64-bit Windows Server 2008 or Windows Server 2008 R2, and it will … Continue reading

Posted in Microsoft | 2 Comments

Speaking At Denver SQL Server User’s Group On May 21

I will be giving a short presentation and demo at the Denver SQL Server User’s Group meeting on May 21. The group meets at the Microsoft office in the Denver Tech Center.  Here is the title and abstract for my … Continue reading

Posted in SQL Server 2008 | 3 Comments

Initializing a Transactional Replication Subscriber from an Array-Based Snapshot

Microsoft’s Benjamin Wright-Jones has published a Technical Note on on how you can quickly initialize a transactional replication subscriber using an array based snapshot (as opposed to sending all of the data from the Publisher to the Distribution database … Continue reading

Posted in SQL Server 2008 | 1 Comment

How to Get a Job as a DBA

Brent Ozar, who works at Quest Software, has recently blogged, here, here, and here, about “How To Get A Job as a Junior DBA”. This is a good series of posts, with lots of good advice. He is absolutely right … Continue reading

Posted in SQL Server 2008 | 2 Comments