Data Dude - Visual Studio 2008 Database Edition GDR R2 Released

0
Your rating: None

If you are using the Visual Studio Team System Database Edition (Data Dude), you will want to upgrade to the latest version that came out at end of April 2009. http://www.microsoft.com/downloads/details.aspx?FamilyID=bb3ad767-5f69-4db9-b1c9-8f55759846ed&displaylang=en
Reason's to update:

SQL Server 2008 Downloads

0
Your rating: None

What's New in Service Pack 1

The following features are new in Service Pack 1:

Transactional Replication over WAN Tips

5
Your rating: None Average: 5 (1 vote)

If you have to resnapshot a large database, have your remote sites look to a local share (can manually change them whenever via Repl Monitor), pause your replication agent (SQL Agent job) on the subscriber(s) to prevent all the error messages, re-snapshot, zip up the file (I recommend 7-zip), copy the file over with robocopy or FTP to external site if bandwidth better over internet, unzip the files, and startup your replication agent job.

Microsoft to add Lock Pages in Memory to Standard Edition

0
Your rating: None

Bob Ward wrote up an article on the subject. Basically, you add trace flag 845 as a startup parameter. You will need SP1 Cumulative Update (CU) 2 (SP1) for SQL 2008 and CU4 (SP3) SQL 2005.
CSSSQL team blog wrote up a good article now that it is released.

Slipstream SQL 2008 Installs

0
Your rating: None

Slipstreaming is a term to update your installs files to a patch level that you are interested in for SQL 2008 only. There is now a Slipstream FAQ on MSDN blogs. If you know all about it, jump right to the how to: SQL Server Setup blog, or the official KB955392. PSSQL blog has another good post on subject.

Partitioned Table Queries

4.75
Your rating: None Average: 4.8 (4 votes)

I have spent a bunch of time trying to analyze existing partitioned tables and checking out those I am creating. Here are some queries that I found very useful.

SQL 2008 and Opening DTS packages

4
Your rating: None Average: 4 (1 vote)

I was trying to open DTS on a Windows 2008 Server running SQL 2008 only and got an error message:

SQL Server 2000 DTS Designer components are required to edit DTS packages. Install the special Web download, "SQL Server 2000 DTS Designer Components" to use this feature. (Microsoft.SqlServer.DtsObjectExplorerUI)

Vulnerability in Microsoft SQL Server Could Allow Remote Code Execution

0
Your rating: None

Microsoft released on February 10th a security update for SQL 2000, MSDE and SP2 releases of SQL 2005 including express (SP3 contains the fix; SQL 2008 is not affected by it). http://www.microsoft.com/technet/security/Bulletin/MS09-004.mspx

Dataloading Whitepaper Available on MSDN

0
Your rating: None

I saw Thomas Kejser's presentation (he is a great presenter) on SQL Servers fastest data loading (ETL) world record presentation at SQL PASS 2008 conference in Seattle, where he promised the SQLCAT team would have this document for us soon.

Latest Books On Line (BOL) Downloads

0
Your rating: None

Make sure you have the latest version on your desktop and your servers.
SQL 2005 Latest version Dec 2008.
SQL 2008 Lastest version May 2009.