Notes From the 2018 PASS Summit (v20)
This was the 20th PASS Summit, a decent milestone! Interesting to pause and think, what will the Summit look like...
2018-11-12
255 reads
Blog Posts
Part 1: Predictive Modeling using R and SQL Server Machine Learning Services
To R or not to R? A few months ago, I asked myself an important question – which language to learn first – R or Python? From my research,...
2018-11-12
14 reads
Part 1: Predictive Modeling using R and SQL Server Machine Learning Services
To R or not to R?
A few months ago, I asked myself an important question – which language to learn first...
2018-11-12
627 reads
Random Pix from the 2018 PASS Summit
A few memories from me. First, a beautiful late arrival view.
My first session feels a little lonely
It started to fill...
2018-11-12
782 reads
Speaking At SQL Saturday DC
I am so excited to announce that I was selected to speak at SQL Saturday DC on December 8, 2018. I will be presenting two sessions, What is Power...
2018-11-12
6 reads
Speaking At SQL Saturday DC
I am so excited to announce that I was selected to speak at SQL Saturday DC on December 8, 2018.
I...
2018-11-12
158 reads
SQLCLR vs SQL Server 2017, Part 9: Does PERMISSION_SET Still Matter, or is Everything Now UNSAFE?
(last updated: 2018-11-01 @ 00:50 EDT / 2018-11-01 @ 04:50 UTC )
SQL Server 2017 introduced a new security restriction for SQLCLR in the...
2018-11-12 (first published: 2018-10-31)
3,393 reads
Zombie SQL
It Halloween so time for a scary SQL story. Ok, maybe not that scary. Ok, not scary at all, but...
2018-11-12 (first published: 2018-10-31)
2,898 reads
Getting Started with Installing Kubernetes On-Prem
Let’s get you started on your Kubernetes journey with installing Kubernetes on premises in virtual machines.
Kubernetes is a distributed system,...
2018-11-11
1,220 reads
Getting Started with Installing Kubernetes On-Prem
Let’s get you started on your Kubernetes journey with installing Kubernetes on premises in virtual machines. Kubernetes is a distributed system, you will be creating a cluster which will have...
2018-11-11
3 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