There should only be one ...
When visiting clients, I often find that one or more databases have a table (or several) containing metadata. Most often, these tables have only a single row of data...
2010-11-16
9 reads
There should only be one ...
When visiting clients, I often find that one or more databases have a table (or several) containing metadata. Most often, these tables have only a single row of data...
2010-11-16
9 reads
There should only be one ...
When visiting clients, I often find that one or more databases have a table (or several) containing metadata. Most often,...
2010-11-16
619 reads
Handy Hardware Assessment Tools For SQL Server
Here is a small selection of useful tools for getting some specific hardware information from any Windows based system you...
2010-11-16
2,257 reads
Backup log Truncate_Only in SQL Server 2008
BACKUP LOG <db_name> WITH truncate_only command, used for clearing the log file, is deprecated in SQL Server 2008. So this post will explain option...
2010-11-16
1,679 reads
My SQL PASS Summit Adventures part 1
I started my PASS Summit a little early this year. I arrived in Seattle on Friday night, November 5th, around...
2010-11-16
591 reads
How Often Do You Backup Your Transaction Logs?
Whenever I speak about database maintenance, I always recommend that DBAs backup up their production database transaction logs at least...
2010-11-16
1,870 reads
Get Drive Space Including Mount Points
Today’s post is a quick one that came out of a conversation on Twitter. To make a long story short,...
2010-11-15
2,850 reads
Help Set Recommendations for SSAS Counters in PAL
First, if you haven’t tried PAL yet, I highly recommend downloading it from CodePlex and giving it a try. You...
2010-11-15
893 reads
PASS Report 1: Why you should have been there!
PASS Summit 2010 is now history. This is my eighth summit but the first one since leaving the DBA world...
2010-11-15
1,562 reads
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 BCA KCU Gading Serpong Tlp:08218154374
Hub Via Wa:628218154374 Alamat Summarecon Serpong, Perumahan Gading Serpong, Jl. Gading Serpong Boulevard Cluster...
Alamat BCA KCU Tangerang City Telp:08218154374
Hub Via Wa:628218154374 Alamat Komp. Tangerang City Ruko Skandinavia Blok H 6-8 & 18-20,...
Alamat Kantor BCA KCU Serang Telp:08218154374
Hub Via Wa:628218154374 Alamat Jl. Pangeran Diponegoro No.14, Kotabaru, Kec. Serang, Kota Serang, 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