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,183 reads
Blog Posts
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,469 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
50 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,530 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,711 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
904 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
560 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
969 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
553 reads
Meet a New Blogger: Malathi Mahadevan
My friend Malathi (Mala) Mahadevan has chaired the Louisville PASS Chapter for the past couple years, and will be heading...
2010-12-27
977 reads
Blogs
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
How to Find Expensive Queries in Amazon Redshift
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
The Notification Trap: How Input Fatigue Is Killing Deep Work in Tech
By gbargsley
If you've been here before, you know this blog is usually about SQL Server,...
Forums
SQL 2019 instance with AG, across 2 Windows 2016 OS servers - OSin-place upgrade
Hi all Can I get some perspective from the community please on performing in-place...
How Long is a Long I/O?
Comments posted to this topic are about the item How Long is a Long...
T-SQL Trigonometric Functions in SQL Server
Comments posted to this topic are about the item T-SQL Trigonometric Functions in SQL...
Question of the Day
How Long is a Long I/O?
In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?
See possible answers