Measuring Transactional Replication Latency Without Tracer Tokens
Measuring Transactional Replication Latency Without Tracer Tokens SQL Server 2005 introduced Tracer Tokens (SQL 2005 | SQL 2008), a new methodology for...
2010-03-25
7,124 reads
Recovery Models and Backup Strategies for SQL Server 2008
I had a question via e-mail from one of my new students at University of Denver, University College this morning,...
2010-03-25
3,072 reads
Simple Series : SSIS Conditional Split
Conditional Split is a very powerful component, enabling you to send records in different directions or exclude them from the downstream...
2010-03-25
1,128 reads
SQL Server 2008 Activity Monitor
For those people who like to use the Activity Monitor in the SQL Server Management Studio GUI instead of, or...
2010-03-25
2,873 reads
What Sessions Do You Want for the PASS 2010 Summit?
Survey was announced in the Connector on Wednesday, reposting the link here. We need your thoughts on this!
http://www.zoomerang.com/Survey/WEB22ADZ7NCK9A
2010-03-25
674 reads
A Fan and a Friend
I went to the UK SQL Server User Group in Cambridge on Wednesday. I’m not sure it’s the Cambridge group...
2010-03-25
688 reads
Have a Question? Use the Forums
I try to keep a pretty tight lid on the comments to the blog because there's a lot of SPAM...
2010-03-25
535 reads
Managing the Size of the Security Cache (TokenAndPermUserStore) in SQL 2005
Introduction
In an earlier post I walked through the diagnosis of a problem with TokenAndPermUserStore bloat in SQL 2005.In this post...
2010-03-25
1,098 reads
Goodbye Live Spaces, Hello WordPress
After blogging on Live Spaces for a 517 days, I’ve made the difficult decision to move to my own domain...
2010-03-25
661 reads
Meeting Offsite and a Little Vacation
I’m heading to our “publishing summit” today at one of the Cambridge University buildings. I’m a part of the group...
2010-03-24
785 reads
Blogs
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
Forums
Massive Table Growth Issue – How to Set Up Filegroup Usage Alerts?
Hello We recently encountered an issue where a SQL table unexpectedly grew in size...
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers