Category Archives for "SQL Server"

Aug 16

Find the Last Time Databases or Logs were Restored

By Lori Brown | Backup and Restore , Helpful Scripts , Log Shipping , SQL Administration , SQL Maintenance , SQL Server

I have a client that uses a lot of disconnected log shipping on a few servers.  They do this because they want to have a copy of their database that is actually hosted by software vendors for reporting purposes.  So, disconnected log shipping it is!  We pull down files that have been FTP’d to the […]

Continue reading
Aug 09

AlwaysOn – Create a Basic Availability Group

By Ginger Daniel | Always On , SQL 2016 , SQL 2017 , SQL Administration , SQL Server

AlwaysOn Basic Availability Groups (BAGs) are available with SQL Server 2016 and 2017 Standard edition.  The functionality is generally the same as database mirroring (which has been deprecated).  This feature replicates transactions to a database on a secondary server, and is useful for disaster recovery should something happen to the primary server. If you have […]

Continue reading
Jul 19

How To Find the Objects and Columns a Stored Procedure or View Uses

By Lori Brown | Dependencies , Object Information , SQL Administration , SQL Development , SQL Server

In my last post I covered finding objects that reference another object using the dmf, sys.dm_sql_referencing_entities.  (https://www.sqlrx.com/finding_things_sql_that_reference_a_table/ )  Now let’s reverse that and find what objects are referenced in stored procedures or views.  When updates are needed to business logic often that happens in these objects.  If the stored procedures or views are large with […]

Continue reading
May 17

SSMS Shortcuts

By Lori Brown | SQL Development , SQL Server

Thought I would post some quick helpful things like shortcuts in SSMS. There is a link to a comprehensive list of keyboard shortcuts for SSMS at the end of this post. There is more than just ctrl-c & crtl-v out there!! Here are my fav’s – https://docs.microsoft.com/en-us/sql/ssms/sql-server-management-studio-keyboard-shortcuts For more information about blog posts, concepts and […]

Continue reading
May 10

Index REORGANIZE Generates Out of Space Messages

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

I was doing some performance analysis at a client where we captured a traditional SQL trace.  Our client has SQL 2016 Enterprise that is fully patched up and uses Ola Hallengren’s IndexOptimize (https://ola.hallengren.com/) stored proc to do nightly index maintenance.  While the index maintenance ran, we caught over a hundred thousand Error 1105, Severity 17, […]

Continue reading
>