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
996 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,198 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,286 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
590 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
982 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
988 reads
Blogs
Scooby Dooing Episode 9: The Case of the Artificially Intelligent Villain
Welcome back, my fellow sleuths, to my mystery-inspired blog series! I’m having a ton...
The Book of Redgate: Don’t be an a**hole
By Steve Jones
This was one of the original values: The facing page has this text: No...
Beyond Pipelines: How Fabric Reinvents Data Movement for the Modern Enterprise
By Chris Yates
For decades, enterprises have thought about data like plumbers think about water: you build...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
Are things getting beyond reason?
My wife apparently ask her phone a question and below is what she sent...
I Love Editorials
Comments posted to this topic are about the item I Love Editorials
Question of the Day
A Common Split
What happens when I run this code:
DECLARE @s VARCHAR(1000) = 'apple, pear, peach' SELECT * FROM STRING_SPLIT(@s, ', ')See possible answers