Use PowerShell to script existing Availability Group creation scripts!
Scripts that write scripts! One of my favorites!
So last night I was up working on an issue with an Availability...
2016-04-07 (first published: 2016-04-04)
7,552 reads
cjsommer.com
Use PowerShell to script existing Availability Group creation scripts!
Scripts that write scripts! One of my favorites!
So last night I was up working on an issue with an Availability...
2016-04-04
218 reads
Speaking at SQL Saturday #487 in Ottawa on April 16, 2016
If you are a SQL Server professional and are interested in spending a day with a bunch of other like-minded...
2016-04-03
469 reads
Speaking at SQL Saturday 487 in Ottawa on April 16, 2016
<img alt=’’ class=’alignright size-full wp-image-1238 ‘src=’/img/2016/04/img_570152b22dc45.png’>
If you are a SQL Server professional and are interested in spending a day...
2016-04-03
70 reads
Announcing SQL Server on Linux
Yes, you read that right. SQL Server will be ported to Linux. Here’s the Blog post from Scott Guthrie.
http://blogs.microsoft.com/blog/2016/03/07/announcing-sql-server-on-linux/
Today I’m...
2016-03-08
488 reads
Announcing SQL Server on Linux
Yes, you read that right. SQL Server will be ported to Linux. Here’s the Blog post from Scott Guthrie.
http://blogs.microsoft.com/blog/2016/03/07/announcing-sql-server-on-linux/
Today I’m...
2016-03-08
147 reads
Slow Running Query? Where do I Begin?
Maybe you’re new to SQL Server or maybe you’re just expanding into performance tuning a little more. Query tuning can...
2015-12-29
1,815 reads
Slow Running Query? Where do I Begin?
Maybe you’re new to SQL Server or maybe you’re just expanding into performance tuning a little more. Query tuning can...
2015-12-29
484 reads
T-SQL Tuesday #73 – Naughty or Nice?
Thank you to SQLBalls ( b | t ) for hosting this month’s #tsql2sday.
As you work with SQL Server look around you....
2015-12-09
1,487 reads
T-SQL Tuesday 73 – Naughty or Nice?
Thank you to SQLBalls ( b | t ) for hosting this month’s #tsql2sday.
As you work with SQL Server look around you. Is...
2015-12-08
85 reads
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