SQL Server XML Cribsheet
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.
2007-04-16
2,866 reads
Additional Articles
SQL Server Everywhere: Just Another Database?
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.
2007-04-13
4,161 reads
Creating cross tab queries and pivot tables in SQL
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.
2007-04-11
4,992 reads
The NEWSEQUENTIALID Function
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.
2007-04-10
2,884 reads
Using Multiple Active Result Sets (MARS)
SQL Server 2005 has so many new features that in my opinion if you read only BOL for a year you'd find something new every day. One of those is Multiple Active Result Sets or MARS. Multiple Active Result Sets is a new SQL Server 2005 feature that, putting it simply, allows the user to run more than one SQL batch on an open connection at the same time.
2007-04-09
2,563 reads
Twiddling the knobs: The Default Backup directory
What's the best way to change the default backup directory for a server, using SSMS or Enterprise Manager, without changing all the default directories at the same time? What is the TSQL to do it? A prize for the best correct solution.
2007-04-06
3,467 reads
Delivering on SQL Server
Having been at the sharp end of many successful SQL Server solutions, I believe there are some fundamental principles that all successful SQL Server installations have in common. Whilst the challenges in delivering an enterprise-scale database-intensive application can be wide and varied, there are a few basic practises that will give you the best possible chance of success.
2007-04-05
2,570 reads
SQL Server 2005 Security Best Practices - Operational and Administrati
his white paper covers some of the operational and administrative tasks associated with SQL Server 2005 security and enumerates best practices and operational and administrative tasks that will result in a more secure SQL Server system.
2007-04-04
3,297 reads
SQL Server Wait Events: Taking the Guesswork out of Performance Profil
This article introduces some techniques that will allow you to pinpoint exactly where the performance issues are in your system, so you'll know exactly where to spend your time (and money) in solving them.
2007-04-03
2,360 reads
PowerSMO at work part 2
Dan Sullivan continues his exploration of the versatile PowerSMO tool with coverage of how to control logins, monitor server activity and create standalone administrative scripts.
2007-04-02
2,261 reads
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers