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