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
1,982 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,376 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
826 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,206 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,533 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,544 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,715 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
634 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,074 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,686 reads
Blogs
When the Internet Stumbles: Lessons from Cloudflare & Azure Front Door Outages
By John
Recently, the world was reminded of just how fragile the internet can be. Two...
Prepping for Certification, Part 4 of 4
By Brian Kelley
In Parts 1-3, I covered how I prepare for a certification exam. In this...
Flyway Tips: Automation Assistance in Flyway Desktop
By Steve Jones
I was chatting with the product managers at Flyway and one asked me whether...
Forums
what are the downsides of TDE not running vs running?
hi for the 2 years i've been here I believe we've had "encryption" turned...
Help! MEMORY_ALLOCATION_EXT wait stalls
Hi I have an overnight process that moves allot of claims records Been working...
Unlocking Data Transformation: My journey with dbt (Data Build Tool) on SQL Server
Comments posted to this topic are about the item Unlocking Data Transformation: My journey...
Question of the Day
Putting the Player with the Number
In SQL Server 2025, what does this return?
DECLARE @player varchar(20) = 'Bo Nix', @num VARCHAR = '10' SELECT @player || @numSee possible answers