Swing and a Miss
I missed my first newsletter today. It wasn’t until I went to schedule tomorrow’s that I realized I hadn’t sent...
2010-04-06
367 reads
Blog Posts
Uninstall 64 bit and reinstall 32 bit SQL Server
For reason's beyond the scope of this post I needed to uninstall a 64 bit version of SQL server standard...
2010-04-06
2,460 reads
What I Do to Prep a Technical Presentation
This was a question asked on Twitter the other day, "How do folks prepare for a presentation?" Here are some...
2010-04-06
801 reads
Writing With More Than One Voice
I’ve been blogging for a couple of years now and have slowly settled into the style and pattern of blogging...
2010-04-06
302 reads
A DMV a Day – Day 5
The DMV for Day 5 is sys.dm_db_mirroring_auto_page_repair, which is described by BOL as:
Returns a row for every automatic page-repair attempt...
2010-04-05
1,023 reads
Express Yourself Clearly
Recently my son had a short paper to write for school. He’s a sixth grader, and this year is a...
2010-04-05
560 reads
Get Users By Connection
Introduction
I was recently working a production issue that required me to log in via the Dedicated Administrator Connection (DAC). When...
2010-04-05
342 reads
HTC Pro Trade-In
I saw a note that T-Mobile is accepting trade-ins of an iPhone for credit towards a new HTC HD2. That’s...
2010-04-05
664 reads
Microsoft Drops Support For Itanium after SQL Server 2008 R2
Microsoft’s Dan Reger has announced that Microsoft will not be supporting the Itanium architecture after Windows Server 2008 R2, SQL...
2010-04-05
2,336 reads
Nested views causing query performance woes....
Just ran into an interesting issue AGAIN. It seems that when you nest views in a query you are opening...
2010-04-05
8,688 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