sp_AllNightLog: Creating Jobs Like I’m The President
Erik Darling explains why sp_AllNightLog creates so many jobs by default.
A Backup Change
Steve Jones talks about backup of data today and the challenges of managing this at scale.
Protecting SQL Server from Ransomware
The problem of ransomware seems to be increasing. Major organizations are being hit and their servers are being affected. K. Brian Kelley explains some of the basic things you can do to reduce your expose to ransomeware.
The Randomness of Analog
A look back at the random nature of finding information in libraries and bookstores. A feeling Steve Jones misses.
SQL Data Aggregation Aggravation
When we have to deal with and store a lot of data, it makes sense to aggregate it so that we store only the information we actually need. If we get this right, this works well, but the design of the system takes care and thought because the problems can be subtle and various. Joe Celko describes some of the ways that things can go wrong and end up providing incorrect, inaccurate or misleading results.
The struggle to renormalize data
You are given an export of a NoSQL database, in JSON, and asked to import it into a relational database. Sounds easy? It isn't and Phil Factor explain why.
What Mail Items Have Been Sent With Database Mail
Have you ever wondered how much database mail you have sent in the past day or week? What about those database mail items that were not successfully sent. In this tip, Greg Larsen shows you how to review the database mail items that have been processed by SQL Server.
The Control Poll
Do you use version control for your databases? For your application code? Is there a time when you think it's not needed? Steve Jones asks the question today.
Blogs
Case Studies: Real-World Success Stories of FinOps Implementation
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers