SQL Server 2005 Books Online (December 2005)

BOL has been updated, you can download it from here: http://www.microsoft.com/downloads/details.aspx?FamilyId=BE6A2C5D-00DF-4220-B133-29C1E0B6585F&displaylang=en The December 2005 update to Books Online contains new material and fixes to documentation problems reported by customers after SQL Server 2005 was released. Refer to “New and Updated Books Online Topics” for a list of topics that are new or updated in this…

1

Intellisense add-in for SQL Server

PromptSQL http://www.promptsql.com/index.html have produced an intellisense add-in for SQL Server – this is very cool. 

0

Evaluating Database Mirroring in SQL Server 2005 RTM

As you know, in the update from Paul Flessner http://www.microsoft.com/sql/2005/productinfo/letter.mspx, the “[…] Database Mirroring feature needs more time in the hands of customers before we make it generally available for production use … in the first half of 2006”.  However, if you wish to evaluate mirroring in the RTM release of SQL Server 2005, you’ll need…

0

SQL Server 2005 Resources

There are some great SQL Server 2005 webcasts appearing on http://www.microsoft.com/events/series/technetsqlserver2005.mspx which can be downloaded for offline viewing (always good when you’re on the road etc.).  I also like the SSIS MSDN resource http://msdn.microsoft.com/SQL/sqlwarehouse/SSIS/default.aspx and the new MSDN SQL Server Forums http://forums.microsoft.com/msdn/default.aspx?ForumGroupID=19 which covers pretty much every feature.  And finally…there are some good whitepapers / articles appearing on the TechNet site http://www.microsoft.com/technet/prodtechnol/sql/2005/default.mspx.   I…

1

New TPC-C Result for SQL Server 2005

This is great news – congratulations are in order to Dell for being the first to beat the $1 per tpmC threshold for TPC-C price/performance.  Yesterday Dell published a result of 38,622 tpmC with a price/performance of 0.99 $/tpmC.  Dell used SQL Server 2005 x64 Standard Edition running on an Intel dual-core Xeon CPU (Paxville). …

0

Best Practices for Deploying SQL Server 2005 on Storage Area Networks

The question of SAN configuration for SQL Server always comes up so here is a very good webcast on SAN configuration/best practices for SQL Server 2005 http://msevents.microsoft.com/cui/WebCastEventDetails.aspx?EventID=1032275439&EventCategory=5&culture=en-US&CountryCode=US (some of the information is also relevant to SQL Server 2000, just ignore the DMV stuff)

0

SSIS Perf Counters & New CLR Whitepaper

There are many things to investigate if you are worried about SSIS performance or would like to optimise package execution.  One of the things to take a look at is the SSIS Pipeline events in performance monitor.  There is a counter called Buffers Spooled which, quite simply, indicates the number of buffers which are spooled…

0

SQL Server 2005 Upgrade Advisor – CTP June Refresh

June CTP Refresh of the SQL Server 2005 Upgrade Advisor can be downloaded from here http://www.microsoft.com/downloads/details.aspx?FamilyID=cf28daf9-182e-4ac2-8e88-f2e936558bf2&DisplayLang=en. 

0

SQL Server 2005 on MSDN TV

I’ve been hitting quite a few bugs in the Integration Services June CTP recently; some are minor and others not so.  Hopefully we won’t have to wait too long until the final CTP in August/September.  I’m finding many uses for package configurations and property expressions.  Event handlers are also a great new feature…I just need to understand the difference…

0