Benjamin Wright-Jones
Exploring Information, Infrastructure and Solution Architecture
Using vardecimal storage in SQL Server 2005 SP2 CTP2
As you probably know, Service Pack 2 for SQL Server 2005 introduces the vardecimal storage format....
Author: superlatch Date: 11/10/2006
SQL Server 2005 Service Pack 2 CTP 2
The Service Pack 2 CTP 2 download will be available very soon from here:...
Author: superlatch Date: 11/07/2006
Whitepaper Alert: Architecting Service Broker Applications
We have just released a new whitepaper on MSDN which is worth a read: Architecting Service Broker...
Author: superlatch Date: 11/03/2006
Finding the NTFS Sector Size via DBCC
You can determine the formatted sector size of the database using DBCC FILEHEADER...
Author: superlatch Date: 10/31/2006
SQL Server 2005 Service Pack 2 required for Longhorn & Vista
In case you were wondering, Longhorn & Vista will only support SQL Server 2005 Service Pack 2....
Author: superlatch Date: 10/30/2006
Updates to MPS Reports, Support for 64-Bit
Well, not what I'd call a big update to MPS reports but still worth noting if you intend gathering...
Author: superlatch Date: 10/30/2006
Take a look at SQLIOSim
Only just seen this via the SQL Server Storage blog here...
Author: superlatch Date: 10/07/2006
SQL Server 2005 Failover Clustering Whitepaper
Is now available here:...
Author: superlatch Date: 10/07/2006
Microsoft Premier Services Reporting Utility (PFE Version)
If you ever open a support case with Microsoft PSS, we may ask you to run the MPS Reports tool to...
Author: superlatch Date: 09/05/2006
Architecture and Design Guidelines for BI Apps
Just seen this on the gotdotnet Microsoft Pattern & Practices community server, Architecture and...
Author: superlatch Date: 08/24/2006
Visual Studio for Database Professionals CTP5 has arrived...
Just got back from vacation (Crete was very nice but the 40 degree heat was intense) so sorry about...
Author: superlatch Date: 08/23/2006
July Updates for SQL Server 2005 BOL & Samples
SQL Server 2005 Books Online has received another refresh (and so has the samples). The July BOL...
Author: superlatch Date: 07/21/2006
Visual Studio 2005 Team Edition for Database Professionals CTP4
Visual Studio 2005 Team Edition for Database Professionals CTP4 is here:...
Author: superlatch Date: 07/12/2006
Microsoft SQL Server 2005 JDBC Driver 1.1 Community Technology Preview June 2006
The SQL Server 2005 JDBC Driver 1.1 CTP (June 2006) includes support for integrated authentication...
Author: superlatch Date: 06/26/2006
Whitepapers: Working with TempDB & Physical Database Storage
Two new whitepapers from the SQL Storage Team: Working with...
Author: superlatch Date: 06/20/2006
Comparing SQL Server 2005 and Oracle
A few interesting whitepapers comparing SQL Server 2005 to Oracle (and particularly the use of RAC)...
Author: superlatch Date: 06/18/2006
Visual Studio Team Edition for Database Professionals
Just posted; https://msdn.microsoft.com/vstudio/teamsystem/products/dbpro/. Certainly looks...
Author: superlatch Date: 05/31/2006
Cumulative hotfix package (build 2153) for SQL Server 2005 is available
Yes, this is a post-SP1 update for SQL Server 2005 (available for public download). I have to look...
Author: superlatch Date: 05/22/2006
New MSDN Article: Scaling Out SQL Server 2005
Just published: Scaling Out SQL Server 2005...
Author: superlatch Date: 05/17/2006
SQL Server 2000 Post SP4 Hotfix Rollup Packages
I really should keep a closer eye on those SQL Server knowledge base RSS feeds! There are two new...
Author: superlatch Date: 05/16/2006
SQL Server 2005 Books Online has also been updated
To coincide with the SP1 release..the SQL Server 2005 Books Online April 2006 update is available...
Author: superlatch Date: 04/24/2006
SQL Server 2005 SP1 (RTM) is here...
...and was published on 19th April, get it here https://www.microsoft.com/sql/sp1.mspx The BOL update...
Author: superlatch Date: 04/20/2006
Migration (oh, and a few things I like...)
- I keep finding useful pieces of information on our website which I wasn't aware of, like this SQL...
Author: superlatch Date: 04/06/2006
CTP Component Updates for SQL Server 2005 (March 06)
Hot on the heels of the SP1 CTP and BOL update, are a whole bunch of component updates...
Author: superlatch Date: 03/28/2006
SQL Server 2005 SP1 CTP inc. BOL Update and Fix List
The SQL Server 2005 SP1 CTP has been available since last Wednesday, here is the URL...
Author: superlatch Date: 03/20/2006
MSH & SMO
I've started playing around with MSH https://www.microsoft.com/technet/scriptcenter/hubs/msh.mspx to...
Author: superlatch Date: 02/01/2006
Moving to SQL Server 2005 at Microsoft
If you are interested in how our internal IT department deployed SQL Server 2005, then this is a...
Author: superlatch Date: 01/31/2006
Migrating to SQL Server 2005, UK TechNet Briefing
I've been keeping my eye on the TechNet Briefings and there are some good SQL Server specific events...
Author: superlatch Date: 01/27/2006
New SQL Server JDBC Driver
Yes, its here... The new JDBC driver for SQL Server 2000/2005...
Author: superlatch Date: 01/22/2006
PDC 05 demos - Query Processing over DataSet, Fast Uploads, Caching
Thanks to Euan https://blogs.msdn.com/euanga for pointing this out - There is a good post here on...
Author: superlatch Date: 01/16/2006
SQL Server 2005 Up & Running Roadshow
Just seen this https://www.windowsitpro.com/roadshows/sqlservereurope/. "Get the facts about...
Author: superlatch Date: 01/10/2006
New SQL Server Web Data Administrator (Work in Progress)
Although work is still in progress, I am impressed by the screenshots of the new version of Web Data...
Author: superlatch Date: 01/10/2006
/PAE may cause SQL Server database corruption
Just seen this new KB article; may be worth considering if you are using /PAE to support more than...
Author: superlatch Date: 01/06/2006
UK TechNet Briefing: Whats NEW in SQL 2005 - Integration Services
If you're in the UK and near the Microsoft office in Reading on 24th January, please come along to...
Author: superlatch Date: 01/05/2006
Advantages of a 64-bit Environment
I'm on a roll... Good article on SQL Server 2005 64-bit...
Author: superlatch Date: 01/04/2006
New Downloads, Yukon Samples, Metadata & Performance Tuning Whitepaper
Ok, I know I haven't posted for a while... but as it is a new year I thought I'd try and post more...
Author: superlatch Date: 01/04/2006
SQL Server 2005 Books Online (December 2005)
BOL has been updated, you can download it from here:...
Author: superlatch Date: 12/07/2005
Scalable shared databases are supported by SQL Server 2005
This was kept quiet! Scalable shared databases are supported by SQL Server 2005...
Author: superlatch Date: 11/25/2005
Intellisense add-in for SQL Server
PromptSQL https://www.promptsql.com/index.html have produced an intellisense add-in for SQL Server -...
Author: superlatch Date: 11/02/2005
Evaluating Database Mirroring in SQL Server 2005 RTM
As you know, in the update from Paul Flessner...
Author: superlatch Date: 09/29/2005
SQL Server 2005 Resources
There are some great SQL Server 2005 webcasts appearing on...
Author: superlatch Date: 09/28/2005
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...
Author: superlatch Date: 09/28/2005
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...
Author: superlatch Date: 09/12/2005
SSIS Perf Counters & New CLR Whitepaper
There are many things to investigate if you are worried about SSIS performance or would like to...
Author: superlatch Date: 08/09/2005
SQL Server 2005 Upgrade Advisor - CTP June Refresh
June CTP Refresh of the SQL Server 2005 Upgrade Advisor can be downloaded from here...
Author: superlatch Date: 07/28/2005
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...
Author: superlatch Date: 07/27/2005
SQL Server TechCenter
Please take some time to look at the SQL Server TechCenter...
Author: superlatch Date: 07/19/2005
Using SQL Server 7.0/2000 in a Hyper-Threaded Environment
I've just read a good article which discusses using SQL Server in a hyper-threaded environment...
Author: superlatch Date: 07/15/2005
Add-on Components for SSIS
I've just discovered a new 3rd party add-on for Integration Services by Ivolva.com. There is a SSIS...
Author: superlatch Date: 07/14/2005
SQL Server 2005 Training, Free!
Go here for free online learning for SQL Server 2005:...
Author: superlatch Date: 07/14/2005