Latest Blog Posts:
This script performs compression savings estimation check across the ENTIRE database within which it is executed, AND generate the relevant remediation scripts for you. Continue reading The Ultimate Compression Savings Estimation Script for an Entire Database
This month’s #tsql2sday, hosted by Jess Pomfret, is asking us to write about our favorite “life hacks” that make our lives easier. This topic has actually been pretty hot on my list for the past year or so, so I’m happy to share my experience. Continue reading T-SQL Tuesday #123: Life hacks to make your day easier
I never managed to find an online reference page for the rules run by the SQL Vulnerability Assessment tool. So I figured “why not do it myself?”. Cool script attached! Continue reading SQL Vulnerability Assessment Tool – Rules Reference List
It’s been a long while since I’ve published a blog post with a useful T-SQL script. So, today’s the day! Today’s script has something very interesting to do with Heap tables. Continue reading for more info… Continue reading Resolving Tables Without Clustered Indexes (Heaps)
I’ve submitted both parts of my 2-part sessions about CI and CD with SSDT to SQLBits 2020 and now YOU get the power to vote me in! Continue reading Want to see me in SQLBits 2020? Now is your time to vote!
Watch now! In this session, the second of a 2-part series, we will cover the rich tools, features, and methodologies in SSDT that allow DBAs to implement a continuous database development lifecycle, and how to solve common problems and edge cases.
This webinar was delivered as part of the PASS Global Hebrew Virtual Chapter, and as such is presented in Hebrew. Continue reading CI and CD with SSDT Part 2: Methodology & Features for DB DevOps (PASS Global Hebrew)
Watch now! In this session, the first of a 2-part series, we will learn what is Git Source Control? What are CI/CD Pipelines? What are Unit Tests? These are all topics that each DBA must familiarize themselves with before integrating with the software development lifecycle.
This webinar was delivered as part of the PASS Global Hebrew Virtual Chapter, and as such is presented in Hebrew. Continue reading CI and CD with SSDT Part 1: Development Lifecycle Basics for DBAs (PASS Global Hebrew)
Something went wrong. Please refresh the page and/or try again.