SQL Undercover

So this month’s T-SQL Tuesday subject is a shout out and high-five to those people who have inspired or made a...

2017-11-14

302 reads

UNDERCOVER TOOLBOX: Using Python To Copy A SQL Login From One Server To Another

by davidfowler-42596

SQL Undercover

Recently I’ve been thinking about Python and whether it can be useful to the DBA as well as the data...

2017-10-30

386 reads

UNDERCOVER TOOLBOX: Find Untrusted Foreign Keys and Orphaned Key data

by davidfowler-42596

SQL Undercover

SQL Server tracks untrusted Foreign keys in sys.Foreign keys with a column called is_not_trusted, there may be a number of...

2017-10-24

185 reads

Connecting to a Remote Instance of SQL Server Using Python

by davidfowler-42596

SQL Undercover

SQL Server’s integration of Python has been heavily marketed towards the machine learning and BI guys, but does it offer...

2017-10-18

945 reads

How Far Has My Update Got? Finding Out How Many Rows Your Long Running Insert, Update or Delete Has Actually Modified So Far

by davidfowler-42596

SQL Undercover

I’m pretty sure that we’ve all found ourselves in the situation where we’ve run an INSERT, UPDATE or DELETE script...

2017-10-05

167 reads

Failed to perform AlwaysOn Manual Failover using the wizard – Availability-group DDL Operations are permitted only when you are using the master database .

by davidfowler-42596

SQL Undercover

Routine maintenance rolls around and it’s time to failover your AG’s to new Primary’s to allow for patching and restarts…...

2017-10-04

304 reads

SQL Mirroring, Preserving the Log Chain During Database Migrations

by davidfowler-42596

SQL Undercover

This is a reblog of a post that I originally wrote back in January. After using this technique again last...

2017-10-03

126 reads

Concatenation Truncation – Are your strings being truncated?

by davidfowler-42596

SQL Undercover

It wasn’t until recently that i paid attention to truncation during concatenation, but that’s because whenever I used concatenation before...

2017-09-27

1,199 reads

Copying Data From One Table To Another – To Disable Indexes or Not To Disable Indexes, That’s the Question.

by davidfowler-42596

SQL Undercover

As the famous Bard once said, “To disable indexes or not to disable indexes, that is the question?”. Well maybe...

2017-09-25

150 reads

UNDERCOVER TOOLBOX: Sp_ChangeJobOwnerShip – Changing Ownership in bulk.

by davidfowler-42596

SQL Undercover

How many times have you seen SQL Agent jobs with random ownership? It can be very frustrating when you are...

2017-09-25

162 reads

SQL Undercover

T-SQL Tuesday – Folks Who Have Made a Difference #TSQL2sday

UNDERCOVER TOOLBOX: Using Python To Copy A SQL Login From One Server To Another

UNDERCOVER TOOLBOX: Find Untrusted Foreign Keys and Orphaned Key data

Connecting to a Remote Instance of SQL Server Using Python

How Far Has My Update Got? Finding Out How Many Rows Your Long Running Insert, Update or Delete Has Actually Modified So Far

Failed to perform AlwaysOn Manual Failover using the wizard – Availability-group DDL Operations are permitted only when you are using the master database .

SQL Mirroring, Preserving the Log Chain During Database Migrations

Concatenation Truncation – Are your strings being truncated?

Copying Data From One Table To Another – To Disable Indexes or Not To Disable Indexes, That’s the Question.

UNDERCOVER TOOLBOX: Sp_ChangeJobOwnerShip – Changing Ownership in bulk.

Blogs

T-SQL Tuesday #180: Good enough is perfect Roundup

Using SQL Compare with Read-only Access

Off to Live 360

Forums

Compare rows within the same table

Microsoft Recommendations for Update Stats?

how can i tell if our db2 driver is ms or ibm or other?

Question of the Day

A Strange Result