Blog Posts

2020

December 16 | Hurray! I passed my 70-767 and earned my MCSE!
October 12 | Hooray! I earned my Scaled Agilist (SAFe 5) badge!
May 25 | Studying for the 70-767 to earn the MCSE
January 20 | T-SQL Tuesday #122 – Imposter Syndrome wrap up
January 7 | T-SQL Tuesday #122 – Imposter Syndrome

2019

December 12 | How to Fix SQL Database Error 8942
December 10 | Future goals and content
November 26 | Hurray! I earned my CDMP!
November 12 | T-SQL Tuesday #120 What were you thinking?
October 29 | Lessons from conferences
October 8 | T-SQL Tuesday #119 Changing my mind
September 24 | What is DAMA?
September 13 | Upcoming blog content
September 10 | T-SQL Tuesday #118 My fantasy SQL features
August 27 | Develop your career – Brand yourself!
August 13 | Whiteboarding in interviews
July 30 | Verify access to many SQL Server instances
July 9 | Get notified when a user with administrative privileges logs into your SQL Server
June 25 | Permission was denied on the object ‘master_properties’, database ‘SSISDB’, schema ‘internal’.
June 11 | Alert when SQL Server jobs fail
May 28 | Pass multiple values to case when expression
May 14 | T-SQL Tuesday #114 Puzzle Party
May 7 | Identify and resolve “Adding a value to a ‘date’ column caused an overflow”
March 26 | SQL Server Database in Suspect mode
March 12 | T-SQL Tuesday #112 Dipping into my Cookie Jar
February 26 | Identify and resolve “Conversion failed when converting the varchar value ‘Something’ to data type int”
February 12 | Properly reference your columns!
January 29 | Truncate vs Delete
January 17 | 2018 Wrap Up!
January 8 | T-SQL Tuesday #110 Automate your Toggl dataset with SSIS

2018

December 25 | ELI5 how are join statements semantically structured?
December 11 | How to stop the SQL Scheduler with T-SQL
November 27 | How to learn and implement Change Tracking in SQL Server
November 13 | T-SQL Tuesday #108 Learning non SQL Server technologies
October 23 | How do I dynamically populate a dropdown list for users to filter a report in SSRS?
October 9 | How to keep track of how many records were truncated?
September 25 | What is the optimal way to order a clustered index?
September 11 | T-SQL Tuesday #106 Trigger headaches or happiness?
August 14 | T-SQL Tuesday #105 The Wall
August 6 | How I resolved “Recovery_Pending State” which occurred while moving SQL Server files
July 27 | Hurray! I passed the 70-762 exam!
July 25 | Why and who should become certified?
July 21 | How I studied for the 70-762 exam
July 9 | What is the average day of a DBA? (Part 4 of 4)
July 8 | What is the average day of a DBA? (Part 3 of 4)
July 6 | What is the average day of a DBA? (Part 2 of 4)
July 4 | What is the average day of a DBA? (Part 1 of 4)
June 27 | How many Sequences can I have in SQL Server?
June 19 | Do Synonyms impact performance in SQL Server?
June 9 | Skill showcase – Pet store OLTP database
May 16 | Ola Hallengren not truncating T-Logs after backup. Prefer Secondary.
May 7 | Parameter validation failed in SSRS
May 4 | Featured Stack Exchange answer!
April 12 | Where did I put that thing in my SSIS project?
April 5 | Snapshot isolation transaction failed in database (Availability Group and SSIS woes)
March 27 | How do I check the metadata of my temporal table?
March 13 | My study guide to the 70-762: Developing SQL Databases
February 14 | Column encryption, is it table or data specific?
January 27 | Connecting PowerBI to RaspberryPi (MariaDB Engine)
January 16 | MySQL (Really, MariaDB) on the Raspberry Pi!
January 4 | Boolean order of precedence in T-SQL
January 3 | Review of Itzik Ben-Gan’s Books
January 3 | Passed the 70-761 exam, Querying with Transact-SQL!

2017

April 27 | Home VPN’s, are you updating your IP securely?
April 16 | What if I edit a View in use?
February 13 | Auditing your SQL Servers
January 31 | Who changed my data?