12 SQL Server XML Questions You Were Too Shy To Ask
Robert Sheldon answers 12 questions about XML, including situations you would want to use XML, and how to do basic tasks.
Context Is Everything - Check Your Settings
Check 96 server and database settings to make sure they match your expectations in your databases with this script.
Vocation or Career
Do you have a vocation or career? Steve Jones talks a bit about the difference today.
How column COLLATION can affect SQL Server query performance
Most DBAs, myself included, install SQL Server with the default server collation SQL_Latin1_General_CP1_CI_AS and all of our table columns get created using this default setting. This tip will look at the performance impacts of querying data with this setting as it compares to querying columns with the collation set to SQL_Latin1_General_CP1_CS_AS.
SQL Saturday #306: Redmond
On May 31, 2014 SQL Saturday is coming to Redmond, Washington. Come for a free day of SQL Server training and networking, the schedule currently features tracks on T-SQL, SSIS, Backup & Recovery and more. Register while space is available.
Better, Faster, and Cheaper
When building a system, you need to make choices. However, do you always need to make the choice of only two of the three "good, fast, or cheap" choices? Andy Warren has a few thoughts.
Index Utilization Trending
An important part of regular database maintenance is to monitor index usage and make adjustments as needed. How can we monitor, store, and trend this data effectively over time?
Lots of Security Concerns
This past week saw lots of security concerns, especially around data. Steve Jones has a few comments about the implications.
SQL Server Reporting Services Basics: Building SSRS Reports
Kathi Kellenberger describes the basics of SSRS before showing you how to build quick, simple reports.
How to centralize your SQL Server Event Logs
Learn how you can centralize the Event log data for your servers using a process that Geoff Albin has been using for over 10 years.
Blogs
AI Helps Me with My Sloppiness
By Steve Jones
I type fairly well. Well, I type fast, but I do wear out a...
WITH clause gets a 26ai boost!
By way of background, a while back I did video called “My New Favourite...
Automatic Index Compaction
By ReviewMyDB
Index maintenance has always meant nightly jobs and a window you have to defend....
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
How We Handled a Vendor Retry That Loaded Twice in Snowflake
Comments posted to this topic are about the item How We Handled a Vendor...
Cognitive Coverage
Comments posted to this topic are about the item Cognitive Coverage
Question of the Day
Getting the Average
I have this data in the dbo.Commission table in a SQL Server 2022 database.
salesperson commission Brian 12 Brian 16 Andy 7 Andy 14 Andy 21 Steve 20 Steve NULLAll the data is a varchar, and I decide to run this query to get the totals for each salesperson.
SELECT SalesPerson
, AVG(TRY_PARSE(Commission AS int)) AS TotalCommission
FROM commission
GROUP BY SalesPerson
GO
What average commission is calculated for Steve? See possible answers