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,004 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,289 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
996 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
995 reads
Blogs
Beyond VARBINARY: How to Store PDFs in SQL Server Using FILESTREAM and FileTable
By gbargsley
Hello, dear blog reader. Today’s post is coming to you straight from the home...
Impactful Sessions I’ve Seen: T-SQL Tuesday #196
By Steve Jones
This month I’m thrilled that Steve Hughes is hosting. I’ve read this Data on...
Changing the Cardinality of a FK in Redgate Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Forums
Removing TDE
Comments posted to this topic are about the item Removing TDE
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Question of the Day
Removing TDE
How do I remove TDE encryption of data from database xxx?
See possible answers