Some useful commands and sp I use for Transaction Replication:
I write several blog about replication and mansion commands and stored procedure related to transaction replication, but I would like...
2009-10-23
1,326 reads
Blog Posts
SQLLunch – Accidental DBA and Performance Data Collector
If you haven’t had a chance to attend the SQL Lunch Live Meeting learning series then sign in Monday at...
2009-10-23
874 reads
SSRS - Setting Default Parameter Values for Analysis Services Datasets
When developing Reporting Services reports that use Analysis Services as a data source you may find that it is difficult...
2009-10-23
7,085 reads
Sydney SQL Server Users Group Draws Big Crowd
On Tuesday, October 13, I spoke at the Sydney SQL Server Users Group, presenting on “How to Get the Most...
2009-10-23
498 reads
Tricks and issues Part 1
Today was browsing the Blog http://blog.sqlauthority.com/ Pinal Dave expert on Sql server and great Blog writer. Got surprise to see...
2009-10-23
636 reads
2009 PASS Conference Side Quests
Barring any unforeseen issues like sudden death, I'll attend this year's 2009 PASS conference in Seattle. I'll arrive Sunday the...
2009-10-22
816 reads
Book Review: The Board Book
I ordered the ' target=_blank>The Board Book from Amazon ($18) to try to get some ideas for how to do a...
2009-10-22
584 reads
Habits and Activities for De-Stressing
I was chatting on FaceBook today with a guy from my church who is learning to be a network engineer. He's...
2009-10-22
927 reads
Logins no longer exists.
Today while checking the logins, just want to clear/clean logins which are no longer exists on NT domain.
To get...
2009-10-22
553 reads
Notes from SQLSaturday #21 – Part 3
I thought I’d finish up the notes by listing things that went well and not so well:
Jack Corbett really helped...
2009-10-22
539 reads
Blogs
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
How to Find Expensive Queries in Amazon Redshift
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
The Notification Trap: How Input Fatigue Is Killing Deep Work in Tech
By gbargsley
If you've been here before, you know this blog is usually about SQL Server,...
Forums
SQL 2019 instance with AG, across 2 Windows 2016 OS servers - OSin-place upgrade
Hi all Can I get some perspective from the community please on performing in-place...
How Long is a Long I/O?
Comments posted to this topic are about the item How Long is a Long...
T-SQL Trigonometric Functions in SQL Server
Comments posted to this topic are about the item T-SQL Trigonometric Functions in SQL...
Question of the Day
How Long is a Long I/O?
In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?
See possible answers