Cleaning up Query Store data after database restore
Query Store is a very powerful tool for performance tuning, if you are not using it already you should!! It...
2018-08-29 (first published: 2018-08-13)
2,074 reads
Blog Posts
Delayed durability, the TURBO button for your transaction log
As noted in the previous post, this month I got my learn on at Tech Outbound’s SQL Cruise Alaska. Which was awesome in so many ways, but I’m only...
2018-08-29
9 reads
Employee Agreements & Contracts: Best Practices (23 minute video)
So you’ve got an employee agreement in front of you: now what? In this episode, I talk about practical steps you should take to make sure that you understand...
2018-08-29
5 reads
How Azure Storage Kick Starts Your Big Data Projects
So, your boss says, ‘Let’s do big data!’ And you think: ‘I don’t even know what that means or what...
2018-08-29
978 reads
Next week is SQL in the City Streamed
This picture is out of date. I’ll make sure we get a new one next week at SQL in the...
2018-08-29
367 reads
Power BI Custom Visuals Class (Module 117 – Multi KPI)
In this module you will learn how to use the Multi KPI. The Multi KPI is great for displaying multiple...
2018-08-29
1,184 reads
SQL Puzzle: Advent of Code
A few years back someone started the Advent of code. If you aren’t familiar with it, it’s an advent calendar...
2018-08-29
521 reads
Undercover TV- Episode 2
The latest webcast from SQLUndercover.com. In this episode David and Adrian take a look at a few blog posts that have caught...
2018-08-29
377 reads
What are my permissions?
Permissions are a common concern. One of the most frequent requests I get is I need X, Y and Z...
2018-08-29 (first published: 2018-08-16)
3,196 reads
Deleting Azure SQL DB
So you want to do a clean-up exercise in Azure and remove some databases. You go to delete a database...
2018-08-28
229 reads
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