Maintenance in SS2K5
Andrew Kelley from Solid Quality Learning did this one, which was good.
I was worried it would be about maintenance plans,...
2007-06-05
1,563 reads
Blog Posts
Reunion
We're not partners anymore in SQLServerCentral.com, but Andy, Brian,
and myself got together last night for dinner. We haven't seen each
other...
2007-06-05
622 reads
SQL Server 2005 Tools
A good talk on the tools from the guy that's responsible for SSMS,
Configuration Manager, Maintenance plans, Surface Area Configuration
Wizard, and...
2007-06-05
620 reads
SQL Server Always On
Everyone wants 5 9's of uptime, 24x7 support, and instant fixes for
issues with their database server. Never mind that I'd...
2007-06-05
2,187 reads
Clustered Index Seek or Key Lookup
When I teach performance tuning I always remind students to be cautious about service packs because things you "know" may...
2007-06-04
1,760 reads
First Session
I dropped into Brian Knight's "Clustering in 60 Minutes" to say hi. If
you've never seen this, it's pretty cool and...
2007-06-04
561 reads
Tech Ed - Keynote
These will get pretty long as I'm kind of wordy, but these are impressions as things are occurring.
Registration is a...
2007-06-04
743 reads
Working Afternoon
I ended up driving around Orlando this afternoon to get books. We'd
printed the next version of our Two Minute SQL...
2007-06-04
573 reads
Midlands PASS Chapter Meeting for June 6, 2007
Our next meeting will be on Thursday, June 7th, at
6:30 PM. Training Concepts will once again be our gracious...
2007-05-29
1,355 reads
Speaking at PASS 2007
I'll be doing a spotlight session called 'Transactional Replication for Beginners' this year. I've been speaking at the Summit since...
2007-05-29
1,362 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