Taking Care of Employees - Storms
As I write this a tropical storm is passing over Orlando and has turned out to be milder than expected...
2008-08-21
1,401 reads
Blog Posts
[Off Topic] The Big Apple
I got my first opportunity to visit New York City last week. I was actually sitting in on a training...
2008-08-20
1,552 reads
SQLSaturday #8 in Orlando - Update (Aug 21)
Registration has been open for only a few weeks and we've got 110 registered so far, a nice start! We...
2008-08-20
1,455 reads
Troubleshooting High Connections & What's The Application Name?
I was visiting with a client recently when they asked me to come take a look at an incident in...
2008-08-20
1,368 reads
Notes on My Visit to the St Louis SQL Group
Actually it was subset of the group, but Kathi & Julie from the St Louis SQL Server User Group did a...
2008-08-19
1,413 reads
Speaker workshop
Andy Warren made a trip to St. Louis this past weekend to put on a speaker workshop for our user...
2008-08-19
1,321 reads
What every DBA that manages a large number of SQL Servers should know about SQL 2008!!
Error when importing RegServer list from SQL 2005 to SQL 2008
I discovered the already known bug in SQL 2008 that...
2008-08-19
3,086 reads
Building a Security Philosophy Posted on SQLServerCentral.com
This was actually posted about a week ago, fell behind a little during travelling. Building a Security Philosophy was written...
2008-08-18
1,497 reads
How do I automatically respond to mirrored database failovers?
Automatic Failover - an incomplete solution
Automatic failover with Database Mirroring is great, but what about all of the other things that...
2008-08-18
2,086 reads
IndyTechFest Update - Aug 18, 2008
Just had a note from John Magnabosco, the schedule for the event on Oct 4, 2008 has been published. I'll...
2008-08-18
631 reads
Blogs
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...
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
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