The audience for this post are technologists who have some exposure to provisioning resources in the Azure portal, but haven’t yet started doing scripted deployments. The purpose of this post is to get started with understanding and customizing the contents of an ARM template (as opposed to doing the one-click deployment…
This month's T-SQL Tuesday is hosted by Raul Gonzalez (@SQLDoubleG), and is about Lessons Learned the Hard Way. Now, I've learned many lessons the hard way. When I started my career and transitioned from web design and server-side scripting into more focus on SQL Server, I bought a whole bunch of books; my favorites were…
When you have a large number of targets to monitor in the SentryOne environment, it can be a bit daunting to set up. Graphical interfaces are nice in that you can step through setup processes and get immediate feedback, but if you have a lot of servers, the process can be tedious. In my last blog post (Targeting Server…
In a previous life, I was responsible for a production system with somewhere around 1,500 roughly identical databases, one per client. I called it a multi-tenant system for years, but that causes strife, because many people only think of multi-tenant as a database-level concept rather than an instance-level concept. This…
On June 19th, @kekline and I presented a webinar called "Tales from Building a SQL Server in Azure." In this session, we shared experiences and lessons learned from a recent migration of our business intelligence and data warehousing environment to Azure. Key discussion topics in the webinar: * Deciding between SQL Server…
As the gatekeeper of the Advisory Conditions Packs at SentryOne, I sometimes receive questions about changing or turning off conditions in a pack to better serve our customers' unique requirements. While we strive to provide conditions that are useful to all clients, we understand that in the world of SQL Server, "it…
I was looking through SQL Sentry blog posts and realized that, while we have several posts around creating Advisory Conditions, I couldn't find one that covers most everything. My plan for this post is to cover the whole kit and kaboodle, but I'll be referring to the existing blogs so that this does not become War and…
One of the sleeper features of our free Plan Explorer is its ability to open and view SQL Server deadlocks. The view is designed to clearly present all of the details you need to troubleshoot a deadlock, without overwhelming you with less helpful elements like owner IDs and transaction descriptors. The deadlock diagram is…
SQL Sentry comes preconfigured with well over a hundred alerting conditions for failures, offline servers, long running queries, and more. You may also be aware of SentryOne’s Advisory Conditions. This advanced alerting and response system allows you to truly customize the product to respond to any condition with complex…
Event log management is simple and centralized in SQL Sentry. Events across all of your monitored servers come together in one tool, making management faster. For example, correlating SQL Server performance issues with items in Windows Event Logs is painless. "Outlook-style" Calendar views provide a familiar way of…
It looks like you're new here. Sign in or register to get started.