Active August –> Week 3 Recap
Well, I had a pretty good week this week. I made an effort and met all my goals:
Eat smaller portions...
2009-08-23
357 reads
Blog Posts
Beware the REPLACE function when doing heavy string parsing
I found something interesting the other day. I was attempting to optimize a very heavy string parsing routine using T-SQL...
2009-08-23
8,671 reads
PASS Update #13
It’s been a busy few weeks since update #12. We announced guidelines for submitting content to sqlpass.org, an effort that...
2009-08-23
738 reads
SOX in the City - Preparations for Audit
As I was going through some of my documentation at past clients, I found my summary of the general SOX...
2009-08-23
2,461 reads
The Netbook: 40 Days In
I wrote last month about purchasing a new Toshiba netbook to supplement my mobile computing arsenal. Forty days later, I’m...
2009-08-22
611 reads
Welcome Home !!
I realize I have been relatively quiet for a while, but summer is actually a fairly busy time for us...
2009-08-22
1,215 reads
A True Sense of Community
We have a thread in our forums that many of the participants refer to as "The THREAD." It's a long...
2009-08-21
723 reads
Cumulative Update 5 For SQL Server 2005 SP3
Microsoft has released the latest Cumulative Update for SQL Server 2005 SP3, which is Build 4230. They also released a...
2009-08-21
474 reads
Denver SSUG – AUG 2009
I attended the Denver SQL Server User Group meeting, wanting to get a chance to catch up with some friends...
2009-08-21
1,111 reads
Ideas are a work of art
When you think about it, most of us in the IT field are paid to solve problems. Sure there are...
2009-08-21
382 reads
Blogs
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
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...
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