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,479 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
909 reads
RTFM365, Week 3
Well, my brain has increased by 12.4% in terms of SQL knowledge this week, as a direct result of my...
2010-12-28
773 reads
Can You Dig It? – StmtCursor and StmtReceive Elements
She can dig it!
D Sharon PruittA few posts ago in the plan cache series I discussed the children for the...
2010-12-28
1,221 reads
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,203 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,543 reads
Getting a Dedicated Admin Connection
Did you know you can easily get a Dedicated Admin Connection (DAC) in SSMS? I didn’t assuming that I’d need...
2010-12-28
1,207 reads
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,942 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
977 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
580 reads
Blogs
Fighting Procrastination?
By Brian Kelley
Here is another short video (~ 15 minutes). This is by the author of...
A Fun Prize at the PASS Data Community Summit
By Steve Jones
I had a briefing for the 2026 PASS Data Community Summit, which is just...
How to Measure AI Value: A 6-Branch AI Maturity Model for Use Cases and Agents
Your AI is busy. But do you know what it's worth? Most companies can...
Forums
Alamat BCA KCU BINTARO Telp:0821°8200°233
Telp/Wa 628218200233 Bintaro Jaya Blok A-5 No.12 & 15, Sektor 7, Pd. Jaya, Kec....
Alamat BCA KCP Labuan Telp:0821°8200°203
Telp/Wa 628218200203 Jl. Raya Labuan - Pandeglang No.01, Labuan, Kec. Labuan, Kabupaten Pandeglang, Banten...
Alamat BCA KCP Cilegon II Telp:0821°7555°651
Telp/Wa 628217555651 Ruko Cilegon City Square, Jl. Pondok Cilegon Indah No.1 Blok A No....
Question of the Day
SQL Server 2025 Server-level Roles
In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?
See possible answers