Monitoring After Deployment
This Friday's poll looks at the time after deployment. Can you tell if things were successful? Do you have a formal way to determine if the changes are causing issues?
How to Eliminate Gaps in Identity Values in SQL Server by Disabling the Identity Cache
Learn how to remove gaps in Identity values in SQL Server caused by Identity Cache.
SQL Clone for Unit Testing Databases
Phil Factor demonstrates how to use SQL Clone to create 'disposable' SQL Server databases, for development and testing work. You can spin up a clone, use it to unit test your code, messing up the clone in the process, then reset the clone in seconds, ready for the next test.
SQL Server Common Table Expression vs Temp Table
In this tip we look at how to use Common Table Expressions CTE in SQL Server including the syntax, use cases, using more than 1 CTE at the same time and recursive CTEs with a parameter.
Create and deploy Azure Resource Manager templates by using the Azure portal
This article will explain and help to create and deploy ARM templates using the Azure portal. When Azure was first created, Azure resources were managed using the Azure service management (ASM), which is also known as “Classic”. Now this has been replaced and is called the Azure resource manager (ARM) API. ARM is the deployment […]
Date and Time Conversions Using SQL Server
There are many instances when dates and times don't show up at your doorstep in the format you'd like it to be, nor does the output of a query fit the needs of the people viewing it.
Introduction to SQL Server Security — Part 6
SQL Server has many tools used to make it secure. In this article, Robert Sheldon demonstrates several of these features including SQL Server Configuration Manager and the Vulnerability Assessment tool.
Databases made for Ops, not 'Oops!'
Just as you write a unit test before writing the code, so you must devise the means to monitor a database, to ensure its smooth operation, before creating the database.
Create SSRS Data Driven Subscriptions on Standard Edition
This will allow you to create "Data-Driven" subscriptions on your Standard SQL Server version.
Mastery – Repetition, Variations, and Depth
Today we have a guest editorial from Andy Warren. Andy look sat the ways in which we might solve problems and become better over time.
Blogs
How AgentDBA Identifies Backup Failures
By Arun Sirpal
Every DBA has a box like this. Sitting untouched for months. Nobody’s proud of...
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...
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