Migrating From Hipchat To Slack
Last Minute Migration?
If you are about to perform a last minute migration here's a couple tips as you jump ship from Hipchat and move to Slack. Hipchat is sunsetting...
2019-02-07
6 reads
Blog Posts
Optimizing for Ad Hoc Workloads
Watch this week’s episode on YouTube.
The execution plan cache is a great feature: after SQL Server goes through the effort...
2019-02-07 (first published: 2019-01-22)
2,193 reads
SQL Server Database Experimentation Assistant - How to Run a Capture
DEA
Very basic look at the setup as I couldn’t find much documentation on this when I last tried this out in 2018. Maybe it will help you get started...
2019-02-07
8 reads
Automating T-SQL for Azure SQL Database via Logic Apps
Have you ever wanted to capture the T-SQL, waits, sessions IDs (etc) at a specific time for Azure SQL Database?...
2019-02-06
224 reads
Azure Data Factory integration with GitHub
(2019-Feb-06) Working with Azure Data Factory (ADF) enables me to build and monitor my Extract Transform Load (ETL) workflows in Azure....
2019-02-06
453 reads
Bad indexing can show up in wait statistics
At first, this statement might sound a bit confusing. Usually, we expect wait statistics to show us what a query...
2019-02-06
221 reads
CLR Strict Security in SQL 2017
Locking down CLR
I recently ran into SQL 2017’s new CLR Strict Security. I was working with a client where we...
2019-02-06 (first published: 2019-01-21)
6,558 reads
Join me for the PASS Data Expert Series Feb 7
I’m honored to have one of my PASS Summit sessions chosen to be part of the PASS Data Expert Series...
2019-02-06
149 reads
Midlands PASS Meeting for April 2019
The Midlands PASS April 2019 meeting will be held on April 2nd and we’ll be welcoming Matt Gordon (twitter | website)!
Meeting...
2019-02-06
140 reads
SQL server connection and blocking finding script
SQL server connection and blocking finding script...
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
2019-02-06
11 reads
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