Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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