Monitoring on a Budget
Have you ever been asked for information you couldn't provide because you didn't have an historical monitoring tool? Try this
Open Enrollment
It's the time of year where employment benefits renew for many US employees. Steve Jones talks about how much your company should care about your health.
The Weekly News for November 19, 2007
A few comments on the news of the past week: SQL Server 2008 CPT5, a 1.6SSD Array, Non-Compete agreements and more.
Declarative Management Framework - Performing Policy Management
The Declarative Management Framework is a new policy based management framework included with the upcoming SQL Server 2008. Using this feature administrators can define policies to govern their SQL Server environments much like in the Windows environment. This article, written based on the SQL Server "Katmai" July CTP introduces you to the DMF and shows you how you can perform policy management.
Importing Text-based data: Workbench
Robyn and Phil return with some fresh ideas about how to import text files into SQL Server, without resorting to DTS or SSIS scripting. They go on to show how much can be done in TSQL
SQL Server Job Scheduling
The scheduling system in SQL Server is quite flexible and powerful, but can be confusing at times. Peter He looks at some of the advanced options you have in automating the various jobs on your server.
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.
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.
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.
Blogs
Automatic Index Compaction
By ReviewMyDB
Index maintenance has always meant nightly jobs and a window you have to defend....
The Goldilocks problem – Materialized Views
I’m sure you’ve all heard the tale of Goldilocks and the Three Bears, but...
Monday Monitor Tips: Virtual Machine Usage and Cost
By Steve Jones
One of the things I’ve been requesting for a number of years is cost...
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