MongoDB
I found a comparison of MongoDB and SQL Server recently, from a C# MVP and a person that works with...
2010-10-05
1,616 reads
Blog Posts
MSDB Job History Duration Conversion
Have you ever queried the msdb tables to get duration details about a particular job? I’ve had to do this...
2010-10-05
2,772 reads
Reminder – Deadline for SQLRally Pre-Con Abstracts is October 15th
See my previous post on the topic,or just go directly to the application.The application has full details, but MVP’s, Summit...
2010-10-05
357 reads
Return of Index Analysis Part 1
Let’s Anaylze An Index!Time for part two of my continued Index Analysis query. The previous posts in this series are:
Analyze...
2010-10-05
951 reads
SQL Lunch: Change of Schedule
There has been a slight change to this weeks SQL Lunch meeting. Our scheduled speaker cannot present this week, therefore...
2010-10-05
411 reads
SQL Saturday 49 Orlando - Delivery Mechanisms using SQL Server Reporting Services (mini)
It's official! I am presenting a mini session for SQL Saturday in Orlando. My topic and some details are below:
Delivery...
2010-10-05
455 reads
SQL Saturday New England: The Date
Mark your calendars. Make your travel arrangements. Plan on being in the Boston area on April 16th, 2011. Three of...
2010-10-05
543 reads
SSC Editorial – Great Service
I wrote the editorial about great service after noticing a couple small but interesting customer service experiences during two trips....
2010-10-05
430 reads
SSWUG Fall 2010 Virtual Conference This Month
Conference Time! The SSWUG Fall 2010 Virtual Conference is coming up. On October 20-22, you can attend a conference from...
2010-10-05
697 reads
Tip: OVER and PARTITION BY
Here’s a quick summary of OVER and PARTITION BY (new in SQL 2005), for the uninitiated or forgetful…
OVER
OVER allows you...
2010-10-05
2,639 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