[EDIT] Due to the current ongoing situation between Israel and Palestine, the event was delayed to February 2024. For more details, please refer to the official Data TLV Summit website.
The Data TLV Summit in Israel is the single most biggest, largest, most amazingest annual summit in Israel for data enthusiasts, made by the community, for the community. The summit is taking place on November 2, 2023, and I will be delivering my most popular session there: Development Lifecycle Basics for DBAs!Read More »I’m speaking at the Data.TLV Summit 2023 in Israel
As a SQL Server DBA, you are responsible for securing your organization’s critical data stored in SQL Server. However, there are many myths surrounding SQL Server security 🔒 that can lead to a false sense of security or even leave you vulnerable to attacks. In this blog post, I’ll be debunking the 15 most common security-related myths in SQL Server that every DBA should be aware of. So, grab a cup of coffee, and let’s get started! ☕Read More »The Top 15 SQL Server Security Myths
On May 10th, all Israeli experts who participated in the conference will share their experience with the Israeli community and convey the best sessions they attended in #SQLBits 2023! I will also be one of them and deliver my favorite session!Read More »I’m speaking – The best of SQLbits 2023
Redundant indexes in SQL Server are a phenomenon that is more common than I’d like to admit. I see it in quite a lot of shops. Meaning, that there’s still a significant target audience for this blog post!
This article published by Brent Ozar is very informative about redundant/duplicate indexes, what they mean, why they’re bad, and what should be done with them.
Also, a few years ago, Guy Glantser published a post about dropping redundant indexes. It’s very useful for finding all redundant indexes within all tables in a specific database.
But what both of these articles are missing – is the ability to easily generate Drop/Disable commands for these redundant indexes.Read More »Drop All Redundant Indexes In Every Database All At Once
In this post, I will introduce you to a special T-SQL script that you can use for detecting potential SQL injection attacks in your database, as well as application-level bugs that you didn’t necessarily know you had.Read More »Detect Application Bugs and Vulnerabilities You Didn’t Even Know About
SQL Injection is something I would expect any reader of my blog to be familiar with. Despite being one of the oldest database attack methods, it still persists for decades on the OWASP Top Ten list of critical security risks to web applications.
In fact, instead of dying out, it only seems to be getting more clever and even automated. With “hacker bots” scouring the web and automatically probing for injection vulnerabilities to exploit. I know, as I’ve once been a victim of such attacks in the past.
But today I’m not actually going to talk about that. Today, I’m going to ask the question: When is SQL Injection dangerous, even if it’s perfectly safe?Read More »Could SQL Injection be dangerous even when perfectly safe?
As a spiritual “part 4” in my ongoing series of webinars titled “CI and CD with SSDT”, I will be delivering an entirely new session called “Troubleshooting Build and Deployment of SSDT Projects for SQL Server DevOps” (or “Troubleshooting Common SSDT Errors” for short).Read More »New Upcoming Session – Troubleshooting Common SSDT Errors
This month’s T-SQL Tuesday is hosted by Deb the DBA (b|t), who invites us to give a long rant about a question that a coworker could be asking us, without knowing what they’ve just gotten themselves into by doing that.
Well… I’ve got just the thing 🤭Read More »T-SQL Tuesday #152 – Which version of my database was deployed? It depends!
Following the rise in popularity of DevOps for Databases, many interesting questions are being asked on the topic.
One of these questions is: Should your SQL Database project be in the same source control repository and solution as the App code project? Or maybe they should be in the same repository but separate solutions? Or maybe they should be in completely separate repositories?Read More »Should the Database and Application projects be in the same Repository?