Adding value to our organizations
Sean McCown writes in the latest Database Underground about how DBAs should try and make things better for users of...
2007-01-09
1,542 reads
Blog Posts
Most humorous line I've read in a while
This is from Michael Kaplan's blog over at MDSN. He was writing about the power outage that affected the Northwest...
2007-01-07
1,362 reads
Shared Items on Google Reader
I read through a lot of blogs each day in a variety of technology categories. I've always fashioned myself as...
2007-01-06
1,357 reads
Midlands PASS January 2007 Meeting Minutes
January 4,
2007 Meeting Minutes: Members in
Attendance: 15Next Meeting
Date: February 1, 2007 Job
Board: I had a consulting
firm contact me...
2007-01-05
1,696 reads
Midlands PASS Chapter Meeting for January
Our next meeting will be
on Thursday, January 4, 2007, at 6:30 PM. It'll be at the Training Concepts
facility...
2006-12-29
1,502 reads
Setting Goals for the New Year and Beyond
I've never been a big fan of "New Year's Resolutions" for the same reason most other folks are against them:...
2006-12-29
1,596 reads
Phone books and Indexes
On Wednesday I gave a presentation to the St. Louis Visual Basic.Net user group. I really enjoy speaking to this...
2006-12-22
1,393 reads
SET QUOTED_IDENTIFIER
We recently received a script for a modified stored proc from a vendor. My colleague ran the script on the...
2006-12-15
2,566 reads
The Moto Q and Being Proactive
I am a big fan of automating whatever I can and being proactive. The more proactive you can be, the...
2006-12-14
1,508 reads
How to handle an invalid default database
My general recommendation for SQL Server service accounts and accounts that have sysadmin fixed server role membership is to default...
2006-12-11
1,899 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