Methods for populating a data warehouse
Source tables change over time. A data mart or data warehouse that is based on those tables needs to reflect these...
2011-08-19
4,945 reads
Source tables change over time. A data mart or data warehouse that is based on those tables needs to reflect these...
2011-08-19
4,945 reads
Microsoft SharePoint Online is a cloud-based service that is part of the recently released Microsoft Office 365. For those of us...
2011-08-17
927 reads
If you are using a SSIS lookup transformation editor and the reference dataset is large (millions of rows) and you...
2011-08-15
12,295 reads
There is a very interesting new Microsoft program that started back in January, called the SSAS Maestro Program. It is a five-day,...
2011-08-12
1,117 reads
Released today, the SQL Server code name ‘Denali’ Community Technical Preview 3 (CTP3) Product Guide download contains the latest datasheets, white...
2011-08-11
1,259 reads
Replaying multiple threads of a captured trace in SQL Profiler is difficult, and you are limited to replaying the workload from...
2011-08-10
1,588 reads
For those of you who use MDX, I’m sure you share my opinion that MDX is a lot harder to...
2011-08-08
784 reads
I take it for granted that everyone knows all about Microsoft certifications and Microsoft MVP’s. But a few years ago,...
2011-08-05
1,643 reads
As a consultant or contractor, many times the client we are at does not provide us with a laptop, so we must...
2011-08-03
1,392 reads
Project Apollo is a new feature in CTP3 of SQL Server Denali that enables a new columnstore index that offers...
2011-08-01
1,667 reads
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
By Brian Kelley
On Patch Tuesday, in addition to OS and Office security patches, Microsoft also released...
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
Comments posted to this topic are about the item Multiple Deployment Processes
Comments posted to this topic are about the item How to Use sqlpackage to...
Comments posted to this topic are about the item 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