The Performance Game
I've posted in the forums fairly often that there's kind of a black art to performance tuning. As with most...
2007-08-14
1,454 reads
Blog Posts
Queueing Theory
There has been tons of work over the last few decades on queueing theory, mainly in regard to operating systems...
2007-08-11
1,676 reads
Engagement
I got a note from someone at Red Gate about disengagement with the newsletter and site. Actually it was my...
2007-08-09
1,410 reads
Fewer Seats Make for Better User Group Meetings?
We had a visitor from another group at our recent www.opass.org meeting and it was interesting that one bit of...
2007-08-09
1,334 reads
Table Partioning Article Posted on SSC
Article is at http://www.sqlservercentral.com/columnists/awarren/3135.asp. I'll have quite a few more on this subject over the next few months. As I...
2007-08-09
1,359 reads
Dell Laptops, D-Link routers and Cisco VPN
It's not directly SQL Server, but it does prevent me from working with SQL Server 🙂
So I'm in Virginia this...
2007-08-08
2,899 reads
User Groups, Geeks, and Puzzles
Last night we had one of bi-monthly meetings of oPASS (Orlando SQL Servers User Group) and we had a pretty...
2007-08-08
1,441 reads
Am I a Good Customer?
Maybe not. This is a great post and cartoon from David Reed (a friend) mentioning me.
We've had some good arguements...
2007-08-07
1,588 reads
Professional Development Plans Article on SSC
This was fun to write. It's a subject I'm passionate about and that too few in our field seem to...
2007-08-07
533 reads
Risky Behavior
An interesting debate from one of my editorials on risk. Some great points raised by everyone, but I still think...
2007-08-07
602 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