Learning New Skills
This post is a response to this month's T-SQL Tuesday #108 prompt by Malathi Mahadevan. T-SQL Tuesday is a way for the SQL Server community to share ideas about...
2018-11-06
3 reads
Blog Posts
PASS Summit 2018 Activities
What a whirlwind year this has been! I’m thrilled to invite you to my sessions at this year’s PASS Summit,...
2018-11-06
70 reads
Premium blob storage
As a follow-up to my blog Azure Archive Blob Storage, Microsoft has released another storage tier called Azure Premium Blob Storage (announcement). It is in private preview in US East...
2018-11-06
10 reads
Should you update stats for your SQL Server database?
Statistics on database objects are very important to the SQL Server engine optimizing execution plans and running at the most...
2018-11-06
300 reads
T-SQL Tuesday #108 - Learning Tech Beyond SQL Server
Malathi Mahadevan (blog|twitter) is hosting this month’s T-SQL Tuesday, a monthly blog party for the SQL Server community.
Malathi has asked us to:
Pick one thing you want to learn that...
2018-11-06
6 reads
Using MAXDOP to fix a performance problem
As DBA’s we are sometimes put in a rock and hard place when it comes to database performance. This situation...
2018-11-06 (first published: 2018-10-29)
4,527 reads
Want to learn about Azure Data Studio (formerly SQL Operations Studio)
Come see my inaugural presentation at the Lexington PASS User Group meeting, Tuesday, Nov 13th, at 6:30 PM at the Blue Stallion Brewing Co. Azure Data Studio [pptx 6MB]
2018-11-06
35 reads
Better Keyboard Extensions in Azure Data Studio
I used to use ALT+X to execute queries in SSMS. I spent years with this shortcut, but as I started...
2018-11-05 (first published: 2018-10-23)
2,234 reads
Failed Installation of SQL Server Cumulative Updates Debugged
Background
Our customer has recently experienced an issue during the installation of the latest cumulative updates in their SQL Server environment....
2018-11-05
636 reads
Identifying delays between SQL calls using SQL profiler
One of the common goto methods for query specific slowness which can be replicated via an application can be to...
2018-11-05 (first published: 2018-10-24)
2,203 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