The Daily Dose

Correlate Performance Spikes with SQL Profiler and Perfmon

By 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 reading

How SQLRX Can Help You When Tools Do Not

By 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 reading

Load Windows Event Log Errors into a SQL Table

By Lori Brown | Helpful Scripts , Intermediate , Miscellaneous , SQL Administration , SQL Server , Windows

–By Lori Brown @SQLSupahStah Part of being a proactive DBA is to get information on what is going on at the server level as well as at the SQL level. We know that the Windows Event logs are around but I find that not many DBA’s check them regularly. You can make this easier by […]

Continue reading

Database Mail Error – SQL Server

By Ginger Daniel | Beginner , Miscellaneous , SQL Administration , SQL Server

–By Ginger Keys Database Mail is a feature of SQL Server that sends email from the SQL Server database engine to SMTP servers. It can be used to notify administrators when events happen in SQL server, such as job failures, failover notifications, or any other event deemed important in your environment. You can also use […]

Continue reading

@@SERVERNAME Returns Old Name or NULL

By Ginger Daniel | Intermediate , Miscellaneous , SQL Administration , SQL Server

— by Ginger Keys   Recently a client of mine moved their production SQL Server Cluster to a new physical environment. When the time came to ‘go-live’ with the new environment, the client wanted the new SQL cluster name and IP address (SQLCLUSTERTEMP) to be renamed to the original, legacy name and IP address (SQLCLUSTER). […]

Continue reading

SSISDB Benefits and Configuration

By Lori Brown | Beginner , SQL Administration , SQL Server

Lots of people are using the SSIS catalog database, SSISDB, for SSIS packages. Actually, using the SSIS catalog is best practice but there are still some shops that use File System Packages. These shops should really consider migrating to the SSIS catalog. Some benefits are: Versioning: Version history is kept allowing developers to see list […]

Continue reading

March 2016 Tip of the Month -Full Text Indexing – Clean up those log files!

By SQLRx Admin | Advice , Beginner , Miscellaneous , SQL Administration , SQL Server , Tip of the Month

If you have Full Text catalogs set up in your databases you may notice that inside your log folder there will be lots of files named SQLFTxxxxxxxxxxxx.LOG. These are known as crawl logs which are designed to log information on the full text indexing. These logs can really pile up and there is no automated […]

Continue reading

Using Ranking Functions to Partition and Order Unfamiliar Data

By Jeffry Schwartz | Expert , Miscellaneous , SQL Development , SQL Server , Windows

The Problem How many times have you had to subdivide, group, rank, and organize data when you knew very little about the data itself except for the meanings of the columns? This dilemma is one that the members of the SQLRx team encounter frequently. When a customer requests help with a performance problem, we often […]

Continue reading

Dynamic Data Masking – SQL Server 2016

By Ginger Daniel | Intermediate , SQL Administration , SQL Development , SQL Server

–by Ginger Keys Dynamic Data Masking is a SQL Server 2016 feature that can be deployed as part of your overall security strategy. Data masking is not intended as a primary security solution, but provides a way to obfuscate or hide characters in data such as social security numbers, credit card numbers, email addresses, and […]

Continue reading