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 […]
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. […]
14
Jun
Jun
Structured Query Language (SQL) systems help us communicate with databases. The databases can be large and can also house very sensitive data within it. Many businesses rely on their SQL systems to keep their data safe, which is why it is vital to protect it with industry-standard security methods. A SQL server health check compiles […]
14
Jun
Jun
In this article, we will discuss a few common design decisions when defining a Schema. We’ll focus on the planning stage. There are many opinions about what is ‘best’. Here we discuss some basic guidelines which may or may not be best for your specific needs. There are two primary ways a database is used. One is Online Transaction Processing (OLTP) and the other is […]
28
Mar
Mar
The main language used to communicate with different databases is the Structured Query Language (SQL). A slow SQL application can cost your company more than money and time, but cause customer dissatisfaction and lower sales as well. There are a myriad of reasons why your SQL application runs slow. Everything from initial coding processes to […]
03
Jan
Jan
True to our core value of “Stay Curious,” we’re excited to announce that all SQLWatchmen team members will undertake over 158 hours of technical training from the SQLskills Blackbelt curriculum, SQLskills most demanding training and certification program. On top of this, we will be holding our “BlackBelt Book Club” events every two weeks. During these […]
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. […]
Have you ever made the comment to your friends or family that you are always the last to know something? Good news travels fast but bad news doesn’t always travel fast enough. When dealing with database corruption SQL Server, which is always bad news, if you are the DBA you will want to be first […]
Are you relying on manual monitoring to troubleshoot your SQL Server estate? If so, you’re probably familiar with the time and cost of running repetitive monitoring tasks. When looking for a larger number of servers, this quickly adds up. Join our upcoming webinar, “The true cost of manual monitoring”, on Tuesday, March 6, 2018. SQLWatchmen […]
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 […]