One Database, One Server
As background, I've never been a fan of multiple instances. It's a useful thing to have available and I use...
2009-06-09
393 reads
Blog Posts
PASS Connector Editorial for June 3, 2009
I currently write the editorial for the PASS Connector which is published every two weeks as part of my role...
2009-06-09
334 reads
Speaking At Space Coast SQL Users Group On June 11
Just a quick note to mention that I'm speaking at the next Space Coast SQL Users Group on Thursday, June...
2009-06-09
418 reads
SQL Saturday Eval Results
I received my evaluation summary from Karla Remail for this weekend's SQL Saturday event. The results are as follows:
Expectations: 0...
2009-06-09
583 reads
Starting Conversations - Part 6
As I've related previously (Part 1, Part 2, Part 3, Part 4, Part 5) I've been working author and speaker...
2009-06-09
334 reads
Transparent Data Encryption - Encrypting the Log
One of the interesting things about Transparent Data Encryption is that it tries to ensure that your data, whenever it...
2009-06-09
468 reads
Call for Speakers for SQLSaturday #16 in Miramar, FL on August 8, 2009
Scott Klein still needs a few more speakers for the first ever SQLSaturday in Miramar (basically Miami). So far Jeff...
2009-06-08
350 reads
Gathering in the Corner - SQLSaturday #14
I'm done with SQLSaturday #14, actually stuck in Pensacola for an extra night, but that's another story.
It was a great...
2009-06-08
593 reads
Handling Errors in PowerShell
Scripting tasks in PowerShell is a fairly easy way to automate tasks, but you have to know when you get...
2009-06-08
954 reads
It’s Beginning to Look A Lot Like Christmas……
We got something good in the mail last week!
Some quick observations:
The build quality is outstanding. Nothing cheap at all...
2009-06-08
579 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