New SQL Server Blog Author Challenge
My good friend Ed Leighton-Dick has created a great new challenge, adapted from a challenge issued by Seth Godin back...
2015-03-23
461 reads
Blog Posts
Review of Minion Reindex
Back in October 2014 Midnight SQL released v1.0 of Minion Reindex, a free, open source index maintenance solution. I’m all...
2015-03-23 (first published: 2015-03-16)
7,893 reads
Selected as a PernixPro
Today I’d like to announce that I have been selected as a PernixPro for 2015! It’s a program similar to...
2015-03-23
409 reads
Speaking at SQL Saturday #389 – Huntington Beach
I’ll be traveling to CA next month for SQL Saturday #389 – Huntington Beach as well as a Red Gate DLM...
2015-03-23
912 reads
Speaking at SQLSaturday 376 Budapest
On April 18 2015 I will be speaking at SQLSaturday #376 in Budapest!
I will be speaking about one of my...
2015-03-23
544 reads
Announcing the SQL New Blogger Challenge!
TL;DR – In April, I’m challenging myself to write (and publish!) here regularly, and I’m extending an open challenge to other new...
2015-03-22
331 reads
Announcing: SQL Saturday Baton Rouge 2015
SQL Saturday Baton Rouge 2015 is coming up on August 2 at LSU, register today!
Email or instant message your friends, post...
2015-03-22
755 reads
Career Ratings
I wrote the other day about measuring your career, and I gave some general advice, but I wanted to give...
2015-03-20
1,464 reads
Lessons Learned from a Poor-performing VIEW
It is a “common knowledge” among SQL practitioners that VIEWs don’t perform well. Recently during an application’s development I put...
2015-03-20 (first published: 2015-03-12)
8,921 reads
Monitoring for Timeouts
The question came up at SQL Rally, “Can you use Extended Events to monitor for query timeouts?”
My immediate response was...
2015-03-20 (first published: 2015-03-12)
7,642 reads
Blogs
T-SQL Tuesday #197 Invitation – An impactful session or two from a conference
By DataOnWheels
I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...
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...
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