Helpful Scripts Archives - Page 4 of 5

Oct 08

AlwaysOn Availability Groups – Enable or Disable Jobs on Failover

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

— By Lori Brown @SQLSupahStah After reading up on AlwaysOn Monitoring and Alerting (http://blog.sqlrx.com/2015/08/27/alwayson-monitoring-and-alerting/), I was asked to come up with a way to automatically enable jobs that may only need to run on the primary replica of an availability group. Requirements were that on failover of an AlwaysOn Availability Group some jobs should be […]

Sep 24

New or Changed Table Alert with DDL Triggers

By Lori Brown | Helpful Scripts , SQL Administration , SQL Server

— By Lori Brown @SQLSupahStah If you are the usual DBA, you are often the last person to know when something new has been added to the databases you are managing. After finding that some people in an organization were abusing their access to a certain database, I decided to create a TSQL DDL trigger […]

Sep 10

SQL Cluster Failover or Restart Notification

By Lori Brown | Helpful Scripts , SQL Administration , SQL Server

— by Lori Brown @SQLSupahStah Since I manage several SQL clusters, I came up with a way to get a notification that the cluster may have failed over. This failover notification was created in self-defense because often times no one from the system administrators team will tell the DBA when work is being done or […]

Aug 27

AlwaysOn – Monitoring and Alerting

By Ginger Daniel | Helpful Scripts , SQL Administration , SQL Server

–by Ginger Keys AlwaysOn Availability Groups is a great new feature of SQL 2012 and 2014. This feature is a combination of database mirroring and failover clustering, and it provides a strong level of high availability and disaster recovery; however there is no straightforward monitoring/alerting processes to go along with this new functionality. It is […]

Aug 07

Find Permission Changes In The Default Trace

By 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 […]

Jul 09

SQL Server Column Level Encryption and Query Performance

By Lori Brown | Helpful Scripts , SQL Administration , SQL Development , SQL Server

— by Lori Brown @SQLSupahStah In my last blog post I showed how to implement TDE encryption on a database and the performance impact of doing so. https://sqlrx.wordpress.com/2015/06/25/sql-server-tde-encryption-and-query-performance/ Today’s post will show how to implement encryption at the column level and the performance impact as well as a way to help make queries using encrypted […]

Jun 03

Changes to System Views in SQL 2014

By Lori Brown | Helpful Scripts , Miscellaneous , Performance Tuning , SQL Server , Tip of the Month

There are two new system views and two system views that have new columns added in SQL 2014. Most notable is sys.databases since this is widely used. sys.xml_indexes – Has 3 new columns: xml_index_type, xml_index_type_description, and path_id. https://msdn.microsoft.com/en-us/library/ms176003.aspx sys.databases – Has 3 new columns: is_auto_create_stats_incremental_on, is_query_store_on, and resource_pool_id. https://msdn.microsoft.com/en-us/library/ms178534.aspx sys.column_store_row_groups – New view. Provides clustered […]

May 06

Generate Random Column Values to Populate a Table for Testing

By Lori Brown | Helpful Scripts , Miscellaneous , SQL Server , Tip of the Month

Recently I had to do some R&D for a project and needed to generate a large table to test performance on. Since it is important to test queries on large data sets I thought that I would post how I populated a few data types in my table. To test query results I decided that […]

Jun 16

Find out when statistics were last updated.

By SQLRx Admin | Helpful Scripts , SQL Server , Tip of the Month

Your SQL database uses statistics to choose the most efficient plan for retrieving or updating data, so you want them accurate and up-to-date. Otherwise, it can cause the SQL Server engine to take the wrong path, and taking the wrong path means slower performance. Check out the code below to see when your stats were last […]

« Previous 1 2 3 4 5 Next »

Category Archives for "Helpful Scripts"