Building a Pipeline
While I try to write most days, I don’t always podcast, and I only schedule things a day or two...
2009-09-01
383 reads
Blog Posts
Indexing HierarchyID
The new HierarchyID datatype in SQL Server 2008 has captured my interest lately. I’ve been working on a presentation that...
2009-09-01
3,738 reads
Keeping a Low Profile
I’ve been mostly offline for the last ten days or so, cutting back on blogging and forum participation and mostly...
2009-09-01
557 reads
- Easiest Rebuild Ever - Windows 7
I'm somewhat conservative with my machines. These days it's a tool for me, and I'm not looking for the coolest...
2009-08-31
1,669 reads
Active August – Final Recap
Well, I had a pretty good week this week. I made an effort and met all my goals:
Eat smaller portions...
2009-08-31
1,324 reads
Backing up to NUL vs Backup with Truncate only
Or “It’s 10pm, do you know where your log records are?”
Something that I’ve started to see recently is the idea...
2009-08-31
2,237 reads
Decompressing on Compression in SQL Server 2008....
Compression is one of the major features introduced in SQL Server 2008, and one that can significantly reduce disk storage. ...
2009-08-31
9,518 reads
Notes On the Jacksonville Code Camp
I drove up to Jacksonville Friday afternoon for the 2009 Jacksonville Code Camp led by my friend Bayer White. I...
2009-08-31
1,641 reads
Project Gemini
Dan English put up a blog post on his experiences with installing Gemini. His post is loaded with screen shots...
2009-08-31
1,365 reads
Scripting Server Side Traces
If you’ve never used SQL Server Profiler, you truly don’t know what your missing. And that statement has an intentional...
2009-08-31
1,648 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