Year archive

Posts from 2015

Blog posts

December 29, 2015 Data Compression: Costs & benefits
December 15, 2015 sp_autostats: object-level auto update statistics
December 8, 2015 DROP TABLE Bug on Filestream Garbage Collection
November 24, 2015 SSMS Vertical block highlighting & editing
November 19, 2015 #sqlcares, #sqlwish, and #sqlfamily
November 17, 2015 RECONFIGURE—When to use WITH OVERRIDE?
November 10, 2015 Speaking at SQL Saturday #465 in Providence, RI
November 9, 2015 Speaking at SQL Saturday #470 in DC
October 18, 2015 Thank you #sqlsatbostonbi 2015
October 8, 2015 Dumplings, Databases and Corporate Espionage
September 25, 2015 Really Long Descriptions on SQL Agent Jobs
September 15, 2015 Planning for an outage: Phone numbers
September 11, 2015 Embedded video demos in PowerPoint
September 10, 2015 Thanks for being awesome NE SQL!
August 18, 2015 Tip: Master Control Panel
July 14, 2015 Watch your step! Don't become a DBA-hole
July 7, 2015 Using SQL Agent MSX for Availability Groups
June 18, 2015 How to find the SQL Server Service Account
June 3, 2015 Tip: Go [count]
June 2, 2015 Common SSMS keyboard shortcuts
June 1, 2015 Tip: Never disable a job temporarily
May 29, 2015 Tip: Windows Explorer address bar hack
May 28, 2015 SSMS Query Shortcuts
May 27, 2015 Shortcut: SQL Template Parameters
May 26, 2015 Shortcut: CTRL + ]
May 25, 2015 Shortcut: CTRL + SHIFT + V
April 30, 2015 Big security loophole with SQL Logins
April 21, 2015 Converting delimited values to a table (efficiently?)
January 22, 2015 sp_executesql with output parameters

Stack Exchange answers

October 10, 2015 Stack Exchange answer: How to pass SSRS params into a URL
August 31, 2015 Stack Exchange answer: Will Transaction Log backup to Nul break Always On Availability Group configuration?
April 17, 2015 Stack Exchange answer: Error 3203 restoring SQL Server backup: The data is invalid