Building a Countdown Timer with PowerShell
Every DBA should have basic PowerShell skills. In this article, Greg Moore explains how to write a PowerShell script that can create a window for a countdown timer.
Using SQL Change Automation in SSMS to Track Static Data Changes
SQL Change Automation 4.1 now allows users to develop static data changes from SQL Server Management Studio.
SSIS Catalog Environments– Step 20 of the Stairway to Integration Services
In this next level of the Stairway to Integration Services, we look at the SSIS catalog environments and how they help you manage your package parameters.
Upsizing the SQL ConstantCare® Database Servers
If you’re looking for SQL Server news, just skip this post. Brent talks about general business & capacity planning type stuff here today.
Browsing SSAS Instance over the internet
Problem Developing OLAP cubes have always been fascinating to me. Right after completing the development of a data warehouse, my next line of action often becomes setting up Analysis Services for the warehouse. Although, there are multiple client tools readily available in the market to perform some analysis on this SSAS Server, sometimes it is […]
Looking Back at the Decade
Today is the last day of 2019, and the last day of the 2010 decade. I'm still somewhat amazed by the fact that we're entering the 2020s and we still don't really have flying cars. We're well past 2001 and 2010, and still not much space exploration, though the growth in computing power and AI/ML […]
SQL Server Create Database Examples
In this article we look at different T-SQL examples to create a new SQL Server database.
Blocking Private Messages
A new feature on SQLServerCentral to allow you more control over who can contact you.
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...
SQL Server Still Wins
Comments posted to this topic are about the item SQL Server Still Wins
DBCC CHECKDB Limits I
Comments posted to this topic are about the item DBCC CHECKDB Limits I
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