blog
2019
2018
2017
- Time With Family - Thanksgiving
- Delight in the Little Moments
- Welcome to the World Little Ella
- Recovery is a Marathon, Not a Sprint - Hurricane Harvey
- A Waterlogged Texan Reporting In from Northpoint Tomball
- A Not-So Waterlogged Texan - Tuesday
- Ultrawide Monitor - Samsung CF971 - First impressions
- Fixing VirtualBox Only Showing 32bit Windows OS Options
- Exploring SQL Server With Powershell And SMO Basics
- Capturing Perfmon Counters With Telegraf
- InfluxDB and Annotations
- Dataedo - First Look
- Spotify vs Google Play
- ANTS Performance Profiler for the SQL Server Dev
- Update SSMS With PS1
- External Tool VSCODE called from SQL Management Studio
- Best Practices: Defining Explicit Length for Varchar/Nvarchar
- Add User To Admin Group on Machine
- Powershell Module Improvements for SQL Server in 2017
- Running InfluxDB as a service in Windows
- Setting Up InfluxDb, Chronograf, and Grafana for the SqlServer Dev
- Automate Windows Updates for Development
- Programming Fonts For The Newb
- TFS Custom Task - Service Actions (for TFS 2015 Update 2.1 or before)
- Red Gate SQL Clone (1) - Initial Setup
- Life Hack: When you need a mouse pad
- Track Creation of Databases
- SSMS 2016 - Object Explorer Read Uncommitted
- Redgate SQL Data Compare & Devart DBForge Data Compare
- Quick Way to Run Powershell Tasks in Parallel
- Bad Idea Jeans: Query Optimization Through Minification
2016
- ManicTime - Timetracking Automation Done Right
- Dynamically Set Powershell Variables from json
- The Traditional Birthday Song Is Terrible
- Scan folder of dlls to identify x86 or x64 compiled assemblies
- Attaching Database Using SMO & Powershell
- Parallel Powershell for Running SQL
- Get Backup History for All Databases in Server
- Pizzicato Pizza
- Data Compare on Temporal Tables
- Fixing Untrusted Foreign Key or Check Constraint
- An Internet With Less Ads - Adguard
- Easy SQL Maintenance with Minionware
- Cannot Generate SSPI Context
- Centralized Management Server 101
- DAW Dive 02 - BFD3 - Drumming for the Rest of Us
- Migrating Database Collation - The Red Gate Way
- Syncovery & Arq - Syncing & Backup
- Powershell ISE: Updating Theme
- Fixing non-deterministic error when creating indexed view
- SQL 2016 - Configuration Manager Not Showing in Start Menu
- DAW Dive 1 - Getting Started - Studio One 3
- Setting DBCC 1222 on startup
- Ableton Live & Lemur Setup (From a Windows User)
- Lack for Nothing
- Remote Desktop Workflow Improvements
- SSMS - Connection Color with SQL Prompt & SSMSBoost
- SQL 2016 - Brief Overview on some new features
- Install ReadyRoll via Command Line
- Does sp_rename on a column preserve the ms_description?
- Regex With SQL Server - SQLSharp
- Improvements with SSMS 2016
- Glasswire: (Giveaway Included) Networking Monitoring even a caveman could
- SQL Compare 12: Initial Look
- SSMS Tools Pack - A Handy Tool for generating CRUD
- OmniCompare: A free tool to compare SQL Instances
- Continual Deployment of Visual Studio SqlProj
- The Mysterious Black Box of R - For the SQL Server Guy
- Red Gate Dependency Tracker - Making Databases Into Moving Art
- Google Search Only Results from the last year
- Automating SSMS 2016 Updates & Install
- Cool Tools: Powershell ISE-Steroids
- Failed to Initialize SQL Agent Log... not worthy
- TFS Work-Item Fancy Filtering
- SQL 2012 SP3 and entity framework conflict
- Previewing the new SSRS 2016 portal
- Failover all databases to other server
- Calculating Some Max Mirror Stats
- Easy way to test log shipping or availability groups setup
- Diff All Files - Reviewing Changesets Quickly
- Transaction Logging & Recovery (part 3)
- Seeker & Servant: Fantastic Music with incredible dynamics
- Verifying Instant File Initialization
- Transaction Logging & Recovery (part 2)
- Transaction Logging & Recovery (101)
2015
- Model needs exclusive lock
- Documenting Your Database with Diagrams
- Best Tools for Taking Notes In Development
- Dynamic SQL & Quotename
- XML Attribute VS Element Assignment when working with SQL
- Split personality text editing in SSMS with Sublime Text 3
- Multi-Cursor Editing SQL feels like the movie Inception just became real
- Brentozar''s Training: Chocolate & Cowboy Hats Included
- Monitoring SQL Server on a budget
- Stranger Danger... The need for trust with constraints
- Red Gate SQL Source Control v4 offers schema locks
- Using Qure Profiler To Benchmark Tuning Progress
- SET NOEXEC is my new friend
- Running very large scripts is not a strong area for SSMS
- Database Stuck in Single-User Mode Due to Botched Restore
- What was I thinking? Deleting myself from localdb?
- Some simple examples of querying xml with sql
- Enabling Instant File Initialization
- Upgrade from SQL 2014 Evaluation to Developer Edition
- Utilizing the power of table parameters to reduce IO, improve performance, decrease pollution, and achieve world peace...
- SQL Sentry Pro Explorer is worth it...
- Restoring a database that doesn't exist
- Statistics Parsing
- Dev Tools: FARR2 Launching groups of files or apps at once
- Dev Tools: The File Searcher/Launcher to rule them all
- Case of the Mondays... causing me to randomly redefine the Scope of Global
2014
- Dev Tools: XYplorer (review 1) - Catalog
- OR pattern causing indexing scans in parameter based queries
- Get Information on Current Traces Running
- Generate Random Date With Starting Point
- Snippet Alert: Useful dates (eom, bom, etc)
- Finding Groups - Consecutive Months
- Eliminate Overlapping Dates
- Scalar functions can be the hidden boogie man
2013
- Renaming all references inside stored procedures and functions can be migraine worthy without a little help...
- Shortcut to reference examples, syntax, and definitions straight from SSMS
- Check Constraints can help enforce the all or nothing approach when it comes
- SSMS 2012 Extender for the times you want some organization to the random pile
- TSQL Snippet for viewing basic info on database principals and their permissions
- A moment of void in the cranium reveals a recursive computed column with an
- View computed columns in database
- On how to Googlify your SQL statements for future searching
- Get synonym definitions for all databases in server
- Calculating the next beginning of month and the current end of month
- Installing SSMS 2012 all by it's lonesome
- snippet designate a certain time of the day in getdate()
- Native SSMS a second class citizen no longer...
- dynamic sql and a char crash
- How to default SSRS date parameters to the first and last day of the the previous month