Year archive

Posts from 2018

Blog posts

December 28, 2018 Using PowerShell to tidy up CSV files
December 18, 2018 Working from home: Home office tour
November 21, 2018 Following up on the LGBTQ Meetup at PASS Summit
October 13, 2018 I'm in a book! Data Professionals at Work
October 8, 2018 LGBTQ Meetup at PASS Summit 2018
September 21, 2018 Who are the extra special people in your life?
September 20, 2018 Webinar: Azure SQL DB Managed Instance--A New Path to the Cloud
August 20, 2018 Webinar: Push Your App to Enterprise Scale with Advanced SQL Server Features
July 23, 2018 Performance Myths: The query result cache
July 19, 2018 SQLSaturday Louisville & Columbus: Let's Chat
July 17, 2018 Removing [square brackets] from generated SSMS scripts
July 9, 2018 TSQL Tuesday #104: dbo.Check_FileSize
July 9, 2018 Hanging up my DBA cleats
July 9, 2018 How to get your dream job - Webinar recording
June 14, 2018 Generating artificial CPU load 🔥
June 13, 2018 Is that share using SMBv1?
March 20, 2018 Deadlock when creating a database - A Query Store bug
February 23, 2018 Configuring Replication with Availability Groups
February 15, 2018 Using PowerShell to navigate SQL Server as a drive
February 13, 2018 TSQL Tuesday #99: Tabs vs Spaces
February 13, 2018 TSQL Tuesday #99: SQL Tourism
February 8, 2018 Updated shortcuts cheat sheet -- Now with Azure Data Studio
January 17, 2018 Parsing file names from paths using T-SQL
January 2, 2018 Finding active transactions

Stack Exchange answers

November 4, 2018 Stack Exchange answer: Installation of SQL Server Express LocalDB 2017
November 2, 2018 Stack Exchange answer: how azure sql geo replication works internally?
October 29, 2018 Stack Exchange answer: SQL Visual Studio Find and Replace in Publish Profile
October 23, 2018 Stack Exchange answer: How can I permanently remove replication by script if I only have access to the subscriber?
October 12, 2018 Stack Exchange answer: Can't overwrite an existing Azure SQL Managed Instance database during restore
October 5, 2018 Stack Exchange answer: Under what conditions could restore of a huge database get delayed, in SQL server 2016, hosted on VM?
September 27, 2018 Stack Exchange answer: How Large Table before Using Clustered Columnstore Index
September 22, 2018 Stack Exchange answer: How do you SUM a column without having its name?