Use SQL Compare by Red Gate to Find a Missing Index
A couple of weeks ago one of our developers sent me an email saying, “I have a query that returns...
2009-08-07
4,360 reads
Blog Posts
User Group Presentation: Essential Database Management - Top Ten Recommendations
In the August 13th 2009 meeting of the Ohio North SQL Server Users Group (ONSSUG), Paul Randal and his wife...
2009-08-07
328 reads
Book Review: Magnificent Desolation
Magnificent Desolation by Buzz Aldrin ($18 @Amazon) is his second autobiography (haven’t read the first one Return To Earth). I...
2009-08-06
350 reads
Scripting in SSIS
Tim Mitchell presented at SQLSaturday #17 on Scripting in SSIS. I thought it was a really interesting presentation, and I’m...
2009-08-06
2,235 reads
The effects UNION in a SQL query
In a recent blog, I shared some of the natural but sometimes unanticipated consequences of adding DISTINCT to a SELECT...
2009-08-06
593 reads
August 2009 Baton Rouge SQL Server User Group – Near Real-time Data Warehousing 1.0
Fresh off of my presentation of the SQL Profiler at SQL Saturday #17 in Baton Rouge this past Saturday, I...
2009-08-05
412 reads
Call For Speakers – SQL Lunch Live Meeting
The Baton Rouge Area SQL Server User Group hosts Bi-Monthly Live Meetings that are 15-30 minutes long the consist of...
2009-08-05
1,473 reads
Review of Bluetooth Speakerphone
I was visiting Compusa recently looking for a couple small things and noticed the Samsung Bluetooth Speakerphone for $24.99 (can...
2009-08-05
396 reads
SQL Saturday #17 – Baton Rouge Wrapup
My presentation went well at the Baton Rouge SQL Saturday with about 30 people attending. It was the early morning...
2009-08-05
363 reads
Agile Practices Meet Database Development: Intro
I think the database developer role is on the rise and that it's better suited for agile practices - but guidance...
2009-08-04
3,496 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