Book Review – SQL Server Internals: In-Memory OLTP by Kalen Delaney
The new SQL Server 2014 feature In-Memory OLTP (code-named “Hekaton”) has been attracting a lot of interest since its release,...
2014-12-09
1,780 reads
Blog Posts
Create your own SQL Tools with PowerShell and Windows Forms
Steve:
Check out a new blogger who is sharing secrets of the DBA world. In his first post, James shows us...
2014-12-09 (first published: 2014-12-03)
7,235 reads
Exam Prep 70-463: Intro to Columnstore Indexes
This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing...
2014-12-09 (first published: 2014-12-01)
5,912 reads
Exam Prep 70-463: Introduction to SSDT
This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing...
2014-12-09
3,140 reads
Giving Back – #TSQL2sday
T-SQL Tuesday, which was started by Adam Machanic (blog|twitter) and is now starting its 6th year, is hosted by a...
2014-12-09
793 reads
SQL Saturday #354 – Charleston, SC is almost here!
If you are relatively near to Charleston, SC, there’s a SQL Saturday there this weekend, December 13th!
SQL Saturday #354 – Charleston,...
2014-12-09
462 reads
SQL Sentry Plan Explorer – Don’t Leave Home Without It
If you’ve been around me long enough then you realize that I am a Red Gate fanatic. With that said...
2014-12-09
1,147 reads
SQL Server Configuration Manager giving Error : The remote procedure call failed. 0x800706be
Issue : I am facing error “The remote procedure call failed. [0x800706be]” while trying to view SQL Services from SQL Server...
2014-12-09
1,097 reads
SQL Server Configuration Manager giving Error : The remote procedure call failed. 0x800706be
Issue : I am facing error “The remote procedure call failed. [0x800706be]” while trying to view SQL Services from SQL Server Configuration Manager. Steps I perform to resolve the...
2014-12-09
14 reads
T-SQL Tuesday #61 - Giving Back
Wayne Sheffield (blog|twitter) is hosting this month’s T-SQL Tuesday and his topic is Giving Back to the SQL Community. More specifically, he’s asking how each of us is planning...
2014-12-09
4 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