2019
2018
- Nov 7 ~ Exporting configuration data from SQL Sentry
- Nov 6 ~ Don't go to the PASS Summit speed networking session
- Nov 3 ~ SMO "leaks" SQL login passwords (in memory) and (some) SecureStrings in clear-text
- Mar 13 ~ Does the log file growth for multiples bug still exist in SQL Server 2012?
- Mar 8 ~ Availability Group round-robin read-only routing isn't magic
- Feb 25 ~ Introducing Jojoba 4, the multi-threaded testing framework for PowerShell
- Feb 20 ~ Populating PowerShell module FunctionsToExport automatically
- Feb 18 ~ Jumping Spider
2017
- Nov 30 ~ Upgrading an expired SQL Server 2016 Evaluation Edition
- Oct 18 ~ Are your disks formatted with UseLargeFRS?
- Aug 10 ~ Forgettable improvements to PowerShell over the ages
- Apr 26 ~ Something you didn't know about validating full-text indexing
- Mar 24 ~ Validating the new receive-side scaling bug in VMware Tools
- Mar 15 ~ Availability group replica murdered in cold blood by WSFC
- Mar 2 ~ ERRORLOG records max out at 2049 characters
- Feb 28 ~ Webinar starting in 12 hours!
2016
- Oct 21 ~ Nothing is ever as easy as the demo because tests are hard
- Oct 20 ~ I like you, but I don't like your best practice (power plans)!
- Oct 18 ~ Supercharge your PowerShell functions with a PoshRSJob template
- Aug 31 ~ If you don't mind me saying, PowerShell Workflows are awfully broken
- Aug 16 ~ Recipe for an awesome (free) SQL Server workstation
- Jul 7 ~ Revisiting SQL Server 2016 Master Data Services installation prerequisites
- Jul 7 ~ SQL Server 2016 Master Data Services service accounts are broken
- Jul 3 ~ Yellow Moth
- Jul 3 ~ Carpenter Ant Queen
- Jun 9 ~ Using PowerShell to generate a bulk insert format file
- Jun 8 ~ SQL Server 2016 GDR update
- Jun 8 ~ SQL Server 2016 demonstrating a Bulk Insert crash dump
- Jun 8 ~ SQL Server 2016 MDS upgrade errors
- May 5 ~ Be careful if you've manually edited your SQLPS files
- May 5 ~ Huntsman Spider
- Feb 29 ~ Making SMO faster while avoiding an undocumented bug
- Feb 9 ~ Don't forget to reboot after installing SQL Server 2016 CTP 3.3
- Feb 8 ~ Wolf Spider
- Feb 6 ~ When a login looks fine but cannot log in
- Jan 29 ~ Prowling Spider
- Jan 25 ~ Wolf Spider
- Jan 21 ~ Constructing a SQL Server 2016 temporal table using SMO
- Jan 13 ~ This is how to fix R Services after an in-place SQL Server 2016 CTP 3.2 upgrade
- Jan 7 ~ Jumping Spider
- Jan 4 ~ Sac Spider
- Jan 2 ~ Wasp
2015
- Dec 31 ~ Cobweb Spider
- Dec 29 ~ A few quick notes on SQL Server 2012 slipstreaming
- Dec 29 ~ Leaf Curling Spider
- Dec 27 ~ Unidentified Spider
- Dec 26 ~ Jumping Spider
- Dec 8 ~ Three cases where Ola Hallengren's Maintenance Solution won't backup a database
- Dec 3 ~ This is how to add a database to an Availability Group, in reverse!
- Dec 1 ~ Before migrating to Availability Groups check your log backups
- Nov 30 ~ Identify agent jobs running retrospectively
- Nov 30 ~ Copy SCOM sys.messages between servers
- Nov 29 ~ Automatic Availability Groups for Sharepoint on SQL Server
- Nov 28 ~ New site design, please report issues
- Nov 27 ~ Visualise the monitor hierarchy that contributes to a SCOM computer object's health state
- Nov 19 ~ Mealybug Destroyer (native Ladybird)
- Nov 17 ~ A few quick notes on real world database corruption
- Nov 16 ~ Rebuilding the "Log on as a service" list after it has been overwritten by Group Policy
- Nov 15 ~ This is how to delete corrupt Management Data Warehouse cache files automatically
- Nov 1 ~ Prowling Spider
- Oct 18 ~ A cool way to check Reporting Services memory usage
- Oct 18 ~ This is how to shred Extended Event XML faster
- Oct 18 ~ A script to help delete backup history on SQL Server 2000
- Oct 3 ~ This is what sys.sp_change_users_login does
- Aug 23 ~ Get-WmiObject replacement with timeout
- Aug 20 ~ How to fix Reporting Services when it won't start after patching
- Aug 20 ~ Troubleshooting WSUS errors from an SQL Server perspective
- Aug 14 ~ Tips on building a Windows Server lab for clustering SQL Server in VMWare Fusion
- Aug 14 ~ Forcing access into SQL Server without a restart
- Aug 10 ~ Modifying tempdb database files without a restart
- Aug 2 ~ Agent job errors when running an SSIS package
- Jul 30 ~ Create a PDF of the SQL Server 2000 Resource Kit eBook
- Jul 29 ~ SCOM configuration script for low-privilege environments
- Jul 29 ~ Burrowing Wolf Spider
- Jul 29 ~ How to reset a Master Data Services service account password
- Jul 28 ~ How to fix Integration Services when it won't start after patching
- Jul 28 ~ How to slipstream SQL Server 2008 R2
- Jul 28 ~ Out-File and Excel
- Jul 28 ~ Auditing Windows security policy settings with PowerShell
- Jul 28 ~ Installing prerequisites for Master Data Services using PowerShell
- Jun 4 ~ Master Data Services Silverlight error
- Jun 3 ~ SQL Server security and renamed logins
- Jun 2 ~ Preparing agent jobs for AlwaysOn Availability Groups
- Jun 2 ~ Experiments with master.sys.xp_delete_file
- Jun 2 ~ Check if Database Mail is running
- May 31 ~ Login errors with syspolicy_purge_history
- May 31 ~ How to restart the default trace
- May 31 ~ How to convert an SQL Server login SID to a readable string
- May 30 ~ What's wrong with SQLPS?
- Mar 22 ~ Master Data Services error
2014
- Nov 2 ~ Scraping for iPhone Availability
- Nov 2 ~ A common mistake when splitting strings
- Jul 24 ~ PowerShell with a focus on automation
- Jul 14 ~ RBAR and UDFs
- Jul 8 ~ Microsoft Exam 70-465 (2014) Study Guide
- Jul 7 ~ Microsoft Exam 70-464 (2014) Study Guide
- Jul 2 ~ Testing some NOLOCK and READPAST
- Jun 6 ~ Children, Hot Dogs, and Body Bags
- May 2 ~ MSDAINITIALIZE minimum required permissions
- May 1 ~ Upgrading SQL 2005 to SQL 2014
- Apr 10 ~ Iterating years in PowerShell
- Feb 25 ~ Monty Hall simulation in PowerShell
- Feb 16 ~ Check the error log for failed operations immediately before this error message
- Feb 14 ~ Will alter procedure result in an execution failure?
- Feb 14 ~ Caveat of sp_rename
- Feb 6 ~ Trigger deadlock testing with PowerShell
- Jan 17 ~ Testing logins and passwords from a stored procedure
- Jan 17 ~ Taking down production using nested transactions
- Jan 16 ~ How to add Brent Ozar or GoToWebinar calendar entries on a Mac
2013
- Oct 17 ~ Load Balancing SQL Server Backups
- Oct 17 ~ Checking for null in PowerShell
- Oct 8 ~ Walking through SQL Server cursor design decisions
- Sep 30 ~ How to get Kerberos for SQL Server running, fast
- Sep 29 ~ PowerShell script to fix the end tags in FireFox bookmarks exported as HTML
- Sep 29 ~ A script to convert the JavaScriptSerializer JSON format to a PowerShell format
- Aug 9 ~ PowerShell and Get-ChildItem problems
- Jul 23 ~ PowerShell FTP
- Jul 17 ~ Comparing varbinary data types in SQL Server
- Jul 17 ~ How to construct a string in PowerShell with a certain number of spaces
- Jul 8 ~ Error handling in PowerShell (and the real world)
- Jul 5 ~ SQL Server replication validation on vertically filtered articles
- Jun 28 ~ SSIS stops in BIDS while debugging without showing any error
- Jun 21 ~ SQL CLR and "The context connection is already in use"
- Jun 7 ~ Identity Columns and Not For Replication
- May 17 ~ SQL Server Transactional Replication Validation
- Apr 18 ~ SQL Server's SQLServer PSProvider and WMI
- Apr 17 ~ PowerShell "System error 85 has occurred" with net use
- Apr 8 ~ SSIS error 0xC000F427 and derived columns
- Mar 26 ~ PowerShell: How to show all of an object's properties and values
- Jan 13 ~ Development Office Politics
- Jan 10 ~ PowerShell: How to search a list of objects with an array of wildcards in PowerShell
2012
- Nov 28 ~ ODBC imports crashing SQL Server with exception 0xC0000005
- Nov 11 ~ Apple Keyboard drivers under Windows
2011
- Dec 16 ~ Reporting Services crashes with a custom assembly
- Dec 14 ~ System.Security.Permissions.ReflectionPermission
- Nov 30 ~ Error 7308 and 7303
- Nov 8 ~ Parallels / VirtualBox using lots of CPU during idle
- Sep 23 ~ How to fix obscured text when using scrolling tablix headers
- Jul 5 ~ Adding fonts to a running production server
- Jun 23 ~ Sum on groups and case sensitivity issues in Reporting Services
- Jun 22 ~ Scared of supermarkets
- Apr 21 ~ Little quirk dealing with For Xml
- Apr 19 ~ Reporting Services and the T-SQL Time datatype
- Apr 14 ~ Obscure SSRS messages
- Apr 14 ~ Does T-SQL Between work back to front?
- Apr 13 ~ Code.NUCase
- Apr 13 ~ SSMS grey menu items
- Apr 6 ~ Code.NiceString
- Apr 4 ~ Duh moments: Previous(), and Cross Apply
- Mar 28 ~ Common Dates For Reporting Services And T-SQL (Part 2)
- Mar 27 ~ Carried Forward Page Totals
2010
- Oct 25 ~ Porting VB6 Applications To VB.NET
- Aug 9 ~ No show Tuesday night
- Aug 7 ~ Tweaks make for a good show!
- Aug 6 ~ Another last minute show last night!
- Aug 5 ~ That's wrong
- Jul 7 ~ I won a YouTube award!
- Jul 7 ~ How to catch a pedophile
- Jul 6 ~ Preparing for tonight's show
- Jul 2 ~ Preparing for Tuesday 6th
- Jun 4 ~ My girlfriend is a Transformer, redux!
- May 26 ~ My girlfriend is a Transformer
- Mar 4 ~ RAW Comedy wildcard night
- Mar 4 ~ Exotic porn for angry people
- Feb 28 ~ Street comedy in the Northbridge Piazza
- Feb 22 ~ RAW Comedy chose me!
- Feb 5 ~ RAW Comedy entry
- Feb 2 ~ Models can't spell models
- Jan 28 ~ Trip to the vet
2009
- Dec 29 ~ Superman saved me
- Dec 16 ~ Cats beat the hell out of dogs
- Dec 9 ~ Games adults play
- Nov 30 ~ How women become thin or fat
- Nov 17 ~ Why dolphins can't use toilets
- Oct 27 ~ That's how terrorism works