Year archive

Posts from 2019

Blog posts

December 24, 2019 Blocking with OBJECT_NAME()
December 19, 2019 What the heck is the dbcreator role?
December 18, 2019 Testing as another user...without their password
December 17, 2019 I hate sp_estimate_data_compression_savings
December 11, 2019 Changing a column from int to bigint, without downtime
October 28, 2019 How to create date buckets in T-SQL
October 24, 2019 How does a database RESTORE affect plan cache?
October 21, 2019 What the heck is Accelerated Database Recovery?
October 15, 2019 What the heck is the SQL Server Version Store?
October 12, 2019 Recovery of database is 0% complete (approximately 1000000 seconds remain)
October 9, 2019 Updates to the Data Blogger Resource Kit
September 23, 2019 Supporting the LGBTQ #SQLFamily
September 3, 2019 When to put a non-clustered index on your clustering key
August 28, 2019 Why does ALTER let me DROP?
May 27, 2019 Data Blogger Resource Kit
May 22, 2019 Year 5: May 2018 - May 2019
May 21, 2019 Year 4: May 2017 - May 2018
May 20, 2019 Year 3: May 2016 - May 2017
May 17, 2019 Year 2: May 2015 - May 2016
May 16, 2019 Year 1: May 2014 - May 2015
May 15, 2019 Blogging on a whim
May 14, 2019 #LGBT channel on SQL Slack!
April 15, 2019 What the heck is downtime, anyway?
April 8, 2019 Configuring the distribution database in an Availability Group
April 4, 2019 Code to purge data based on creation date
April 3, 2019 Purging data with batched deletes
April 2, 2019 The thrill of purging old data
January 21, 2019 SQL: A love story
January 15, 2019 Failure is always an option

Stack Exchange answers

December 21, 2019 Stack Exchange answer: Do triggers start to degrade in performance (or sometimes fail) on highly transactional tables?
December 13, 2019 Stack Exchange answer: INSERT EXEC statement cannot be nested
November 23, 2019 Stack Exchange answer: How to see restore history of a deleted database?
November 8, 2019 Stack Exchange answer: Can't use GitKraken on private repositories
November 1, 2019 Stack Exchange answer: Cannot connect to my SQL Management studio after moving a tempDB
November 1, 2019 Stack Exchange answer: Is it possible to re-use a query plan from the plan cache from one database in another database?
October 31, 2019 Stack Exchange answer: SQL Server Page File location - where to put it?
October 30, 2019 Stack Exchange answer: Why can't I restore encrypted backup through front end?
October 27, 2019 Stack Exchange answer: Does a Window 10 license allow using it as a Web server?
October 27, 2019 Stack Exchange answer: How to implement a unique key for a long VARCHAR column in MySQL
October 26, 2019 Stack Exchange answer: convert sql-excel date to recognizable format
October 18, 2019 Stack Exchange answer: SQL log file 2TB is not enough, now what?
October 17, 2019 Stack Exchange answer: Copying SQL Server settings to new server
October 12, 2019 Stack Exchange answer: SQL database stuck in recovery
October 10, 2019 Stack Exchange answer: How To Fix High DTU Usage on Specific Query
October 7, 2019 Stack Exchange answer: Linked server from SQL server on AWS RDS to On premises MS SQL server database
September 15, 2019 Stack Exchange answer: Monetary value in integer over decimal datatype
February 12, 2019 Stack Exchange answer: How to pause the subscriber end of transactional replication
January 5, 2019 Stack Exchange answer: Managed Instance Restart
January 4, 2019 Stack Exchange answer: How to analyze compression options for Azure SQL Database?