SQL Server 2008 Surface Area Configuration
Ever wondered what happened to the SQL 2005 Surface Area Configuration Utility in SQL SERVER 2008.
Well you can accomplish pretty...
2010-09-14
876 reads
Blog Posts
SQL Server Security Checklist
In this post, I continue my checklist series that will eventually become a new book. The focus of this checklist...
2010-09-14
1,659 reads
Task Manager - Don't Believe the System Idle Process Percentage
This morning my laptop went to a crawl. I looked, and sure enough, there was an AntiVirus scan running. Argh!...
2010-09-14
3,561 reads
The SQLSaturday Squirrel
A bit of mid week humor. Recently I met up with Jack Corbett to review our room options for SQLSaturday...
2010-09-14
536 reads
T-SQL Tuesday #10 - Indexes
It’s time for T-SQL Tuesday again, the brainchild of Adam Machanic (Blog|Twitter), and this month’s topic is Indexes. A thanks...
2010-09-14
1,638 reads
24 (28) Hours of PASS on Sep 15, 2010
It’s back with a slightly different format this time, 28 hours of seminars delivered over two days, and it’s all...
2010-09-13
570 reads
Database automation and appliances
10 years ago IT professionals considered database technology “mature” and analysts were preparing to slide it into a commodity status… But on the Exabyte era, we depend on databases...
2010-09-13
13 reads
Database automation and appliances
10 years ago IT professionals considered database technology “mature” and analysts were preparing to...
2010-09-13
13 reads
Getting Drive Info, Part 4, the SSIS Script Component
In this installment of the Getting Drive Info series (Part 1, Part 2, Part 3), SSIS will be used to collect and save the drive information. SSIS provides multiple...
2010-09-13
10 reads
Getting Drive Info, Part 4, the SSIS Script Component
In this installment of the Getting Drive Info series (Part 1, Part 2, Part 3), SSIS will be used to...
2010-09-13
1,340 reads
Blogs
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
Monday Monitor Tips: A New Analysis Page
By Steve Jones
We have multiple teams (8) working on Redgate Monitor. Some work on the Standard...
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...
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