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,293 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,389 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 DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
This T-SQL Tuesday is hosted by the one and only James Serra – literally...
By Steve Jones
This month we have a new host, James Serra. I’ve been trying to find...
Comments posted to this topic are about the item OPENQUERY Flexibility
Comments posted to this topic are about the item A Full Shutdown
Comments posted to this topic are about the item Going Native with Fabric Spark...
Which of these are valid OPENQUERY() uses?
See possible answers