This document describes common data warehouse implementation strategies and proposes an effective hub-and-spoke architecture using a massively parallel processing system with multiple instances of SQL Server databases.
2009-06-17
2,159 reads
I recently posted a poll on SQLServerCentral.com asking what sites people tended to frequent. So far, there haven't been a whole lot of votes, but those who have, have been unanimous in using SQLServerCentral.com and have indicated that there are...
2009-06-17
1,211 reads
What do you want when you go to a conference? Great speakers or great information? Steve Jones talks a little about how we get both in the future.
2009-06-17
528 reads
What do you want when you go to a conference? Great speakers or great information? Steve Jones talks a little about how we get both in the future.
2009-06-17
496 reads
What do you want when you go to a conference? Great speakers or great information? Steve Jones talks a little about how we get both in the future.
2009-06-17
770 reads
Learn about the advantages available for SQL Server consolidation and virtualization when running SQL Server 2008 on Microsoft Hyper-V for Windows 2008.
2009-06-17
2,531 reads
As background, I've never been a fan of multiple instances. It's a useful thing to have available and I use it on a server today, but it's never provided a solid way of isolating resources for each instance. Next, one of the things I evangelize...
2009-06-16
3,267 reads
Follow the rules to ensure granular data, flexibility and a future-proofed information resource. Break the rules and you'll confuse users and run into data warehousing brick walls.
2009-06-16
4,808 reads
"Best of SQLServerCentral v6" pulls together some of the best, most popular, and the most read articles of 2008, in dead tree format, covering database administration, BI, design, security, T-SQL, and most things in between.
2009-06-15
7,892 reads
In Part 2 of our series we will examine how to create custom templates and how to save collected trace data.
2009-06-15
4,428 reads
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
Hi all, I've just had to roll back my SSMS 22 version from 22.3.0,...
Hi! I've been banging my head against the wall for 2 days now trying...
Comments posted to this topic are about the item The Power of Data and...
In SQL Server 2025, there is a new function that returns the current date without the time. What is it?
See possible answers