SQL Server Workload Types and Hardware Selection
There are two primary relational workload types that SQL Server commonly has to deal with, the first being Online Transaction...
2010-12-28
2,929 reads
Blog Posts
SSAS Understanding Multiple Security Roles
In a previous article I showed how you can create dynamic security in SSAS.This is a great way to make...
2010-12-28
3,200 reads
SSIS Multiple File Export
Have you ever needed to export different data sets to different flat files? Each of these data sets could be...
2010-12-28
1,471 reads
SSIS Multiple File Export
Have you ever needed to export different data sets to different flat files? Each of these data sets could be customer information for different clients – but they all...
2010-12-28
60 reads
SSMS Tools Pack (free), supports SQL Sever Denali CTP1
Free tools are very welcome to the community, while some of the creators of these kind of the tools are...
2010-12-28
1,536 reads
T-SQL: CASE Statement
This is a companion piece to the MidnightDBA video T-SQL: CASE Statement.
In short, a CASE statement is a simplified set...
2010-12-28
2,725 reads
Wrapping Up 2010
Goal Setting
It’s time to wrap up the year. I don’t have a resolutions or goals post from last year to...
2010-12-28
905 reads
A Collection of Good Information About Controlling VLFs in SQL Server
Because of the default settings in SQL Server (for the model database), and a lack of understanding about how the...
2010-12-27
567 reads
Happy Holidays
I hope everyone is enjoying the holidays. To everyone in the SQL Server community,
Merry Christmas and Happy New Year. Spend...
2010-12-27
970 reads
MCM Live Blog – Week December 27
Watching videos?! Su-ure!
Time for the third week of blogging about the things that I’m doing to study for the MCM...
2010-12-27
559 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
Kontak BCA KCP Suniaraja Telp:(08218154392)
Alamat Kontak WA CS 08218154392 Jl. Suniaraja Timur No.49, Braga, Kec. Sumur Bandung, Kota...
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....
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