Learn

Is Azure SQL Analytics all you need for SQL Server Monitoring?

How well can you monitor Azure SQL Databases and Azure Managed Instances without any 3rd party tools? Is Azure SQL Analytics really good enough for the job? Can it be a decent competitor to powerhouses such as SentryOne, Red-Gate, Apex, Solarwinds and others? Can you use it as a cheap alternative in the cloud? Will I ever stop asking questions and get to the point already? Yes, of course I will! Just keep reading.

Finding the Details Missing from the SQL Server Failed Logins Audit

2020-03-09
T-SQL, Tools and Scripts

We all know the error log used by SQL Server to audit failed logins by default. But is it good enough? For many scenarios, it isn’t. It’s actually missing a lot of important information. But, worry not, for there are better solutions!

Are you using Linked Servers? They may be in serious danger!

2020-01-022022-12-25
SQL Server Database Engine

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… Read More »Are you using Linked Servers? They may be in serious danger!

How to Un-Heap Your Heaps?

2019-12-302022-12-31
T-SQL, Tools and Scripts
5 Comments

Today’s script has something very interesting to do with Heap tables. Specifically, how to turn them into something that’s not a heap. Continue reading for more info…

CI and CD with SSDT and living to tell about it

CI and CD with SSDT Part 2: Methodology & Features for DB DevOps (PASS Global Hebrew)

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… Read More »CI and CD with SSDT Part 2: Methodology & Features for DB DevOps (PASS Global Hebrew)

CI and CD with SSDT Part 1: Development Lifecycle Basics for DBAs (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… Read More »CI and CD with SSDT Part 1: Development Lifecycle Basics for DBAs (PASS Global Hebrew)

Eitan Guest-Stars in SQL Server Radio Episodes 111 and 117

2019-10-16
Learn, Life

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… Read More »Eitan Guest-Stars in SQL Server Radio Episodes 111 and 117

T-SQL Tuesday #118 – I wish SQL Server had better Table Partitioning

For this month’s T-SQL Tuesday, Kevin Chant asked us to dream up our fantasy SQL Server feature. I love this topic and so I had to join in on this as a late (and first-time) contributor.

My ask from Microsoft for SQL Server is something that…. Well… It should be simple. It should’ve been implemented YEARS ago. I’m thinking somewhere around the year 2005.

Data Platform Meetup Israel – Advanced Dynamic Search Queries

2019-09-08
Life, T-SQL

On October 7th, I delivered my presentation about Advanced Dynamic Search Queries at the Israeli Data Platform Meetup, at Microsoft Reactor Tel-Aviv! Watch here.

Re-align Identity Last Value to Actual Max Value

Sometimes, when you have a table with an IDENTITY column, there could be scenarios in which weird “gaps” are created between different IDs. There can… Read More »Re-align Identity Last Value to Actual Max Value

« Previous
1
…
6
7
8
9
Next »