24 Hours of PASS
On the 19th/20th May (last month) the Professional Association of SQL Server (PASS) held its second 24 hours of PASS...
2010-06-23
724 reads
Blog Posts
Building a PASS Voting Solution – Part 5
Today we move over to the web side of things. I put this together with VS 2010, and it’s a...
2010-06-23
578 reads
Change Data Capture vs Change Tracking
Make sure to check out the comments on this one!
A short conversation on Twitter Monday night reminded me of this...
2010-06-23
1,088 reads
Error 25602 When Creating an Extended Events Session: a Security Risk
Error 25602 When Creating an Extended Events Session: a Security Risk
I came across an interesting issue recently when helping someone...
2010-06-23
3,577 reads
How To Stay Current with SQL Server Cumulative Updates
Since the release of SQL Server 2005, Microsoft has been using what they call an Incremental Servicing Model for SQL...
2010-06-23
2,189 reads
In The Spotlight!
I received an unexpected but certainly not unwelcome email last night letting me know that I've been selected to present...
2010-06-23
413 reads
Learning Powershell
I’ve been attending a Powershell fundamentals class with Don Jones (blog|twitter). If you read my blog you might be aware...
2010-06-23
1,707 reads
Lots of Speaking Engagements Coming Up
SQL Saturday - Columbus, OH, June 26, 2010 I'll be presenting two sessions this Saturday (June 26, 2010) in Columbus, OH...
2010-06-23
628 reads
Microsoft Releases SQL Server 2008 R2 RTM Cumulative Update 2
Microsoft has released SQL Server 2008 R2 RTM Cumulative Update 2 (CU2) today. It became available for download today, and...
2010-06-23
2,893 reads
Parameterization- ?? ?? ?????? ???? ??? ????? ?????
?? ????, ??????? ?? ??? ???? ????? ????? ????? ?? ? Database-?? ???????. ????? ??????? ?? ?????? ????? ????? ????????????...
2010-06-23
450 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
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
Detecting Deadlocks
Comments posted to this topic are about the item Detecting Deadlocks
Question of the Day
Detecting Deadlocks
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers