Query Store - Part 4 - Find the plans and queries forced by Query Store
As most of you know, one of the most fundamental uses of query store is to force query plans. Unlike...
2016-12-08
1,084 reads
Blog Posts
SSIS Data Flow "Sequence Containers" are Here!
Wooo!
OK - maybe too much of a celebration... and I do have meatier topics in the article pipeline. However, I just...
2016-12-08 (first published: 2016-12-01)
1,551 reads
What Port Should I Use?–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2016-12-08
679 reads
Linux – How to Change Group and User Ownership of a Directory – using chown & chgrp
In this post, let’s learn how to use chgrp and chown commands to change group and user ownership of a...
2016-12-07
352 reads
SQL in the City is coming next week
Next week is the 2016 version of SQL in the City and you can register now to attend. It’s free...
2016-12-07
498 reads
This Week in Data – Episode 15 (Why People Are Flocking to SQL Server)
Welcome back to another episode of This Week In Data! If you missed our previous episodes, you can watch them...
2016-12-07
839 reads
VMware vSphere 6.5 breaks your SQL Server vNUMA settings
VMware’s latest release of the vSphere virtualization suite, version 6.5, changes how they handle vNUMA presentation to a virtual machine,...
2016-12-07 (first published: 2016-11-29)
3,354 reads
A Python SQL Server App
I got a link recently from Microsoft on building apps easily for SQL Server. At the top of the page,...
2016-12-06
1,383 reads
Checking your Wait Stats via Power BI
Wait stats is my go to thing, however I do get bored just querying it via a table so I...
2016-12-06
803 reads
In Memory OLTP – 1
In-Memory OLTP (A.K.A. Hekaton) is a specialized, memory-optimized relational data management engine and native stored procedure compiler, integrated into SQL...
2016-12-06
637 reads
Blogs
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...
A Las Vegas Break
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
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