T-SQL Tuesday #120 – What were you thinking? – Invitation
In this month's T-SQL Tuesday, I want to know about things that you have seen someone do in SQL Server that has left you wonder "What were you thinking?"
The...
2019-11-05
11 reads
Blog Posts
Book Review: Eat People – And Other Unapologetic Rules For Game-Changing Entrepreneurs
This book simply answers the question "What's the next big thing?". The "Unapologetic Rules" will walk you through the many elements of exactly finding that out. Continue reading ?
The...
2019-11-04
25 reads
Build a SQL Cluster Lab Part 2
You are going to create a Windows Cluster in Part 2 of our series on how to build a SQL Cluster Lab. You will run cluster validation followed by...
2019-11-04
19 reads
Build a SQL Cluster Lab Part 2
You are going to create a Windows Cluster in Part 2 of our series on how to build a SQL Cluster Lab. You will run cluster validation followed by...
2019-11-04
29 reads
Build a SQL Cluster Lab Part 2
You are going to create a Windows Cluster in Part 2 of our series on how to build a SQL Cluster Lab. You will run […]
The post Build a...
2019-11-04
12 reads
Deadlocks – Azure SQL Database
Would you like to troubleshoot a deadlock in Azure SQL Database? To do this you probably will be after the deadlock graph. So does this mean that you need...
2019-11-04
143 reads
Project Management and Advocacy
I’ve observed few similarities between the Project Managers and Advocates. Being Project Manager, law bachelor and little practical experienced as an Advocate, I noticed few similarities. I think it’s...
2019-11-04
13 reads
Project Management and Advocacy
I’ve observed few similarities between the Project Managers and Advocates. Being Project Manager, law bachelor and little practical experienced as an Advocate, I noticed few similarities. I think it’s...
2019-11-04
21 reads
Resumable online index rebuild
continue on whats new SQL Server 2017 their is a great feature call resumable online index, means online index now has an option to PAUSE and RESUME or ABORT...
2019-11-04
142 reads
SQL Homework – November 2019 – SSMS built in reports
Time for some homework again. I know Pass Summit is this week so you may be a bit busy but ... Continue reading
2019-11-04
33 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