Becoming a DBA, Part II
This is a follow-up to part I from last week. You've considered what you want to do, you've looked at...
2007-11-05
921 reads
Brian Kelley
- Interests: Chess, Reading, Soccer (Football), Baseball, Animals, Theology
The Impact of Architecture/Design Choices
I try my best to get things right the first time. So often, correcting a mistake or bad choice is...
2007-11-05
688 reads
Online Resource: Safari Tech Books Online
I've used Safari (the O'Reilly version) for a number of years now and it is a resource I often recommend...
2007-11-02
866 reads
Why SQL Server 2005 Doesn't Permit Non-ANSI Style OUTER JOINs
As of SQL Server 2005, any database in 90 compatibility mode (settable by sp_dbcmptlevel) cannot support non-ANSI OUTER JOINs. Sometimes...
2007-11-01
2,193 reads
Tool: KeePass Password Safe password manager/vault
Some time ago I was looking for a password vault and came across some recommendations for KeePass. KeePass is open...
2007-10-31
2,616 reads
SQL Server: Listing all the database roles for a given database user
SQL Server 2005 introduces Common Table Expressions (CTEs), which are great for recursive queries. Previously, in order to do recursion,...
2007-10-30
2,572 reads
Becoming a DBA, Part I
A recent thread on SQLServerCentral.com had an individual what it took to be a successful DBA. Couple that with a...
2007-10-29
1,680 reads
Structuring the Blog Better
For a variety reasons, including personal/family concerns and workload, I've not been able to write as often as I'd like....
2007-10-28
1,468 reads
Alpha Version of SQLPing3 Command Line Available
Noted SQL Server security expert, Chip Andrews, has released an alpha version of a command-line version of SQLPing3. You can...
2007-10-25
2,311 reads
My Book is Out!
How to Cheat at Securing SQL Server 2005
I recently had the opportunity to contribute a couple of chapters to this...
2007-10-04
550 reads
Blogs
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
Forums
A Challenge of Our Knowledge
Comments posted to this topic are about the item A Challenge of Our Knowledge
The memory toll of VARCHAR(MAX) in SQL Server
Comments posted to this topic are about the item The memory toll of VARCHAR(MAX)...
Transaction Log Truncation
Comments posted to this topic are about the item Transaction Log Truncation
Question of the Day
Transaction Log Truncation
In SQL Server 2025, where can I find information about items that prevent or delay the transaction log truncation?
See possible answers