By Lori Brown | SQLRX
If you have visited us within the past year, you may have noticed that we have been pretty quiet on our blog and may have wondered what happened. Well…..we had some technical difficulties (our syntax highlighter plugin stopped working), then we got super busy, then came the holidays, then came COVID. I know, Excuses…Excuses….Excuses. Well, […]
Continue readingBy Lisa Dominy | Advice , Cloud , Partners , SQL Server , SQLRX
Whether you currently host your SQL Server in the Cloud or are considering moving it to the cloud, here are a few guidelines that can lead you to select the right hosting provider for your specific requirements. Set the stage for a tech discussion. Familiarize yourself with your current technology profile so you can have […]
Continue readingBy Ginger Daniel | Advice , Miscellaneous , SQL Administration , SQL Server , SQLRX , Windows
-by Ginger Keys We are going to re-promote this subject because it is still so relevant. All too often we run into people who are in a panic after looking at Task Manager to try to diagnose SQL stress. They seem to become very worried when looking at how much memory SQL uses not realizing […]
Continue readingBy Lori Brown | Offer , Performance Tuning , SQL Administration , SQL Server , SQLRX
SQLRx (@SQLRX) is proud to announce that two of our resident SQL Experts will be presenting sessions at SQL Saturday #515 in Baton Rouge, LA on August 6, 2016. If you have not signed up to attend, you are going to miss out!! http://www.sqlsaturday.com/515/eventhome.aspx Lori Brown (@SQLSupahStah) will give a lesson on how to be […]
Continue readingBy Ginger Daniel | Intermediate , Perfmon , Performance Tuning , SQL Server , SQLRX
–by Ginger Keys Have you ever watched performance metrics in Performance Monitor (Perfmon) and wondered which SQL Server activities were causing those spikes? SQLRx offers a Microsoft Partner-of-the-Year award-winning service that will correlate all performance metrics on your server with very little overhead, and will pinpoint with precision, right down to a line of code […]
Continue readingBy SQLRx Admin | Advice , Miscellaneous , Offer , SQL Server , SQLRX
For those of you who visit our humble blog from time to time and have never actually checked out our website (www.sqlrx.com) to get acquainted with what we do, please allow me to check that box for you. SQLRX is part of a Dallas, Texas based consulting company called Integrated Services Inc (ISI). The SQLRX […]
Continue readingBy Lori Brown | Helpful Scripts , SQL Administration , SQL Server , SQLRX
— By Lori Brown @SQLSupahStah I recently had someone contact me who needed to figure out when a user’s database permissions were changed. Apparently, a domain account that had been working for months doing things in a specific database suddenly could not do its normal work. On checking, we found that all of the user’s […]
Continue readingBy SQLRx Admin | SQL Administration , SQLRX , Tip of the Month
Available in SQL Server 2014 Enterprise Edition The Resource Governor can now restrict the number of I/O’s sent to the disk subsystem. In the past, only CPU and Memory could be throttled, but now DBAs can also throttle I/O. This gives DBAs the ability to further control those users who insist on running reports or […]
Continue readingBy Lori Brown | Advice , Budgeting , Offer , SQL Server , SQLRX
— By Lori Brown @SQLSupahStah This is a bit off from our normal technical blog posts but, hey, if you can’t go out on a limb on your own blog, what good is it? After doing cleanup on systems over the years, I started thinking about why some servers seem to be so poorly configured. […]
Continue reading