Archives

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

2023

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

2022

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

2021

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

2020

• 03/02 - Beginner’s Mind

2019

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

2018

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

2017

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

2016

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

2015

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

2014

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

2013

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

2012

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