sagi6452 days ago3 minHow to use Ola's backups solution with AlwaysOnlearn how Ola Hallengren’s implementation behaves with Always On and Backup Preference. the different scenarios and how to configure it.
Guy Glantser4 days ago1 minThe Most Important Performance Factor in SQL ServerToday I presented a session as part of our monthly live webinars. Here is a recap...
Vitaly Bruk6 days ago3 minSQL Server Registered ServersDevelopers, DBAs, QAs, or even accidental DBAs everyone of us works with SSMS (SQL Server Management Studio). We tend to spend a huge part of our work time a...
Madeira Team6 days ago1 minOLA? WHO THE F**K IS OLA?Recently, our team developed a new feature as an extension to Ola's maintenance solution for managing database file size growth and shrink.
Guy GlantserMay 271 minSQL Server Setup Best PracticesOn May 12, 2020, I had the honor to participate and speak in the GroupBy conference. I talked about SQL Server Setup Best Practices.
Noa BrodezkyMay 263 minsp_execute_external_script permission denied - What a b*tch!A few weeks ago, a customer contacted me with an interesting problem. They recently upgraded the SQL Server from 2017 to 2019 and started to get Permission d...
Guy GlantserMay 136 minTroubleshooting tempdb Space UsageWhen the tempdb database is growing too large, you need the tools to troubleshoot and locate the offending sessions or transactions.
Madeira TeamMay 121 minsp_Blitz – Free SQL Server Health Check Script from Brent Ozarwebinar recording - sp_Blitz – Free SQL Server Health Check Script from Brent Ozar
Eitan BluminMay 122 minT-SQL Tuesday 126 - Responding to COVID-19Madeira Data Solutions did quite a lot to chip in during these difficult times. Hopefully, it’s enough to make some kind of difference.
Reut Almog TalmiMay 103 minHow To establish mirroring session following domain name changeHave you ever needed to change the database mirroring partner names? One of our clients had to transfer all their servers from one domain to a new one, inclu...
Guy GlantserMay 73 minIt’s Time to Get Rid of Those Redundant IndexesIn most databases, there are redundant indexes, which only have costs, but no benefits. Here is a useful script to find them...
Guy GlantserMay 64 minSELECT TOP (3) Pre-Conference SessionsHere are my top 3 pre-conference sessions in PASS Summit 2020
Vitaly BrukMay 32 minAuto-recovery feature and how to recover unsavedDisaster recovery is one of the critical things and every IT or technology system faced with. Unfortunately, many times even our own work can be in danger. O...
Guy GlantserMay 12 minAlways On Availability Groups in Standard EditionAvailability Groups is a wonderful feature in SQL Server that provides HA/DR solutions. But what if I use Standard Edition? What do I get?
Vitaly BrukApr 301 minHow to Leverage Parallelism in SQL Server?In our last webinar, I presented how SQL Server works with Parallelism, what are the default values and what they affect.
sagi645Apr 161 minResource Governor – We’ve Got a New Sheriff in Town Sometimes an extra level of control is necessary for managing big environments’ resources. Resource Governor is here just for that, giving
Guy GlantserApr 61 minSQL Server Developer Tips That Can Save Your Ass -WebinarToday's webinar was about two very important SQL Server (and Azure SQL Database) developer tips: How to use scalar user-defined functions a
Guy GlantserMar 261 minHackorona session materialsToday I had the honor to present a webinar as part of the Hackorona event hosted by in.dev in cooperation with Microsoft. My webinar was about some important...
Eitan BluminMar 163 minThe Ultimate Compression Savings Estimation Script for an Entire Databaseדחיסת מידע ב-SQLSERVER יכולה לחסוך שטח ואף לשפר ביצועים. אבל במקרים מסוימים זה יכול לגרום יותר נזק מתועלת, וחשוב לזהות מקרים אלה.
