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 readingBy 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 readingBy 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 readingBy 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 readingBy Lori Brown | Intermediate , Miscellaneous , SQL Administration , SQL Server
— by Lori Brown @SQLSupahStah While trying to add a database to an existing AlwaysOn Availability Group (AG), I was having difficulty making a connection from the primary replica to the secondary replica. The availability group was functioning but as I tried to add a database to it, my connection to the secondary replica was […]
Continue readingBy SQLRx Admin | Intermediate , Performance Tuning , SQL Server , Tip of the Month
SQL Server Performance Tuning: New function in SQL 2016: sys.dm_exec_function_stats Returns performance statistics for cached functions. Returns information about scalar functions, including in-memory functions and CLR scalar functions but not about table valued functions. The view returns one row for each cached function plan, and the lifetime of the row is as long as the […]
Continue readingBy Jeffry Schwartz | Expert , Performance Tuning , SQL Development , SQL Server
— By Jeffry Schwartz Microsoft introduced Extended Events, a.k.a. XEvents, in SQL Server 2008 to aid in the analysis of performance problems. Both the capabilities and syntax were changed significantly on SQL Server 2012, and new (and very important) features were added in SQL Server 2014. Therefore, the focus of this document will be on […]
Continue readingBy SQLRx Admin | Intermediate , SQL Server , Tip of the Month
January 2016 Tip of the Month: Using sys.dm_server_memory_dumps to find SQL memory dumps. When SQL experiences a serious issue it will often dump the contents of its memory to disk. This is known as a memory dump and it does generate files that are usually located in the Logs folder. I often find that many […]
Continue readingBy Ginger Daniel | Expert , SQL Administration , SQL Server
– -by Ginger Keys Occasionally mistakes happen, things get deleted, or hardware fails. Your end users may be complaining that the application is not working or pulling up any data… or you may open SQL Management Studio and see that the database is simply unavailable. What happened!? I have encountered a situation where an inexperienced […]
Continue reading