An Example of Test-Driven Development, Part 3
Andy Leonard continues on with his series on TDD. This time he performs some refactoring on his solution.
More Triggers
This Friday Steve Jones talks about database design and specifically asks how you prefer to design triggers.
SQL Server R2 in Luxembourg
On Nov 16, 2008, the Luxembourg SQL Server User Group will hold a SQL Server 2008 R2 event in conjunction with Microsoft.
Getting Started with Extended Events in SQL Server 2008
In a previous tip, we did an overview of Extended Events and the different components that make up Extended Events. Now that you know what Extended Events offers, how do you use it to help troubleshoot performance issues? In this tip we take a step by step look at how to implement and use Extended Events.
Live Monitoring
You can get a look into how SQLServerCentral handles the load of it's database servers with a new tool, and release of reports.
Setting SQL Server Default Locations
How to set the default locations for backups, data files, and log files in SQL Server.
November 2010 Version of SQL Server 2008 Diagnostic Information Queries
Apparently, when I posted this a few days ago, the Windows Live Writer plug-in that I used mangled the T-SQL...
SQL Saturday #61 - DC
A free day of training in Reston, VA, just outside Washington DC. Come join Andy Leonard, Allen White and others for some SQL Server learning.
SQL Server Statistics: Problems and Solutions
SQL Server Statistics assist the query optimiser to calculate the best way of running the query. Holger describes every common way that things can go wrong with statistics, and how to put matters right.
Automated Driving
Could we ever have computers automating our cars and handling the driving for us? Steve Jones doesn't think so, despite some ongoing projects.
Blogs
Narrow Task Decomposition in AI Pipeline Agents
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
Car Update: August 2026
By Steve Jones
It’s been some time since I provided a car update, so I decided to...
Microsoft Fabric OneLake Shortcuts: When to Use Them and When Not To
By James Serra
An architecture scenario Imagine separate Sales, Finance, Shared Data, and Executive Analytics workspaces. Sales...
Forums
Alamat Kantor BCA KCU Bintaro Telp:08217555651
Hub Via Wa:628217555651 Alamat: Bintaro Jaya Blok A-5 No.12 & 15, Sektor 7, Pd....
Alamat Kantor BCA KCU Alam Sutera Tlp:08217555651
Hub Via Wa:628217555651 Alamat: Perumahan Alam Sutera, Jl. Alam Sutera Boulevard No.10A, Pakulonan, Kec....
Alamat Kantor BCA KCU Tangerang Telp:08217555651
Hub Via Wa:628217555651 Alamat: Jl. Kisamaun No.57, RT.001/RW.006, Sukasari, Kec. Tangerang, Kota Tangerang, Banten...
Question of the Day
Backing Up a DMK
In SQL Server 2025, I have a database with a Database Masker Key (DMK). I want to back up this key and keep a copy offline. When do I have to open this key before running the backup?
See possible answers