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)
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)
Last week, I called up Matan Yungman, and offered to replace Guy Glantser as a co-host in SQL Server Radio, while Guy is away on holiday in New Zealand.
We recorded episode 111 in English, and episode 117 in Hebrew.
For this month’s T-SQL Tuesday, Kevin Chant asked us to dream up our fantasy SQL Server feature.
The feature I wish we had is Table Partitioning, but… Better. Unfortunately, the feature by large remained the same way since its release in 2005, without any meaningful improvements (besides some parallelism and statistics maintenance improvements).
But I think Microsoft can do much better. Continue reading #TSQL2sday : I wish SQL Server had better Table Partitioning
On October 7th, I delivered my presentation about Advanced Dynamic Search Queries at the Israeli Data Platform Meetup, at Microsoft Reactor Tel-Aviv!