CHECKSUM vs HashBytes
Hashing can be useful in Data Warehousing as well It can give you the ability to break large problems into...
2012-02-01
30,103 reads
Garrett Hilton Edmondson
Tabular Model
One of the most exciting features in SQL Server 2012 is the introduction of the Tabular Model. The Tabular model...
2012-01-31
3,494 reads
Master Data Services 2012
As I mentioned in a pervious post Master Data Services for SQL 2012 is a huge improvement over the SQL...
2012-01-19
3,602 reads
SSIS ETL Frameworks
In my years as a BI Professional I have seen many ETL Frameworks. They range from homegrown internal solution to...
2012-01-04
9,676 reads
Learn SQL 2012
Microsoft is working on the next round of certification exams for SQL Server 2012. So now is the best time...
2011-12-28
1,620 reads
ETL from Oracle to SQL Server
I was recently asked to provide some performance tuning recommendations for an ETL process that extracts data from Oracle using...
2011-12-21
7,954 reads
Data Mining
Data mining techniques can be used in virtually all business applications, answering various types of businesses questions. In truth, given...
2011-12-14
2,352 reads
SQL Server 2008R2 BI Presenations
I recently gave a couple of presentations about the new Business Intelligence features in SQL Server 2008 R2. Here are...
2011-11-11
1,519 reads
Dimensional Modeling Financial Data in SSAS pt2
Unary Operator and Aggregating over time
In my last post I discussed how to arrange all of the GLs into a...
2011-11-03
3,269 reads
Dimensional Modeling Financial Data in SSAS
Part 1 – Parent Child Hierarchies and Pseudo GL Accounts
This post is born out of some real life lessons that I...
2011-10-26
5,523 reads
Blogs
“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....
Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
Forums
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
How to Use sqlpackage to Detect Schema Drift Between Azure SQL Databases
Comments posted to this topic are about the item How to Use sqlpackage to...
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