This month’s #tsql2sday is hosted by the legendary Glenn Berry (b|t), and asks us about what we’ve been doing as a response to COVID-19. Madeira Data Solutions did quite a lot to chip in during these difficult times. Hopefully, it’s enough to make some kind of difference.
Read More »T-SQL Tuesday #126 – Responding to COVID-19
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!
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 WeekenderThis 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
Ever had your SHRINK operation in SQL Server get “stuck” and didn’t know why, or how to solve it? It’s more common than you think. Check out this post for more info, tricks and tips.
Read More »Troubleshooting Long-Running SHRINK Operations
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?
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!
Read More »Finding the Details Missing from the SQL Server Failed Logins Audit
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…
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…
Read More »How to Un-Heap Your 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.