AlwaysOn Availability Groups can be tricky when it comes to cluster configurations. Learn from a real-life scenario involving DR exercises and quorum failures.
[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
Recently we’ve encountered an interesting use case for a customer.
They had a table with partitioning that they needed to be archived (with the help of said partitioning), but the ALTER TABLE SWITCH commands were failing with a peculiar error:
Error 4907, ‘ALTER TABLE SWITCH’ statement failed. The table ‘MyDB.dbo.PrtTable1’ has 4 partitions while index ‘IX1’ has 6 partitions.
This prompted some insightful research into some of the validations done by SQL Server behind the scenes when executing an ALTER TABLE SWITCH command.Read More »Understanding ‘ALTER TABLE SWITCH statement failed’ errors 4907, 4908, and 4912
Have you ever come across an elusive SQL Server issue known as the “Latch Convoy Problem” or “Last Page Insert Contention”? It’s a rare and challenging problem to encounter in real-world scenarios. In fact, it’s so uncommon that many database professionals may go their entire careers without experiencing it firsthand. But sometimes, the unexpected happens, and you find yourself face to face with this elusive beast.
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
As a DBA, your job involves much more than just managing databases. You must also work with customers to understand their needs and provide solutions that meet their requirements. In this blog post, we will discuss how you can implement the SPIN sales strategy concepts as part of your job.Read More »From Good to Great: Boosting Your Performance as a DBA with the SPIN Sales Strategy
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
Learn how I resolved an interesting use case of a database stuck in Single-User mode after restoring from a backup. Read my latest blog post to find out more!Read More »Resolved: Database Stuck in Single-User Mode
On June 3rd, 2023, at the Data Saturday event in Croatia, I will be delivering LIVE my session: “How to Save Money On Your SQL Server Hardware“!Read More »Speaking at Data Saturday Croatia 2023 and visiting SQLBits 2023!