Upcoming October Events
During October I’ll be presenting at several online and in-person events
LocationDateSessionSQL Saturday #49 Orlando 2010Oct 16th ETL with PowerShellPASS PowerShell...
2010-10-06
850 reads
Blog Posts
VMWare vSphere database maintenance
I recently did a VMWare/SAN assessment for a client. The expressed reason, or the reason relayed to me (not always...
2010-10-06
3,934 reads
Converting Dates to Integers
While working on a project recently, I came across a conversion that was trying to convert a date to an...
2010-10-05
799 reads
How Do I Spot Identity Columns That Are About to Max Out?
Every so often, usually in the middle of the night or on a holiday weekend, an identity column will hit...
2010-10-05
1,263 reads
It’s Implied
This has been on my radar now for a little over a week. I ran across a request in the...
2010-10-05
743 reads
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
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,773 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
359 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
Blogs
The Book of Redgate: Do the Right Things
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
Forums
Let's Talk Community Events!
Comments posted to this topic are about the item Let's Talk Community Events!
that one limitation in replication
Hi as shown below a replication target requires a primary key. if we want...
Local Agents
Comments posted to this topic are about the item Local Agents
Question of the Day
Detecting Deadlocks
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers