Last Week Reading (2019-03-03)
Hey everyone! I was very busy at the SQLBits conference last week, but it did not stop me to prepare...
2019-03-03
308 reads
Blog Posts
Data story behind a Global Fishing Power BI report
(2019-Mar-01) The first time I heard about the Data For A Cause initiatives was at one of the Power BI meetups in Toronto....
2019-03-01
815 reads
Practical Web Scraping–More Reading
As part of my learning goals for 2018, I wanted to work through various books. This is part of my...
2019-03-01
626 reads
Published in the ISACA Journal!
In my effort to write more regularly, I’ve branched out a bit to write in the audit and compliance space....
2019-03-01
273 reads
Restoring a Database from Azure
In a previous post, I described how you can use Azure storage to store SQL Server database backup files. This...
2019-03-01
495 reads
Transforming Data With Azure Data Factory Data Flow
Azure Data Factory (ADF) offers a convenient cloud-based platform for orchestrating data from and to on-premise, on-cloud, and hybrid sources...
2019-03-01
1,951 reads
What is my why?–T-SQL Tuesday #111
This is an interesting question from Andy Leonard for T-SQL Tuesday: What Is Your “Why”? He is this month’s host...
2019-03-01 (first published: 2019-02-12)
3,154 reads
Why make?
This post is a response to this month’s T-SQL Tuesday #111 prompt by Andy Leonard. T-SQL Tuesday is a way...
2019-03-01 (first published: 2019-02-12)
3,224 reads
It’s always parameter sniffing: Line Endings
Combining a few themes of recent posts today. I’ll mix in some sp_executesql, it’s always parameter sniffing, and the plan...
2019-02-28
949 reads
SQL Server Script To Check Your Backup RPO Status
I recently wanted a script to tell me that for every database on a given server
What levels of backups I...
2019-02-28 (first published: 2019-02-13)
3,314 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