A data professional portfolio should show a few complete projects, clear write-ups, and runnable code that explains decisions and tradeoffs.
SQL SERVER – SQL in Sixty Seconds – Need Your Opinion
Though this may look very simple to you it is very crucial to me and I would like to know your opinion about it. I have included the latest video.
SQL SERVER – Script to Update a Specific Column in Entire Database
A reader added a ModifiedDate column to every table and left it NULL. Here is a script to update a specific column in the entire database at once.
The Last Actual Execution Plan: LAST_QUERY_PLAN_STATS in Practice
Capture the last actual execution plan with LAST_QUERY_PLAN_STATS, inspect runtime rows, and understand what cache retention cannot provide.
Connecting to SQL Server From Home Without Exposing Port 1433
Keep port 1433 off the public internet by checking external reachability and using VPN, a jump host, Bastion, and trusted encryption.
TABLESAMPLE Samples Pages, Not Rows: Sampling a Large Table Right
Compare TABLESAMPLE page sampling with NEWID sorting and CHECKSUM filters by row count, reads, spread, and repeatability.
Blog Clean-Up: What a 20-Year-Old Blog Removed in 2026
A blog clean-up is the work nobody sees and every reader feels. This post lists what a 20-year-old blog removed and fixed in 2026: plugins, unused images, thin tags and dead announcements. Each step comes with a lesson for any blogger.