Planning Ahead - Single Node Clusters
People don't plan to fail; they fail to plan. Single node clustering provides organisations with a ready made scale-up or high availability platform from the beginning of the deployment.
Hub-And-Spoke: Building an EDW with SQL Server and Strategies of Implementation
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.
SSC, more than a Forum, it is a Community
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...
The Best Minds
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.
The Best Minds
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.
The Best Minds
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.
Using Microsoft Hyper-V for SQL Server consolidation
Learn about the advantages available for SQL Server consolidation and virtualization when running SQL Server 2008 on Microsoft Hyper-V for Windows 2008.
The Simple Estimate
Why can't it be easy for someone to tackle small projects? It is in some areas, and Steve Jones talks a little about some of the issues.
One Database, One Server
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...
The 10 Essential Rules of Dimensional Modeling
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.
Blogs
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...
A Cloud Dependency Failure from Amazon
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
Deploying AI in logistics (the unfiltered version)
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
Forums
BCA KCP Kramat Jaya Huby/WA 08218573837
Jl. Kramat Jaya Raya No.10 Blok F1, Semper Bar., Kec. Cilincing, Jkt Utara, Daerah...
BCA KCU TANJUNG PRIOK TLP/, WA 08216677749
Jl. Enggano No.22-23, RT.8/RW.16, Tj. Priok, Kec. Tj. Priok, Jkt Utara, Daerah Khusus Ibukota...
BCA KCP Jembatan Merah HUB/WA 08216977749
Jl. Raya Mangga Besar No.177 C, Mangga Dua Sel., Kecamatan Sawah Besar, Kota Jakarta...
Question of the Day
Creating a JSON Document III
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT TOP 2
json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers