SQL Server PDW the Microwave of BI
The Path to the PDW
For decades we had the traditional electric oven to cook with and people thought it was...
2014-02-08
1,001 reads
Business Intelligence and Enterprise Architecture
SQL Server Analysis Services – SSAS Fundamentals
SQL Server Analysis Services (SSAS) Fundamentals
SSAS comes with your purchase of Microsoft’s SQL Server. It is a separate component and...
2014-02-02
3,204 reads
SQL Server Data Compression
SQL Server Data Compression Overview
I have been reviewing the options for data compression in SQL Server and believe it can...
2014-01-29
1,288 reads
Technology Alignment
Technology Alignment with Enterprise Architecture
A critical component in your Enterprise Architecture program is assuring your organization is leveraging the best...
2014-01-24
594 reads
Gathering Business Intelligence Requirements
Questions to Ask when Gathering Business Intelligence Requirements
When starting any project requirements are the key to being successful. Business intelligence...
2014-01-18
995 reads
SQL Server Filtered Index Performance
Filtered Index – Database Performance
SQL Server 2012 includes filtered indexes and is a great feature for Business Intelligence and Reporting databases. ...
2014-01-15
991 reads
Blogs
From Planning to Practice: Setting Up Your FinOps Framework
By HeyMo0sh
As someone who works in DevOps, I’m always focused on creating systems that are...
“We love to debate minutiae”
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
Advice I Like: Knots
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
Forums
how to write this query?
Hi everyone I asked this earlier but the desired outcome is a bit different...
Windows logins for users migrated from DomainA to DomainB
Hi, I have a SQL Server instance where users connect to via Windows Authentication,...
Multiple Deployment Processes
Comments posted to this topic are about the item Multiple Deployment Processes
Question of the Day
Upgrading Admin Queries
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers