Skip to content
Home » Learn » Page 7

Learn

The new “metadata-only column changes” feature in SQL Server 2016 is useless!

You might have seen this blog post by Paul White: New Metadata-Only Column Changes in SQL Server 2016. It talks about how, when a table is compressed, you can change (i.e. increase) a column’s data type without having to create a new table and migrate the data into it, and without having to refactor all of the underlying data. But, not everything is rainbows and unicorns…

Read More »The new “metadata-only column changes” feature in SQL Server 2016 is useless!

Webinar – Development Lifecycle Basics for DBAs at the Data Weekender

The #DataWeekender is a free online conference scheduled for May 2nd, organized by the SQL Server community’s finest, as an online replacement for all the SQL Saturdays and other SQL Server conferences that were being canceled en masse due to the COVID-19 situation.

One of my submitted sessions was accepted:

Read More »Webinar – Development Lifecycle Basics for DBAs at the Data Weekender

T-SQL Tuesday #125 – Getting started with database unit testing

This month’s #tsql2sday is hosted by Hamish Watson (b|t) and this time touches on the extremely important topic of database unit testing. Its high importance and value should be a no-brainer. But it can be a very difficult topic, and the hardest thing about it, in my opinion, is knowing where to start. Hopefully, with this blog post, I can help you out with that.

Read More »T-SQL Tuesday #125 – Getting started with database unit testing

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.

Read More »Is Azure SQL Analytics all you need for SQL Server Monitoring?
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 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.

CI and CD with SSDT and living to tell about it

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 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.