Year archive

Posts from 2017

Blog posts

December 31, 2017 Backing up to NUL:
December 20, 2017 Interviewed by Mohammad Darab
December 18, 2017 Alerting on SQL Server Blocking
November 1, 2017 Q&A with the MVP Award Program
October 29, 2017 Ten tips for PASS Summit Attendees
October 26, 2017 Finding the Leader Blocker
October 1, 2017 Change in plans for LGBT+ Meetup at PASS Summit 2017
September 20, 2017 Shortcuts From an Impatient DBA Recording- DBA Fundamentals
August 22, 2017 Multi-Statement TVFs in Dynamics CRM
July 20, 2017 SentryOne Community Ambassador
July 9, 2017 The most important resume tip
June 30, 2017 What’s wrong with DELETE EXISTS?
June 28, 2017 Why Best Practices Exist: Learning from others' mistakes
June 28, 2017 LGBT+ Meetup at PASS Summit 2017
April 10, 2017 Transaction log growth during BACKUP
March 30, 2017 What the heck is a DTU?
March 30, 2017 Blogging at SQLPerformance.com
March 19, 2017 Congratulations 2017 Microsoft MVP!
February 28, 2017 SQLSaturday Boston 2017 Roundup
February 6, 2017 Customizing SSRS Sender Address
January 27, 2017 Keyboard shortcut to close a query tab in SSMS
January 11, 2017 Building a Twitter-bot RSS Aggregator

Stack Exchange answers

September 18, 2017 Stack Exchange answer: LOG_RATE_GOVERNOR Wait Stat
September 2, 2017 Stack Exchange answer: Rebuild Very Large Primary Key Index
August 16, 2017 Stack Exchange answer: Query a view in a procedure in which the view name is a variable
August 15, 2017 Stack Exchange answer: Can SQL Server 2016 log files be applied on SQL Server 2012
August 14, 2017 Stack Exchange answer: Reconnect "not connected" query windows in SSMS to original connection
July 6, 2017 Stack Exchange answer: SQL Server FCI won't start after OS Upgrade
June 27, 2017 Stack Exchange answer: Spread workload with always on high availability groups
April 28, 2017 Stack Exchange answer: What is the row overhead when using Page Compression?
April 20, 2017 Stack Exchange answer: Prevent Modification of dbo objects while allowing other schemas to be modified
April 20, 2017 Stack Exchange answer: Why does it take so long to view logs on a server?
April 19, 2017 Stack Exchange answer: Load balancing reads SQL Server 2016 AG
April 19, 2017 Stack Exchange answer: Troubleshooting Powershell errors from SQL Agent job
April 17, 2017 Stack Exchange answer: Transaction Replication on AlwaysOn
April 17, 2017 Stack Exchange answer: How to take SQL Server databases backup using .bat script file with time stamp
April 17, 2017 Stack Exchange answer: If the Database is in Readonly mode how can we drop/remove those unused roles
April 14, 2017 Stack Exchange answer: Preventing SQL injection in dynamic SQL
April 12, 2017 Stack Exchange answer: When setting up an AlwaysOn Availability Group, should the master database be one of the "Availability Databases"?
April 10, 2017 Stack Exchange answer: Releasing free space in mdf file to OS
April 10, 2017 Stack Exchange answer: SQL Triggers not preventing insert
April 7, 2017 Stack Exchange answer: Why do I have to backup a transaction log twice for it to shrink?
April 6, 2017 Stack Exchange answer: Converting date stored as a varchar
April 5, 2017 Stack Exchange answer: Transaction log is growing very fast
March 31, 2017 Stack Exchange answer: Connecting to ReadOnly Secondary Replica of SQL Server via the Listener by Default
February 9, 2017 Stack Exchange answer: Risks of manual failover in Always On Availability Groups
January 25, 2017 Stack Exchange answer: SQL Agent Job Logs - Can't get the Error Log
January 6, 2017 Stack Exchange answer: Nonclustered index storage on clustered columnstore
January 4, 2017 Stack Exchange answer: Cannot restore azure database to local due to missing master key
January 2, 2017 Stack Exchange answer: How often to update SQL Server?