Welcome to TechNet Blogs Sign in | Join | Help

SQL Server 2005 (RSS)

Monday, September 12, 2005 10:27 PM

Getting to know SQL 2005 Service Broker

Looks likes I've got to do a presentation on Service Broker for the SQL 2005 launch - so I've been doing some home work on the subject. The best primer I've found is http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/sqlsvcbroker.asp?frame=true this
posted by Mat_Stephen | 0 Comments
Filed Under: , , , , ,
Tuesday, September 06, 2005 6:11 PM

SQL 2005: Making sense of the new Optimistic Concurrency Controls and the readers that block writers

For a long time now Oracle enthusiasts have bashed SQL Server for not having Optimistic Concurrency Controls.  They would demonstrate a SQL Server reader blocking a writer and possibly a writer blocking a reader.  Thus, having appeared to demonstrate
posted by Mat_Stephen | 0 Comments
Filed Under: , , , ,
Tuesday, September 06, 2005 10:31 AM

IT Forum - Barcelona 15th - 17th November

The tag line for IT Forum is "3 days of learning one year of solutions" - I'm sure you can sell that to your boss. If you do the details are here http://www.mseventseurope.com/msitforum/05/pre/content/default.aspx
posted by Mat_Stephen | 0 Comments
Filed Under:
Wednesday, August 31, 2005 10:34 AM

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
posted by Mat_Stephen | 1 Comments
Filed Under: , , ,
Tuesday, August 30, 2005 4:27 PM

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
posted by Mat_Stephen | 0 Comments
Filed Under: , , , , , ,
Thursday, August 25, 2005 1:23 PM

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
posted by Mat_Stephen | 1 Comments
Filed Under: , , ,
Tuesday, August 23, 2005 5:11 PM

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: 
posted by Mat_Stephen | 2 Comments
Filed Under: ,
Friday, August 19, 2005 3:47 PM

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/. 
posted by Mat_Stephen | 3 Comments
Filed Under: , ,
Friday, August 19, 2005 11:24 AM

Reporting Services: Calling an aspx page from a report and passing a parameter

Sudhi recently asked me how to call an aspx page from a report and pass a parameter held in a textbox, or other control. My solution is: Drag a textbox control on to the report and enter the value "2005/07/28/408325" (without the the quotes) in to it. 
posted by Mat_Stephen | 0 Comments
Filed Under: , , ,
Thursday, August 18, 2005 12:25 PM

Microsoft SQL Server 2005 Preview Software for UK customers

If you're in the UK and you'd like to get your hands on the 'Microsoft SQL Server 2005 Preview Software' then please visit: http://www.microsoft.com/uk/windowsserversystem/sql/2005/evaluate.aspx  
posted by Mat_Stephen | 0 Comments
Filed Under: , ,
Tuesday, August 16, 2005 11:49 AM

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
posted by Mat_Stephen | 6 Comments
Filed Under: , , , ,
Friday, August 12, 2005 2:36 PM

Follow up on XPs and SQLiMail question from SQL Server™ 2005 Management and Admin TechNet evening 28/7/05

Sorry for the delay in getting these answers posted but my trip to the US and some hols have got in the way. I was asked if SQL Express could handle Extended Stored Procedures unlike msde.  The answer is msde can handle XPs and so can SQL Express. 
posted by Mat_Stephen | 0 Comments
Filed Under: ,
Thursday, August 04, 2005 3:08 AM

Letter from America 3 - Mischievous reports and feeding the 5000

After all my messing around yesterday, I've decided to create this post in pocket word. I attended a securty session yesterday and was reminded of an issue that can send DBAs scuttling from the room when they learn of it's presence, the 'trojan report'.
posted by Mat_Stephen | 0 Comments
Filed Under: , , , ,
Wednesday, August 03, 2005 2:06 AM

Letter from America 2

I've had a really hard time with my iPaq today.  First thing this morning I couldn't get it to connect to anything.  For ages I poked about - everything looked fine.  Then eventually I found, in the asset viewer, that I had no IP address. 
posted by Mat_Stephen | 6 Comments
Filed Under: ,
Monday, August 01, 2005 10:58 PM

Letter from America 1

I'm in Seattle this week at Microsoft's first TechReady conference. What's more I'm totally mobile; I didn't bring my laptop. Instead I'm relying on my iPaq with built in wireless and bluetooth.1 To help me type I'm trialing a software keyboard I downloaded
posted by Mat_Stephen | 2 Comments
Filed Under: , ,
More Posts « Previous page - Next page »