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”
Linked Servers are an easy way to allow direct access between different SQL Servers. But, by using this feature, you may have created a wide-open backdoor into your servers! Read on for more details… Continue reading Are you using Linked Servers? They may be in serious danger!
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)
Clear your calendars! The long-awaited webinar about CI and CD with SSDT finally has new dates! Yes, I said dates as in plural. It’s going to be a 2-parter! November 28th and December 4th, hosted at the #PASS Global Hebrew Virtual Group. Continue reading Webinar: CI and CD with SSDT – Rescheduled!