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
Blog Posts
Power BI Custom Visuals Class (Module 27 – Synoptic Panel)
In this module you will learn how to use the Synoptic Panel Power BI Custom Visual. The Synoptic Panel is...
2016-12-06 (first published: 2016-11-29)
2,103 reads
Power BI Custom Visuals Class (Module 28 – Sankey)
In this module you will learn how to use the Sankey Power BI Custom Visual. The Sankey is a type...
2016-12-06
968 reads
sp_WhatsupQueryStore version 1.1 released
Today I released a new version of the sp_WhatsupQueryStore stored procedure. sp_WhatsupQueryStore returns many configuration and performance metrics that are...
2016-12-06
466 reads
Total Cost of Ownership (TCO) Calculator
For a long time clients would ask me how to determine the cost savings by migrating their applications and databases...
2016-12-06
1,229 reads
TSQL Tuesday #85 Invite – Backup and Recovery
Come on down! You’re the next contestant on T-SQL Tuesday! I’m your host Kenneth Fisher and this month I’d thought...
2016-12-06
550 reads
December: A two-line play.
“Wow! A family, a marathon, and two businesses! So how do you keep up with it all?” asked Twitter. “Work-life...
2016-12-05
595 reads
Dynamically Set Powershell Variables from json
I created this small snippet to allow a list of values from a json file be turned into variables to...
2016-12-05
302 reads
Easy to read CHECKDB
If you ask a senior DBA what are the top 5 most important commands in T-SQL you’ll probably see DBCC...
2016-12-05 (first published: 2016-11-28)
2,478 reads
Monday Coffee 2016-12-05
You are the DBA your company makes you. Aren’t you?
SQL Server has such a wide range of features that no...
2016-12-05
303 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