PASS Elections 2013
Yesterday the slate of candidates for the PASS Board of Directors was announced. Seven candidates for three open positions this...
2013-09-24
845 reads
SQLAndy
Finding The Active Sharepoint Databases
This was a task from last week. There was a server where we wanted to make some adjustments to security...
2013-09-23
953 reads
Notes from SQLSaturday #232 in Orlando
Our seventh annual SQLSaturday here in Orlando went well. To the casual observer it might appear to happen without effort,...
2013-09-16
662 reads
My 2013 PASS Suggestion Tsunami List
Back in August I posted about an approach that Aaron Nelson and I thought of to try to get more...
2013-09-09
795 reads
Log Backup Failing–A Simple Mistake
Last week I was checking on some stuff and noticed that a couple databases were in simple mode – unusual, but...
2013-09-05
701 reads
Skills I Used Last Week
Ever thought about what your average week looks like? What are the real core skills your environment uses every day...
2013-09-09 (first published: 2013-09-03)
2,424 reads
Building a Better Litter Box
First, I know as I write this that my friend Kevin will be emailing me later today that I’ve jumped...
2013-08-30
1,428 reads
Notes From The August 2012 OPASS Meeting
Luis Figueroa did a nice job presenting on Master Data Management. It’s nice to see the tools evolving, though I’ll...
2013-08-23
616 reads
Need Recommendations on Being a Better Listener
This past weekend I’ve been reading The Zen of Listening by Rebecca Shafir, part of my ongoing efforts to be...
2013-08-19
684 reads
Interview Candidates for Skills, Aptitude, Maybe Both
Over the years I’ve been primary a skills interviewer. In theory I know what skills are needed and in theory...
2013-08-20 (first published: 2013-08-15)
2,444 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