Introducing SQL Roundup
Following in the foot steps of John Sansom (b|t), I’m going to post a roundup of links from other blogs every Friday. I’ll...
2012-03-02
980 reads
Blog Posts
MDX SSRS Parameter Values
<rant> One of the most frustrating things about working with the Microsoft BI Stack is after you go through all...
2012-03-02
9,325 reads
PepsiCo Women’s Inspiration Award Winner – If I can do it, so can you…
An inspiring story. A hard one, and one that comes from someone with talent.
I like seeing stories like this, and...
2012-03-02
1,013 reads
Re-blog – February 24 – March 1
Welcome to the Friday Re-Blog summary post. The aim of these posts is to bring some old posts that newer readers may...
2012-03-02
469 reads
Running a script on multiple servers
One of my favorite features of SQL Server Management Studio (SSMS) is the ability to run a script on multiple...
2012-03-02
2,626 reads
SQL Server 2012 (“Denali”): Database Recovery Advisor
Database Recovery Advisor is a new feature in SQL Server 2012 that introduces significant user experience enhancements to the ways DBAs...
2012-03-02
1,033 reads
The Daily Status Meeting
For the past six months or so I’ve hosted a daily status meeting for a large project. It started out...
2012-03-02 (first published: 2012-02-26)
2,007 reads
Want to write for Microsoft?
Edit: The group I’m speaking to is the Content Team, not the Books Online (BOL) team!
Edit: Updated with FAQs and...
2012-03-02
719 reads
A Solid Laser Printer
I bought a Brother 2060 about 5 years ago to serve as our primary printer at the ranch. It was...
2012-03-01
963 reads
Checking Your Service Account with T-SQL
Somehow this slipped by me, but there were some new DMVs added in SQL Server 2008 R2 SP1. I suspect...
2012-03-01 (first published: 2012-02-22)
2,804 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