Utah Code Camp 2008
If you are near Salt Lake City on April 26th, join in the local Code Camp there.
2008-03-19
843 reads
Additional Articles
Data Compression in SQL Server 2005 (Believe it !!)
That’s correct. SQL Server 2005 SP2 supports data compression using Vardecimal data type.
2008-03-18
4,114 reads
Screencast: Tracking memory with PerfMon counters
Learn how to use SQL Server PerfMon counters to track Windows memory. SQL Server MVP Kevin Kline explains the maximum numbers to watch for when using PerfMon memory counters.
2008-03-18
2,894 reads
The curse and blessings of dynamic SQL
How you use dynamic SQL, when you should - and when you should not.
2008-03-18
6,537 reads
2008-03-17
4,990 reads
SQL Server 2005 Express Edition - Part 17 - Merge Web Synchronization
In this article, we will explore another variation of this mechanism, called Web Synchronization, with SQL Server 2005 Express Edition instances operating as merge replication subscribers connecting to a publisher via HTTPS protocol.
2008-03-17
998 reads
Fuzzy Lookup and Fuzzy Grouping in SQL Server Integration Services 2005
This paper describes the Fuzzy Lookup and Fuzzy Grouping transformations that are part of SQL Server 2005 Integration Services (SSIS). These SSIS transformations are useful for improving the data quality of existing data as well as new data that is being loaded into your database.
2008-03-14
1,809 reads
Internals of DBM Failover / Role Switching
Understanding different types of failovers/Role Switching and How do they internally work in database mirroring.
2008-03-14
1,255 reads
Employ Metadata to Enhance Search Filters
Discover how to use metadata for pooling information already resident in an application to create a flexible search interface that reduces complexity and increases users' productivity.
2008-03-13
2,613 reads
2008-03-13
3,358 reads
Blogs
Flyway Tips: Multiple Projects
By Steve Jones
One of the nice things about Flyway Desktop is that it helps you manage...
What DevOps Look Like in Microsoft Fabric
By HeyMo0sh
Microsoft Fabric (not to be confused with the more general term “fabric” in DevOps)...
T-SQL Tuesday #192: What career risks have you taken?
By James Serra
I’m honored to be hosting T-SQL Tuesday — edition #192. For those who may...
Forums
Can an Azure App Service Managed Identity be used for SQL Login?
I'm fairly certain I know the answer to this from digging into it yesterday,...
Azure Synapse database refresh
Hi Team, I am trying to refresh the Azure Synapse Dedicated pool from production...
how to write this query?
hi everyone I am not sure how to write the query that will produce...
Question of the Day
Fun with JSON I
I have some data in a table:
CREATE TABLE #test_data
(
id INT PRIMARY KEY,
name VARCHAR(100),
birth_date DATE
);
-- Step 2: Insert rows
INSERT INTO #test_data
VALUES
(1, 'Olivia', '2025-01-05'),
(2, 'Emma', '2025-03-02'),
(3, 'Liam', '2025-11-15'),
(4, 'Noah', '2025-12-22');
If I run this query, how many rows are returned?
SELECT *
FROM OPENJSON(
(
SELECT t.* FROM #test_data AS t FOR JSON PATH
)
) t; See possible answers