Archives

2025 • 2024 • 2023 • 2022 • 2021 • 2020 • 2019 • 2018 • 2017 • 2016 • 2015 • 2014 • 2013 • 2012

2025

• 09/04/25 - How to Avoid Knowledge Stagnation

2024

• 12/24/24 - Learning Database Design and Power BI Performance

2023

• 11/17/23 - Building Upon Your Productivity Momentum: Staying Productive For Life
• 10/10/23 - The Evolution of Database Administration: From Administration to Database Reliability Engineering
• 05/20/23 - Book Review: SQL Query Design Patterns and Best Practices

2022

• 09/19/22 - Book Review: SQL Server Query Tuning & Optimization
• 06/08/22 - How To Create A SQL Server 2022 Learning Sandbox In Few Easy Steps

2021

• 04/14/21 - Book Review: High Performance SQL Server (Second Edition)
• 01/04/21 - What A Year That Was

2020

• 03/02/20 - Beginner’s Mind

2019

• 11/04/19 - Book Review: Eat People – And Other Unapologetic Rules For Game-Changing Entrepreneurs
• 03/16/19 - Certification on Orchestrating Big Data with Azure Data Factory
• 03/08/19 - SQL Server 2017 Reporting Services: The Basics Part 5
• 03/01/19 - Transforming Data With Azure Data Factory Data Flow
• 02/21/19 - Copy Data From On-Premise SQL Server To Azure Database Using Azure Data Factory
• 02/15/19 - SQL Server 2017 Reporting Services: The Basics Part 4
• 02/08/19 - SQL Server 2017 Reporting Services: The Basics Part 3
• 02/01/19 - SQL Server 2017 Reporting Services: The Basics Part 2
• 01/25/19 - SQL Server 2017 Reporting Services: The Basics Part 1
• 01/18/19 - Miscellaneous Notes On System Architecture and Design
• 01/11/19 - Book Review: SQL Server 2017 on Linux
• 01/04/19 - Looking Forward

2018

• 12/21/18 - Forecasting Kyle Kuzma’s Field Goal Percentage (FG%)
• 11/02/18 - How I Work: Data Professionals at Work
• 04/10/18 - Creating Facets in SQL Server 2017 Using R
• 04/03/18 - Creating Bar Graph In SQL Server 2017 Using R
• 03/27/18 - Getting Things Done With SSMS
• 03/20/18 - Identify R Package Dependencies Using miniCRAN
• 03/13/18 - Getting Started With R In SQL Server 2017
• 03/06/18 - Book Review: SQL Server 2017 Machine Learning Services With R
• 02/27/18 - Productivity For The Data Pro
• 02/20/18 - Killing A Service Broker SPID
• 02/13/18 - Database Maintenance Without Breaking The Bank
• 02/06/18 - Waiting Tasks Reveal Pain Points
• 01/30/18 - Layman’s Guide to Performance Tuning
• 01/23/18 - My Favorite SQL Prompt Features
• 01/16/18 - How To Split Table Partitions Automatically
• 01/09/18 - SQL Operations Studio As Monitoring Dashboard
• 01/02/18 - My Tech Reading List to Start the Year

2017

• 12/26/17 - My Learning Goals for 2018
• 10/03/17 - Book Review: High Performance SQL Server

2016

• 02/16/16 - Power BI KPI Report: Hospital Charge Data
• 02/09/16 - How Much Hospitals Charge For The Same Type Of Cases?
• 02/02/16 - How to Install Microsoft R Server for Windows

2015

• 08/27/15 - Getting Started With Power BI Desktop: Simple Visualization
• 08/19/15 - Getting Started With Power BI Desktop: Getting Data
• 08/13/15 - Getting Started With Power BI Desktop: Installation
• 05/29/15 - Finding gaps or missing dates in a date range using TSQL
• 03/19/15 - How to resequence column based on numeric prefix using TSQL

2014

• 07/03/14 - Executing scripts on multiple servers the easy way
• 01/09/14 - Laying The Ground For A Successful Reporting Project

2013

• 10/29/13 - My First Book: SQL Server 2012 Reporting Services Blueprints
• 05/24/13 - Connecting Windows Server 2003 VM To External Network In Hyper-V
• 05/16/13 - Rated R (A Teaser)
• 05/10/13 - Non-Tech Books On My Desk
• 05/03/13 - Visionary: Seeing Through Defects

2012

• 12/04/12 - My Writing Toolkit for the book project
• 11/26/12 - Choose specific folders to sync with OneDrive
• 11/19/12 - Tools of the Trade
• 09/06/12 - SQLskills joining Pluralsight is a good news for all
• 09/01/12 - Demonstration of a simple dashboard created with the Tableau Software
• 07/27/12 - Learning solid SQL Server and Business Intelligence skills through online training
• 06/06/12 - Getting started with SQL Server on private cloud
• 06/04/12 - Review of “Start Here! Learn Microsoft Visual C# 2010”
• 05/09/12 - Your SQL Server database just failed, can you restore the backup?
• 05/03/12 - DBA Roadmap Seminar review
• 04/23/12 - Who are the sysadmins in this sql server?
• 04/16/12 - 10 must follow blogs that might not be in your list
• 04/11/12 - How To Limit User Access To Your Database
• 04/04/12 - The evolving role of the database professional
• 03/29/12 - Save yourself from despair with full database documentation