Lori Brown, Author at SQLRx

About the Author

Lori is an avid SQL enthusiast and general nerd and coffee nut. She has been working for SQLRX for 19 years and has been working with SQL in general for 27 years. Yup...she is an old hand at this stuff.

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

Oct 06

Tip of the Month: Buffer Pool Extension

By Lori Brown | SQL Administration , SQL Server , Tip of the Month

— By Lori Brown @SQLSupahStah Available in SQL Server 2014 Enterprise Edition and Standard Edition x64 only Buffer Pool Extension is a way to use solid state disks (SSD) as nonvolatile RAM (NvRAM) instead of memory. It reduces latency. It stores clean or committed pages only so there is no risk of data loss and […]

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

Sep 03

Tip of the Month: WAIT_AT_LOW_PRIORITY option for Index Rebuilds

By Lori Brown | SQL Administration , SQL Maintenance , SQL Server , Tip of the Month

— By Lori Brown @SQLSupahStah Available in SQL Server 2014 Enterprise Edition since can only be done using ONLINE rebuilds. Index rebuilds have been enhanced with the WAIT_AT_LOW_PRIORITY option. It is used to set the duration in minutes to wait as well as behavior when blocking happens. When setting WAIT_AT_LOW_PRIORITY you also must set MAX_DURATION […]

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 23

Do You Know When To Ask For Help?

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

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

Jul 02

Large MSDB Database From sysmaintplan_logdetail Table

By Lori Brown | Miscellaneous , SQL Administration , SQL Maintenance , SQL Server

— By Lori Brown @SQLSupahStah I recently received a panicked call from a client who had a SQL instance go down because the server’s C drive was full. As the guy looked he found that the msdb database file was 31 GB and was consuming all of the free space on the OS drive causing […]

« Previous 1 … 7 8 9 10 Next »

All Posts by Lori Brown

About the Author