Manual v Automation
I’ve got my work cut out for me. This week is SQL in the City 2017. One of the sessions...
2016-12-12
493 reads
Blog Posts
Monday Coffee 2016-12-12
Speaking and presenting
One of my biggest fears is public speaking and judging by this article, I’m not alone.
However it’s something...
2016-12-12
288 reads
OPTIMIZE FOR Hints When Parameter Sniffing is Turned Off
While presenting recently and talking about dealing with bad Parameter Sniffing, I got the question; what happens to OPTIMIZE FOR...
2016-12-12
631 reads
SQL Server DBA Tips that Can Save Your Ass
On November 9th I presented a session in the PASS Database Administration Virtual Chapter. The title of the session was...
2016-12-12
381 reads
SQLBits 2017 In April
I’m getting excited, with the announcement that SQL Bits 2017 is scheduled. The conference goes back to Telford, which I...
2016-12-12
529 reads
The Eleven Days of Festivus
It’s that time of the year again – the Festivus season is upon us! In the next few weeks, families all...
2016-12-12
301 reads
Up Next, SQL PowerShell for SSAS!
I’ve been wanting to demo cool-easy ways to do things in SSAS with PowerShell for a long time but haven’t gotten around to working on it much. Well, it’s...
2016-12-12
82 reads
Up Next, SQL PowerShell for SSAS!
I’ve been wanting to demo cool-easy ways to do things in SSAS with PowerShell for a long time but haven’t gotten around to working on it much. Well, it’s...
2016-12-12
16 reads
Up Next, SQL PowerShell for SSAS!
I’ve been wanting to demo cool-easy ways to do things in SSAS with PowerShell for a long time but haven’t...
2016-12-12
343 reads
Aggregate Functions
Aggregate Functions
MINReturns the smallest value in a given columnMAXReturns the largest value in a given columnSUMReturns the sum of the...
2016-12-11
235 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