Many companies rely on the job scheduling and alerting services provided with the native SQL Server Agent service. From backups to SSRS subscription to SSIS packages, SQL Server Agent has the capability to run many types of business critical tasks on a regular schedule or can be programmatically triggered to start from other processes as […]
Tag Archives: SQL server
18
Jul
Jul
If you are just getting started in your role as a SQL Server DBA, at some point in your career you are going to have to do some work with SQL Server system databases. That is, unless you are reading this in the year 2025 when all databases will be managed bots in the Cumuloverse. […]
Coming April 11 – 12, 2018. InnoTech San Antonio, the Business & Technology Innovation Conference & Exposition, creates an environment where education, innovation, peer-to-peer networking and the latest technology and business solutions are all available specifically for IT professionals. Last year, over 1500 business and technology professionals converged for the annual InnoTech San Antonio event. […]
SQL Server has a bounty of self-diagnostic data that any good DBA can monitor and analyze. This analysis is often triggered by an unexpected event like queries that begin to run longer than usual or a spike in CPU utilization. Finding the root cause of such events is not always easy but through a simple […]
Unless you have been away on an extended, off-the-grid vacation for the first part of 2018 chances are you have heard about and are preparing for the Meltdown and Spectre vulnerabilities. The news hit the streets before a planned public announcement could be made by impacted companies, Intel, Apple and Microsoft to name a few. […]
We wanted to remind everyone that this Thursday is the much anticipated InnoTech Austin IT event. If you haven’t registered yet, keep reading to see how you can attend for free. Come Meet Us and RedGate Not only are we looking forward to the event, but are very excited to announce that one of our partners, RedGate, will be […]
Technical communities are thriving and the knowledge they provide to professionals is immense. In the SQL Server community especially, countless blog sites, forum posts, tweets, webinars and white papers exist that help DBAs solve tough problems every day and we are all fortunate to have such information available to us with a simple Web search. Sometimes, […]
We are very excited to announce that SQLWatchmen is now a Redgate Certified Partner. For those unfamiliar with Redgate, they are a leading provider of software for professionals working on the Microsoft data platform. Our favorite product from Redgate is their SQL Toolbelt. This suite of tools helps users implement DevOps best practice for their databases, […]
You know the old joke that goes, “A DBA walks into a bar, sees some friends at a couple of tables and asks if he can join them.”? Well, as DBAs we are used to dealing with tables. Whether the data comes from a log file, trace file, or XML, we want to turn it […]