The Daily Dose

SQL 2016 SSMS Download Location

By SQLRx Admin | Installation , SQL Administration , SQL Server

Now that SQL Server 2016 has been released (https://blog.sqlrx.com/2016/06/01/sql-server-2016-rtm-available/ ), DBA’s are going to notice that the Management Studio tools are not in the list of options to install. Starting in SQL 2016, SSMS is a separate download and install. You can find the download at: https://msdn.microsoft.com/library/mt238290.aspx The install notes say that it can be […]

Continue reading

SQL Server 2016 RTM Available!!

By SQLRx Admin | Advice , Installation , Miscellaneous , SQL Server , Upgrade

In case you live under a rock or were at the dentist, Microsoft announced that SQL Server 2016 has been made generally available today June 1, 2016. See: https://blogs.technet.microsoft.com/dataplatforminsider/2016/06/01/sql-server-2016-is-generally-available-today/ Pricing is as follows: A handy feature comparison of previous versions of SQL can be located here: https://www.microsoft.com/en-us/server-cloud/products/sql-server/comparison.aspx SQL 2016 feature comparison between editions can be […]

Continue reading

Finding overlapping times with the LAG Function

By Jeffry Schwartz | Expert , SQL Development , SQL Server

— by Jeffry Schwartz Some functions in SQL are a little difficult to use and understand. I was recently using the LAG function to shed some light on a performance issue, so I thought I would show how I used it and the results it produced in a way that is easy to understand.  At […]

Continue reading

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