SQL 2005 – UPSERT: In nature but not by name; but at last!

SQL Server has long been criticised for not having an UPSERT command, well now in SQL 2005 we have some good news, we have two new TSQL set operators that give us the complex insert/update logic that constitute an UPSERT.  These are INTERSECT and EXCEPT e.g. — UPDATE Destination FROM (Source INTERSECT Destination) — INSERT…


Project REAL—Business Intelligence in Practice – great website!

For sometime a group of Program Managers from the SQL BI team have been working with a customer, Barnes and Noble, to produce a SQL BI solution for their data warehouse and analysis needs using SQL 2005.  The leasons learnt from all their work is being continually published to this website http://www.microsoft.com/sql/bi/projectreal/default.mspx in the form of…


64 Bit performance v 32 bit performance – some compelling evidence

More and more ITPros are looking for help in deciding between 64 bit and 32 bit boxes, often they are looking for evidence that 64 bit is worth the investment and worth the risk (of adopting a new platform). This link http://www.microsoft.com/sql/64bit/productinfo/winhecdemo.mspx takes you to a compelling demo, delivered at the Microsoft WinHEC 2005 conference, which…


Upgrading a SQL Replication Topology

Jonathan Allen wrote to me asking what order one should upgrade servers in a replication topology – pointing out that this doesn’t seem obviouis from Books On Line, which I agree. The answer is essentially the same as for any previous upgrade:  Distributor first (as it has to handle new and old log record formats),…


Fame at last: Ten Useful Microsoft Blogs

Redmondmag.com have published an article ‘Ten Useful Microsoft Blogs’ @ http://www.redmondmag.com/columns/article.asp?EditorialsID=1044 Guess who’s number 2? Also at number 10 is the UKs own Industry Insiders blog http://blogs.technet.com/industry%5Finsiders/.  So as promised all of you who submitted articles are already gaining recognition.  Alas only two articles have come form the database community.  So come on, I know…


Blogcasts: SQL Server 2000 – Configuring System Monitor & Monitoring SQL Server performance & Configuring alerts

Three new SQL Server 2000 blogcasts out of Redmond: Demo 4-1 Configuring System Monitor                     http://www.microsoft.com/winme/0506/24231/TNT1-160_Demo_4-1.asxDemo 4-2 Monitoring SQL Server performance       http://www.microsoft.com/winme/0506/24231/TNT1-160_Demo_4-2.asxDemo 4-3 Configuring alerts                                     http://www.microsoft.com/winme/0506/24231/TNT1-160_Demo_4-3.asx


SQL Server Reporting Services Report Packs – looking for suggestions

when I was over in the US recently, I attended a ‘Bill Baker and team unplugged’ session, (Bill is the GM for SQL Server Business Intelligence).  Reporting Services Report packs came up as a topic for discussion.  The team asked the audience if the Report Packs had been well recieved, to which I quickly responded…