Help Design a New SQL Server Monitoring Tool
In an experiment in SQL Server community involvement, the members of Red Gate Software’s software development usability team have created...
2009-09-03
405 reads
Blog Posts
How Log reader works- replication
Just saw the the answer by michael Hotek for how log reader works on replication: looks very great:http://social.msdn.microsoft.com/Forums/en-US/sqlreplication/thread/d2d2e1c6-01ee-439b-93e8-e31c77c0cd28/Thanks Michael Hotek...
2009-09-03
823 reads
Josef Richberg Voted Exceptional DBA of the Year
For the second year in a row, SQLServerCentral.Com and Red Gate Software have sponsored the Exceptional DBA of the Year...
2009-09-03
704 reads
Replication
Hi,Just want to share info about replication script which i generally use. this is good for sql server 2000 Transaction...
2009-09-03
753 reads
SQL Bits Conference to Run Three Days
The next SQL Bits conference, the largest SQL Server conference in Europe, will be held at the Celtic Manor Resort...
2009-09-03
425 reads
Survival: How a Culture of Preparedness Can You and Your Family From Disasters
Picked up Survival: How a Culture of Preparedness from the local library on a whim without looking at anything except...
2009-09-03
591 reads
Thoughts on the 24 hours of PASS
From all indications, the first 24 hours of PASS was a resounding success. Hundreds of attendees for each session, minimal...
2009-09-03
363 reads
Use the Best Tool for the Task - Part 2
Yesterday I posted about how Transact-SQL was better suited than SMO for gathering details about database files for a database...
2009-09-03
392 reads
Warming up Analysis Services with Preallocate
With Windows Server 2003 many people found that Analysis Services (SSAS) was slow to get going sometimes. So a preallocate...
2009-09-03
1,747 reads
24 Hours of PASS was an Adventure
On July 21, just a few short weeks ago, I got an e-mail from Rick Heiges, who is on the...
2009-09-02
656 reads
Blogs
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Forums
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers