People all over the database world were in for a stunner this week when Microsoft announced that they will be supporting SQL Server installations...
Thinking Strategically about SQL Server on Linux
read more
SQL Server
A 2016 future so bright you gotta wear shades?
If you are a DBA or developer working around Microsoft SQL Server, you have heard lots about SQL Server 2016. (If not, you might be stuck in a...
5 Things You Can Do in SQL Diagnostic Manager That You May Not Know
There is a library of ‘how-to’ videos created for SQL Diagnostic Manager showcasing how to perform certain tasks and how to troubleshoot specific...
Configuring Query Monitoring in SQL Diagnostic Manager 10.0
The SQL Diagnostic Manager Query Monitor is a powerful feature that has the capability of greatly reducing the time that it takes to identify...
Creating and Identifying Deadlocks in SQL Server
This video from John Sterrett shows you how to create a deadlock and how you can proactively monitor deadlocks using the default system_health...
10 Quick Tips & Tricks for SQL Server Developers
Here are 10 quick SQL Server tips and tricks for database developers compiled by SQL Server expert Pinal Dave. For inefficient query plans: Check...
10 Consejos y trucos rápidos para SQL Server Desarrolladores
Aquí hay 10 consejos de SQL Server rápidas y trucos para los desarrolladores de bases de datos recopilados por expertos de SQL Server Pinal de Dave....
DBA Triage Using Heatmaps
The word “triage” for me brings up images from MASH re-runs; or memories of emergency room visits with nurses quickly deciding whether you are...
T-SQL Tuesday #67: Introduction to Idera SQL XEvent Profiler
This month’s #tsql2sday is hosted by the delightful Jes Borland over at Less Than Dot, on the topic of XEvents. When I saw this come up on...
Identifying the cause of tempdb autogrowth using SQL Diagnostic Manager
Autogrowth in your tempdb database may not seem like such a bad thing, but it can cause quite a headache if it’s uncontrolled. Unplanned...
MSSQLTips Reviews Top New SQL Free Tools from Idera
Most of you are aware of the variety of free tools Idera offers to the SQL community to help with SQL Server tasks. Some of you have even mentioned...
Tinker, Tailor, Developer, DBA
Tinker, Tailor, Developer, DBA is not intended as a pitch on a slightly less harrowing book or movie than the John Le Carre classic. ...
Backup and Restore of Windows Azure SQL Databases
A growing number of companies have already moved some level of applications and data to the cloud. An equally growing number of companies are still...
New SQL Suites available now!
Today Idera announces a set of three exciting new bundles in addition to its existing popular SQL Management Suite (formerly called SQL Suite)....
Team DBA and Collaboration
In previous blog posts I have explored the relevance of the DBA position itself in business and the unique ways that SQL Server DBAs tend to...
Updating SQL Elements health check intervals
Periodically when I am speaking to users of SQL Elements I receive a request related to changing the interval at which health checks are run for...
Holiday Time Resources
Have a little free time over the holidays while providing coverage for work, or like to brush up on technical information? In addition to the many...
SQL Safe and AlwaysOn Availability Groups
With the release of version 7.4 in August, SQL Safe added AlwaysOn Availability Group support by taking into account the preferred replica when...
Altering wait categories in SQL Diagnostic Manager
SQL Diagnostic Manager ships with built-in categorization of wait types which are encountered in monitoring. These categories are used on both the...
Did you choose to be a DBA?
We have had this survey question and a few others on the community for a few months and thought we would share some of the results. This was a brief...
3 Cool SQL Server TSQL Snippets for Productivity
Nobody would want to shy away from some help. This is second to human nature and we never try to talk it out explicitly. When at work, if we can...
5 Different Ways to Start SQL Server Services
If nothing works, then a restart works. This is the exact sentiments that an Administrator has when it comes to working with software. If you are...
SQL Traffic Accelerator as a DB performance tool
We get questions from time to time from folks asking what SQL Traffic Accelerator does for DBAs since it sounds like a network monitoring tool....
Performance Improvements with SQL Server 2014
Whenever there is new model of any vehicle launched in the market, it is expected it should have some enhancements or new features which would make...