Fire Drills
How often do you have those fire drills, testing what you would do in the event of an emergency. Would you be satisfied with a 30% success rate?
SQL Server Scalabilty - An Introduction
A brief introduction into the world of scalability, presenting at a high-level the various options
XML Workshop XVI - Shaping the XML results
Continuing on with his series, Jacob Sebastian shows how you can shape the query results to a certain pre-defined XML structure in this article.
CS Techcast 16: Revving Up SQL Server 2008
CStechcast.com brings another podcast episode to the starting line with guest Kalen Delaney. This SQL Server expert and authoritative author of the Inside SQL Server series gives us her take on SQL Server 2008. Find the latest from Kalen Delaney at insidesqlserver.com and SQLCommunity.com.
Hubs, Spokes and Buses: How to Get to a Better Data Warehouse
Are you frustrated by the inefficiency, rigidity and latency of a first-generation, hub-and-spoke-architecture data warehouse? Here's a six-step guide to evolving to a streamlined, robust Kimball Dimensional Bus Architecture that will reduce time to reporting, lower data latency, and deliver more detailed, analytically useful information.
Utah Code Camp 2008
If you are near Salt Lake City on April 26th, join in the local Code Camp there.
Common Table Expressions
They are new to SQL Server in 2005, but they are not necessarily in common use for many people. New author Kirk Kuykendall brings us a basic look on what a CTE is and how you can use it.
Blogs
Azure SQL Managed Instance Next-Gen: Bring on the IOPS
By John
If you’ve used Azure SQL Managed Instance General Purpose, you know the drill: to...
SQL, MDX, DAX – the languages of data
By DataOnWheels
Ramblings of a retired data architect Let me start by saying that I have...
Setting PK Names in Redgate Data Modeler
By Steve Jones
A customer was testing Redgate Data Modeler and complained that it auto-generated PK names....
Forums
Connecting Power BI to SSAS and effective user not working
Hi everyone, Below is a consolidated summary of what we validated Architecture & data...
High Availability setup - has anyone seen this method?
Hi all, I recently moved to a new employer who have their HA setup...
Semantic Search in SQL Server 2025
Comments posted to this topic are about the item Semantic Search in SQL Server...
Question of the Day
Encoding URLs
I have this data in a SQL Server 2025 table:
CREATE TABLE Response ( ResponseID INT NOT NULL CONSTRAINT ResponsePK PRIMARY KEY , ResponseVal VARBINARY(5000) ) GOIf I want to get a value from this table that I can add to a URL in a browser, which of these code items produces a result I can use? See possible answers