An examination of bulk-logged recovery model
This article looks at the bulk-logged recovery model in depth and examines how it affects disaster recovery and logging.
Mobile Password Protection
Security is becoming more of an issue for mobile devices as we store and access more information on them all the time.
Responsibility for Security
Steve Jones talks about security, and the developer's role in ensuring secure code.
Big Data is Just a Fad
The Term 'Big Data' is nothing more than a fad, and we'll soon be cringing with embarrassment at the thought that we ever used it. However, the data, and the challenges to processing it that it presents, will stay with us. If jargon like 'Big Data' helps us focus on the problems, then let’s use it: temporarily, perhaps.
Red Gate releases SQL Backup Pro 7
Red Gate Software has released SQL Backup Pro 7 with pioneering new features focused on SQL Server backup verification. SQL Backup Pro 7’s step-by-step scheduling wizards aim to simplify the process of restoring and verifying backups.
The Best Way to Learn
This Friday Steve Jones is looking to see how you might like to improve your educational materials. With the success of our Stairway Series, we are looking to find better ways to teach people about SQL Server.
Implementing Lookup Logic in SQL Server Integration Services
With SSIS, you can perform a lookup on data in the course of a task, using referenced data from any OLE DB source. It is a useful feature that enables you to check on the validity of data, or interpret it before proceeding. Robert Sheldon explains.
Learn XML
Steve Jones talks about XML and how it will be more and more important for DBAs to understand this in the future.
Red Gate launches Exceptional DBA Awards 2012 - bringing DBAs the recognition they deserve
The 2012 Exceptional DBA awards are back. Learn how you can enter and win a trip to the 2012 PASS Summit.
Selecting from hierarchies like Managers and Employees
Chuck Hoffman shows a technique using sets for selecting records from hierarchies such as Manager / Employee structures.
Blogs
AI Helps Me with My Sloppiness
By Steve Jones
I type fairly well. Well, I type fast, but I do wear out a...
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...
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