Get table properties in Azure SQL Database
Even in Azure SQL Database, you need to know certain things about your tables that can be hard to find. We’ll show you how to get that data.
Pay Yourself First
The biggest problem I see is the huge number of DBAs who have let themselves fall behind. Live in interview mode, and pay yourself first, and you won’t fall behind!
Coding Naked
Let’s talk about CASE tools, and why coding for databases without one feels so….exposed.
SQL maintenance is a lifecycle, not an event!
You’ve heard me talk about this many times, in so many different ways, but it’s worth repeating: SQL maintenance lifecycles are important.
People who disagree, disagree because they spend too much time firefighting and don’t have time to really think about it. Don’t know anything about SQL maintenance lifecycles? Let’s touch on a couple of points…today, we’ll cover SQL backup.
Integrity Checks are Useless*
Integrity checks have become more and more important over the years, as companies store more and more data. This data is absolutely critical, so when corruption happens, it can break a company. But in all but the smallest shops, running any kind of integrity check is all but completely useless. Unless you have Minion CheckDB.
Managing Backup Issues in Availability Groups
Let’s talk about some of the challenges that DBAs face when managing backups with Availability Groups. Then we’ll talk about solving these issues with Minion Backup.
Proper Backup Alerting
Today I’d like to talk about two topics that get overlooked quite often, the “backups” to the backup, so to speak. First up: proper backup alerting. And second, missing backup recovery.
What Really Causes Performance Problems?
Every IT shop has its problems with performance: some localized, and some that span a server, or even multiple servers. Technologists tend to treat these problems as isolated incidents – solving one, then another, and then another. This happens especially when a problem is recurring but intermittent. When a slowdown or error happens every so often, it’s far too easy to lose the big picture.
Some shops suffer from these issues for years without ever getting to the bottom of it all. So, how can you determine what really causes performance problems?
Avoid this sp_executesql issue
If you don’t use this feature very often, you can come across some unexpected sp_executeSQL issues. This time we’ll look at an sp_excuteSQL output issue.
Using SQL Server OUTPUT Parameters
Let’s talk about using SQL Server OUTPUT parameters!