SQL Lunch–SQL Reporting Services
Tomorrow at 11:30 CST Pam Shaw will be talking SQL Reporting Services (SSRS). If you have time, join us for...
2012-03-21
944 reads
Blog Posts
SQL Server 2012 AlwaysOn Availability Groups – Part 1
In the last weeks and months I have prepared tons of SQL Server 2012 content for my
own SQL Server 2012...
2012-03-21
18,794 reads
SQL Server 2012 Special Ops Tour - NYC
Tomorrow, Thursday, March 22, 2012, the official Microsoft SQL Server 2012 Special Ops Tour continues its 12-city trek around the...
2012-03-21
1,734 reads
SQL Server Crossword #4
To mark my 31st Birthday today(gifts are of course most welcome) here’s a SQL Server Crossword for you to enjoy. You...
2012-03-21
978 reads
SQL Server Database Mirroring Tips and Tricks, Part 2
If you ever find yourself having to setup database mirroring between different, untrusted Windows Domains, one of the most common...
2012-03-21
1,493 reads
SQL Tribal Knowledge needs editors!
A while back I invited the unpublished masses to submit abstracts for a new-author-written SQL book – called Tribal SQL – and the...
2012-03-21
655 reads
STOP! Consolidate and Listen
I just wrapped up my 24 Hours of PASS session on consolidation. A big THANK YOU again to everyone in attendance,...
2012-03-21
910 reads
Whitepaper: Demystify Tempdb Performance & Management
Whitepaper: Demystify Tempdb Performance & Management
Demystify Tempdb Performance & Management
There are many misconceptions and myths about tempdb and purported best practices are...
2012-03-21
1,547 reads
Wish you were here
When I was growing up, we used to sit round the t.v. (families only had one in those days) and...
2012-03-21
759 reads
Debugging query timeouts by sampling blocking – part 2
In part 1 I explained how I was hunting for the root cause for some query timeouts that happened every...
2012-03-20 (first published: 2012-03-15)
2,898 reads
Blogs
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
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...
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...
CMS server query & temp tables
I am annoyed. We have a CMS server that has hundreds of servers saved...
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...
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