Extended Events Workbench
The Extended Events (or XEvents) feature has been part of SQL Server since 2008, but many database professionals struggle to get started using it. In this article, Phil Factor demonstrates several useful Extended Event sessions that measure just one thing in each. He then provides the code necessary to parse the resulting XML into something you can use.
Can Auditing Fail?
It doesn't seem to be a feature that an auditing system can fail, but the application being audited continues to run.
The New Lightweight Query Plan Profile Hint
SQL Server 2016 & 2017 enable a new way to get query performance metrics live via Extended Events.
Always On - Endpoint Ownership
Whoever creates an AlwaysOn group is, by default, the owner of the endpoint. This is generally not a problem…unless that person leaves the company and you need to delete the login.
Holidays as Benefits
When you take a job, do you ask about holidays? Do you consider them a benefit? Andy Warren asks what those holidays might mean to you.
Basic Administration Tasks - Level 5 of the Stairway to for Azure SQL Database
In this next level, learn how to accomplish a few simple administration tasks that may help you manage your Azure SQL Database.
Rolling Back Migrations
The ways that one rolls back deployed database changes gets more complex with the migration development philosophy.
Generate HTML Formatted Email of SQL Server Database Consistency Check Errors
In this tip we look at to create a SQL Server DBCC CHECKDB errors email formatted in an HTML table. This will report any errors for all of your databases on the server.
Posting SQL Server notifications to Slack
Learn how you can post notifications from SQL Server directly to a Slack channel.
Blogs
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...
A Las Vegas Break
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
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