Service Broker is one of those new SQL Server 2005 features that doesn't get much press, but is extremely interesting from a software architect perspective. The much talked about service oriented architecture (SOA) can make use of Service Broker and new author Johan Bijnens brings us a look at this subsystem.
If you haven't seen it, I highly recommend all SQL Server administrators check out the post from Microsoft detailing the post-SP2 fixes.
If you're like me and find XML a bit of an acronym minefield, Robyn Page's Cribsheet will help sort out your XSLT from your XDM.
With the release of SQL Server Everywhere Edition looming, Scott sits down with Mark Jewett and Steve Lasker to find out about Microsoft's new database engine.
We're opening the newsletter up to advertising for everyone. Get the news here.
There have been a huge number of SQL Server 2005 books released in the last year, but which ones are worth buying? Here are reviews
of three new books from one of the SQL Server gurus.
For those times when you absolutely, positively got to perform a cross tab query in SQL, Keith Fletcher's T-SQL stored procedure will allow you to do it "on the fly". You can add it to your database and start cross tabbing immediately, without any further setup or changes to you SQL code. Check it out, and then take the cross tab challenge.
The great debate over NULLs will probably never end. Should we use them in our databases? What meaning do they have? These are all
valid questions. In this article SQL Server expert Michael Coles takes a look at the problems that are inherent in eliminating NULLs completely from
a database.
The NEWSEQUENTIALID system function is an addition to SQL Server 2005. It seeks to bring together, what used to be, conflicting requirements in SQL Server 2000; namely identity-level insert performance and globally unique values.
If you are thinking of taking a SQL Server 2005 MCP exam, now is the time to do it. And with exam insurance, you can get two chances to pass and a free year of Technet!
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
BCA KCP Rantai Mulia Kencana HUB.Tlpn.0821•3111•185 Jl. Pesanggrahan Jl. Puri Kencana No.28 29, RT.2/RW.7,...
<!--more-->Tlp/WA.(+62 821°3111°179 Gedung WTC Jl. Mangga Dua Raya. 8 Lantai 6, Blok CL 001,...
BCA KCU DAAN MOGOT Telp/WA.0851°8812°0691 Jl. Daan Mogot No.95, Wijaya Kusuma, Kec. Grogol petamburan,...
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers