Replication Latency
I've used Replication a lot over the years and contrary to the opinions of most DBA’s I know, I think it...
2013-01-25
2,030 reads
SQL Server 365
SQL Server 365 - Fantastic First Year In Numbers
So, tomorrow marks one year since I started blogging here on SQL Server 365 and what a year it has...
2012-12-31
1,380 reads
Active Directory Group Membership and Powershell
I’ve done my fair share of work with Active Directory over the years and LDAP has helped immensely, it did...
2012-12-19
832 reads
Tables without a Primary Key
As well as creating the script for yesterday’s post on finding Tables without a Clustered Index I tweaked the script...
2012-12-06 (first published: 2012-11-30)
5,211 reads
Tables without a Clustered Index
Yesterday while adding some new logic to an existing process I noticed an unacceptable level of performance degradation with the...
2012-11-29
1,535 reads
Unused Indexes
A sound indexing strategy is paramount to performance in an OLTP system. Not having the correct indexes in place can...
2012-11-27
2,546 reads
Database Mirroring Performance Counters
This week’s SQL Skills insider email contains a simple but often too true scenario regarding database mirroring. If you haven’t...
2012-11-21 (first published: 2012-11-14)
2,721 reads
Database Mirroring Error
I have been setting up multi instance database mirroring for the last couple of days along with some other DR...
2012-10-26
637 reads
Create Database Script
I always try to enforce standards across all the SQL Servers I manage, it makes tons of administrative tasks much...
2012-09-21
1,120 reads
tablediff Utility
I recently stumbled across a little gem of a utility called tablediff. I have been working a lot with replication...
2012-09-20
6,690 reads
Blogs
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...
Building Power BI Reports: Desktop vs Fabric
By James Serra
Why this comparison feels confusing If you’re a Power BI report author who’s just...
Forums
Multi-State Payroll Tax Issues 2026
Prepare for 2026 with this essential multi-state payroll tax issues 2026 webinar from Professionals...
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...
Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
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