Maintaining a Log of Database Changes - Part 1
This article looks at logging your database changes from a developer's perspective.
2007-04-26
4,581 reads
Additional Articles
Microsoft SQL 2005 Maintenance Wizard Part 3
The Maintenance Plan Wizard is a graphical interface for creating a variety of database housekeeping tasks. This article focuses on using SQL Server 2005 Maintenance Plan Wizard for creating Database Backup operations.
2007-04-25
2,582 reads
Using Views to Enforce Business Rules
A view is most commonly thought of as a SELECT statement. Most developers will simply create a view to "group" complex SELECT statements for reuse within another view or stored procedures. It makes typing easier! But the really power of views is their ability to implement business rules.
2007-04-23
4,528 reads
SQL Server Profiler for Analysis Services
Use SQL Server Profiler to “look behind the scenes” within Analysis Services 2005. BI Architect Bill Pearson leads a hands-on introduction to determining resource utilization effectiveness for both processing and query performance with profiling.
2007-04-19
2,790 reads
Dynamic Images and Databases
Should you store dynamically generated web-site graphics in a database or is the file system the better option? Dino illustrates how to make this decision in ASP.NET
2007-04-17
3,883 reads
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
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
Blogs
Giving AI Agents Visibility Into SQL Server with MCP
I’ve been thinking a lot lately about what it actually takes to make an...
The Book of Redgate: Profits
By Steve Jones
Redgate is a for-profit company. We look to make money by building and selling...
Session Materials for Techorama & DataGrillen 2026
I’ve uploaded the slides for my Techorama session Microsoft Fabric for Dummies and my...
Forums
Stop Prompting Your AI Agent. Give It a Playbook.
Comments posted to this topic are about the item Stop Prompting Your AI Agent....
Finish the quote
Comments posted to this topic are about the item Finish the quote
Everything I Needed to Know Used to be Found in One Book
Comments posted to this topic are about the item Everything I Needed to Know...
Question of the Day
Finish the quote
Finish this quote (for a fun Memorial Day question):
Do not try and bend the spoon. That's impossible. ...See possible answers