SQL Server - DBA Team FAQ
Developers constantly ask about placing the latest code\feature\process\third party applications onto Production Database Servers.
I’m building an FAQ to supply Developers...
2012-02-24
1,121 reads
Blog Posts
SQL Server 2012 (“Denali”): Spatial Features
SQL Server 2012 introduces several significant enhancements to spatial types, such as support for new subtypes of circular arcs, new...
2012-02-24
2,022 reads
A Plea: Have your guidance documentation reviewed
Today one of my auditors sent me her matrix for auditing Microsoft SQL Server. I had seen part of it...
2012-02-23
1,229 reads
A Script A Day - Day 17 - Possible Poor Indexes
Today’s script is one I’ve taken from a job I use to collect possible poor indexes. I’ve tweeked it slightly...
2012-02-23
545 reads
A Script A Day - Day 18 - Viewing System Configuration
Today’s script is something I’ve learned today, it’s cool learning new stuff! When viewing server configurations in the past I’ve...
2012-02-23
557 reads
Linchpin People LLC Announces Two New Partners - Press Release
February 23, 2012 – Today, LINCHPIN PEOPLE, LLC, offering technical advisory, consulting and training services in the Microsoft SQL Server Space,...
2012-02-23
2,473 reads
PlayBook OS 2 Update Awesome, Why Pay Three Times the Price for an IPad?
I have become dependent on my tablet, here is why, thanks to a great summary from the Globe and Mail.
2012-02-23
1,120 reads
There is another.....LinchPin People names its new partners!
I wanted to follow-up on the partner announcement of the great new concept and venture, started by my friends and sql...
2012-02-23
1,115 reads
A Script A Day - Day 15 - Untrusted Check Constraints
Today’s script comes about because of a recent discussion about check constraints. The discussion was about the use of WITH...
2012-02-22
1,025 reads
A Script A Day - Day 16 - Database Restore
Today’s script is one I have used more times that I care to remember. As a DBA database backups and...
2012-02-22
679 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