#ORACLE APEX SQL TOOLS FREE#
Monitor your servers for free: Quest Spotlight Basic – if your boss won’t spring for monitoring software, this is a free way to get a lot of useful analysis. If your databases are 1TB or larger, you should check this out. This free tool helps you break the work into chunks and offload corruption checking easier.
#ORACLE APEX SQL TOOLS HOW TO#
How to check for corruption at scale: Minion CheckDB – as your database volume grows, it can be hard to run CHECKDB frequently enough. If you’re managing 50 or more SQL Servers by yourself, you need to drop what you’re doing and leverage these tools.
How to manage more SQL Servers in less time: DBAtools.io– a collection of PowerShell cmdlets and a vibrant community of contributors. Click on the tabs under “Our books by topic” and you can see more books on SQL DBA topics. The site is just a little confusing – there are more books than you see at first.
#ORACLE APEX SQL TOOLS PDF#
How to learn with free books – Redgate Books– you can download the PDF versions of their books absolutely free, including material on execution plans, source control, troubleshooting, and more. Over time, though, you’re going to graduate to needing something more powerful, and then it’s time to say hola to Ola. How to protect your databases: Ola Hallengren’s maintenance scripts – the built-in maintenance plans are a good first step at getting backups, corruption, and index maintenance. How to analyze their query plans: SentryOne Plan Explorer – when you’re struggling to understand why a query is slow, does it ever feel like SQL Server is fighting you back? Almost like it’s purposely trying to hide known anti-patterns and problems in the query plans? Plan Explorer surfaces them for you. How to see what queries have run recently: First Responder Kit – after the load test passes, let’s say someone asks me, “Hey, what queries were causing a problem earlier this morning?” I’ll show you how the open source sp_BlitzCache gives you the answers. Instead, I’ll run amazing tool, sp_WhoIsActive, and I’ll show you my favorite parameters. How to see what queries are running: sp_WhoIsActive – during the webcast, I’ll want to see what queries are causing me problems right now, and I won’t be firing up Activity Monitor. I publish small (10GB), medium (50GB), and large (312GB) versions. How to run demos: Stack Overflow database – the popular Q&A site gives away your questions, answers, comments, etc in an open format, and I import it into a SQL Server database you can use for learning T-SQL and indexing. In the webcast, I’ll be using a set of free random workload scripts which run against the… How to run a load tests: SQLQueryStress – an open source app originally written by Adam Machanic, and now maintained by Erik Ejlskov Jensen on Github. In a one-hour session today for the PASS DBA Fundamentals online user group (free to join, of course), I showed some off. The SQL Server community has banded together and built a bunch of cool stuff to help you do your job easier. You’re responsible for managing and troubleshooting SQL Server.
0 kommentar(er)
