Create a Custom Test Interface Provider for Team Sytem
This article looks at fuzzy testing and how to build a provider for your own use.
2007-11-16
3,685 reads
Articles
SQL Server 2005 Database Options and Configuration Performance Audit Checklist
As part of your performance audit, you will need to examine each database located on each of your SQL Server instances and examine some basic database settings.
2007-11-16
4,384 reads
Rethinking Analysis Services
Integrate SQL 2005, ASP.NET, Reporting Service and Analysis Services to rapidly develop and deploy a survey application for data entry and results analysis.
2007-11-15
5,651 reads
Brad McGehee On Being a Better DBA!
Brad McGehee discusses the career path of a professional database administrator. Often the DBA role is thrust upon an IT professional or developer without much in the way of specific training. Growing into the role is largely a self-motivated exercise. Brad talks about the habits that successful DBAs have, focused on on-going education and working to protect their organizations data.
2007-11-15
3,708 reads
Calculate Percentiles with SQL Server 2005
Learn one of the techniques for calculating percentiles with SQL Server 2005 using the new SQL Server Common Table Expression and the latest ROW_NUMBER function.
2007-11-15
3,442 reads
TSQL Lab I - Playing around with ROW_NUMBER
Real world solutions are key and having different techniques can sometimes help you code quicker. Longtime author Jacob Sebastian shows us how to solve a few problems with different techniques.
2007-11-14
6,186 reads
Populating Dimension Tables with the SCD Task
ETLing dimensions through SQL Server 2000 DTS, has more or less been quite a hassle, what with the lengthy ActiveX scripts and lookups that have to be performed. Enter SQL Server 2005 Integration Services: The Slowly Changing Dimension task has made it much simpler.
2007-11-14
1,887 reads
Snapshot Reports I: Report Manager Perspective
BI Architect Bill Pearson continues his subseries surrounding Caching Options, examining the use of Report Manager to configure Snapshot Caching.
2007-11-14
1,601 reads
Trigger Trivia
From SQL Server trainer and guru Andy Warren, he are a few short nuggets that you might not realize about triggers.
2007-11-13
8,610 reads
SQL Server Management Objects: Lessons from the Wild
Harness the power of SQL Server Management Objects to create, document, and manage your SQL Server databases.
2007-11-13
2,997 reads
Blogs
Overcoming Challenges: Navigating Common Pitfalls in FinOps Adoption
By HeyMo0sh
Working in DevOps, I’ve seen FinOps do amazing things for cloud cost control, but...
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
T-SQL Tuesday #197 Invitation – An impactful session or two from a conference
By DataOnWheels
I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Daily aggregation of Azure Blob Storage by tier (created/tier-change/deleted)
Hello all, I’m looking for advice on how to derive a daily snapshot table...
SQL 2017 to SQL 2025. Good to Go ?
We need to replace our Windows server running SQL 2017. Any reason not to...
Question of the Day
Using OPENJSON
I have some data in a table that looks like this:
BeerID BeerName brewer beerdescription 1 Becks Interbrew Beck's is a German-style pilsner beer 2 Fat Tire New Belgium Toasty malt, gentle sweetness, flash of fresh hop bitterness. 3 Mac n Jacks Mac & Jack's Brewery This beer erupts with a floral, hoppy taste 4 Alaskan Amber Alaskan Brewing Alaskan Brewing Amber Ale is an "alt" style beer 8 Kirin Kirin Brewing Kirin Ichiban is a Lager-type beerIf I run this, what is returned?
select t1.[key]
from openjson((select t.* FROM Beer AS t for json path)) t1 See possible answers