Installing Extensions to Azure Data Studio
If you’re even thinking about experimenting with, let alone actively using, Azure Data Studio, you need to plan on installing...
2019-02-18
313 reads
Blog Posts
Partitioning 5: The extra partition
So, we’ve set up a table with table partitioning on the RIGHT for CreationDate. We defined 11 partitions, and in...
2019-02-18
165 reads
Speaking at SQLBits in March 2019
I’m super excited about the fact I’ll be speaking at SQLBits this year. It’s my first time as a speaker...
2019-02-18
120 reads
SQL Server, What Waits Happened In The Last X Seconds
There are plenty of scripts out there that can show you the waits that are occurring on your server, however,...
2019-02-18
169 reads
SQLSaturday Atlanta & South Florida 2019
I’ll be in South Florida again this year and will stay over as usual for a couple days of vacation....
2019-02-18
162 reads
SQLSaturday Atlanta & South Florida 2019
I’ll be in South Florida again this year and will stay over as usual for a couple days of vacation. I see Brent is attending; I’ll have to make...
2019-02-18
9 reads
Upcoming SQLpassion Trainings
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2019-02-18
128 reads
Weekly reading #3
New week, new challenges! Great to see you again. We are always here Monday morning! No need to check earlier...
2019-02-18
112 reads
Azure Databricks – Introduction (Free Trial)
Microsoft’s Azure Databricks is an advanced Apache Spark platform that brings data and business teams together. In this introductory article, we will look at what the use cases for...
2019-02-17
19 reads
Azure Databricks – Introduction (Free Trial)
Microsoft’s Azure Databricks is an advanced Apache Spark platform that brings data and business teams together. In this introductory article,...
2019-02-17
496 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