Should you move your data to the cloud?
Should you move your data to the cloud? That is the question. The answer is not simple. While moving data...
2014-11-12
752 reads
James Serra's Blog
Book: Microsoft SQL Server 2014 Business Intelligence Development Beginner’s Guide
I was fortunate to be a technical reviewer for a new book, SQL Server 2014 Business Intelligence Development by Reza...
2014-11-05
1,984 reads
Analytics Platform System (APS) AU2 released
The Analytics Platform System (APS), which is a renaming of the Parallel Data Warehouse (PDW), has recently released an appliance update (AU2),...
2014-10-16
910 reads
Non-obvious APS/PDW benefits
The Analytics Platform System (APS), which is a renaming of the Parallel Data Warehouse (PDW), has a lot of obvious...
2014-10-07
1,074 reads
IaaS, PaaS, and SaaS explained
You might be reading a lot about Cloud computing and see three acronyms frequently: IaaS, PaaS, Saas. Cloud providers offer...
2014-09-30
1,771 reads
Presentation slides for Modern Data Warehousing
Thanks to everyone who attended my session “Modern Data Warehousing” at the Central New Jersey SQL User Group yesterday. The abstract...
2014-08-14
1,219 reads
Modern Data Warehousing Presentation
I will be presenting the session “Modern Data Warehousing” tomorrow (Wednesday, August 13th) at the Central New Jersey SQL User...
2014-08-12
641 reads
24 Hours of PASS videos online
All the videos for the sessions at 24 Hours of PASS (Spring 2014) are available for free. Check the session schedule for...
2014-08-07
1,264 reads
SQL Server Agent job steps vs SSIS
When doing ETL, you have the choice of using T-SQL or SSIS (see When to use T-SQL or SSIS for ETL). ...
2014-07-22
1,324 reads
IT books that should be on your shelf
I have a lot of books on my shelves dealing with business intelligence, data warehousing, master data management, and consulting....
2014-07-16
1,218 reads
Blogs
Programmatic Tool Calling with the Claude SDK
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
A New Word: Mauerbauertraurigkeit
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
Methodology for dealing with bad data in production
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
Forums
Why SQL Server Database Attach fails and how to repair it
Comments posted to this topic are about the item Why SQL Server Database Attach...
Fixing P1 Queries
Comments posted to this topic are about the item Fixing P1 Queries
Question of the Day
BIT_COUNT() IV
In SQL Server 2025, I run this code:
select bit_count('A')
What is returned? See possible answers