SQLSaturday in Houston
This upcoming Saturday I will be presenting two sessions at SQLSaturday in Houston (more info). I hope to see you...
2014-05-08
786 reads
James Serra's Blog
Hadoop and Data Warehouses
I see a lot of confusion when it comes to Hadoop and its role in a data warehouse solution. Hadoop should...
2014-05-12 (first published: 2014-05-06)
5,383 reads
Presentation Slides for Modern Data Warehousing
Thanks to everyone who attended my session “Modern Data Warehousing” at the PASS SQLSaturday Business Analytics edition in Dallas. The abstract is below. Great...
2014-05-04
1,158 reads
Modern Data Warehousing Presentation
I will be presenting the session “Modern Data Warehousing” on Saturday at the PASS SQLSaturday Business Analytics edition in Dallas...
2014-04-30
1,763 reads
What is the Microsoft Analytics Platform System (APS)?
Analytics Platform System (APS) is simply a renaming of the Parallel Data Warehouse (PDW). It is not really a new...
2014-04-17
1,327 reads
Parallel Data Warehouse (PDW) AU1 released
Microsoft’s PDW has seen a big boost in visibility and sales over the past year, and part of the reason...
2014-04-15
1,376 reads
PASS Summit 2012 session videos online
All PASS Summit 2012 recordings are now available for free to all PASS members (201 of them!). To view, log on...
2014-03-27
787 reads
Book: Reporting with Microsoft SQL Server 2012
I am happy to say I have published my first book! It is called Reporting with Microsoft SQL Server 2012...
2014-04-04 (first published: 2014-03-25)
3,860 reads
SQL Server 2014 released April 1st!
SQL Server 2014 has been released to manufacturers (RTM) and will be generally available April 1. Here is the official...
2014-03-20
1,127 reads
Parallel Data Warehouse (PDW) benefits made simple
I have heard people say that the Parallel Data Warehouse (PDW) is Microsoft’s best kept secret. So let me give a...
2014-03-18
2,457 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