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 […]
Continue readingBy 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 […]
Continue readingBy Jeffry Schwartz | Advice , Miscellaneous , SQL Administration , Windows
— By Jeff Schwartz Hyperthreading is one of those features that most IT personnel have heard about, but many do not understand exactly what it does or why it may improve or degrade the performance of their servers. Although hyperthreaded processors have been available for many years, the confusion surrounding it is as commonplace today […]
Continue readingBy 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 […]
Continue readingBy SQLRx Admin | SQL Administration , SQLRX , Tip of the Month
Available in SQL Server 2014 Enterprise Edition The Resource Governor can now restrict the number of I/O’s sent to the disk subsystem. In the past, only CPU and Memory could be throttled, but now DBAs can also throttle I/O. This gives DBAs the ability to further control those users who insist on running reports or […]
Continue readingBy 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. […]
Continue readingBy 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 […]
Continue readingBy SQLRx Admin | SQL Server , Tip of the Month
Available in all Editions of SQL Server 2014 CONNECT ANY DATABASE : Using this permission you can allow a login to connect to any database (existing or future) without having to configure connect privileges on every database. GRANT CONNECT ANY DATABASE TO sqlrx GO IMPERSONATE ANY LOGIN : This allows a login to impersonate […]
Continue readingBy 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 […]
Continue reading