Check Those Settings
Recently, I was tasked with “enhancing” a third party application. This third party application (TPA) outputs a bunch of files...
2017-03-30 (first published: 2017-03-16)
2,268 reads
SQL Swimmer
Next Stop, SQL Saturday Richmond
I can’t believe it’s almost time for SQL Saturday #610. I’ll be there presenting What is Power BI? If you...
2017-03-11
330 reads
Triad Developers Conference – My Debut
I did it! I did my first “real world” presentation this morning at the Triad Developers Conference in Winston-Salem. What...
2017-03-10
335 reads
Speaking at Triad Developer’s Conference
I am honored to have been recommended by a colleague and selected as a speaker for the Triad Developer’s Conference...
2017-02-09
364 reads
Pesky Percent File Growth
As DBAs we all know setting your file growth to grow by percent is not optimal. It can cause all...
2017-01-31
731 reads
My First SQL Saturday – As A Speaker!
I am so honored and excited to have been selected to speak at SQL Saturday Richmond on March 18, 2017.
I...
2017-01-31
609 reads
How to Exclude Entire Sections in VS Schema Compare
Right now I am so excited, and a little embarrassed. After using Visual Studio (VS) for database projects for the...
2017-01-23
6,151 reads
So Long, Farewell, I Hate to Say Goodbye
The Sound of Music is one of my all time favorite movies. It reminds me of some great times with...
2016-10-12
510 reads
SQL Saturday Charlotte is Coming!
That’s right, SQL Saturday Charlotte is coming September 17, 2016. Next to the annual PASS Summit, this is my favorite...
2016-09-01
391 reads
SQL Server 2016, Database Mail and .Net 3.5 Framework
There were so many cheers when Microsoft announced that the .Net 3.5 Framework was no longer a pre-requisite for installing...
2016-06-30
3,160 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