By Lori Brown | Helpful Scripts , Miscellaneous , SQL Administration , SQL Maintenance , SQL Server
This might be kind of basic but since I am working on a comprehensive script to discover things that a DBA really needs to know about, I made a couple of queries that will produce a list of the databases that have multiple files along with the locations of the physical files. One query finds […]
Continue readingBy Lori Brown | Installation , SQL Administration , SQL Server , Upgrade
I was recently performing an in-place upgrade of SQL 2008 R2 to SQL 2014 on one of my client’s servers. I have done a ton of successful and uneventful in-place upgrades and was surprised when the upgrade failed with the error message: “Failed to create a new folder ‘X:\SQLBackups’. The specified path is invalid (for […]
Continue readingBy Ginger Daniel | SQL Development , SQL Server , SSRS
When scrolling through the pages of a SQL Server Reporting Services (SSRS) report, it is very useful to be able to see the column headers throughout the report. So let’s say you have successfully created an SSRS report using Visual Studio, and everything looks wonderful…except the headers on your columns disappear when you scroll down […]
Continue readingBy Lori Brown | Dependencies , Object Information , SQL Administration , SQL Development , SQL Server
A little while back I wrote a post going over sp_help in a beginning effort to find table dependency information. https://www.sqlrx.com/using-sp_help-to-find-object-dependencies/. That expanded to reviewing sys.dm_sql_referenced_entities & sys.dm_sql_referenced_entities (https://www.sqlrx.com/finding_things_sql_that_reference_a_table/ & https://www.sqlrx.com/how-to-find-the-objects-and-columns-a-stored-procedure-or-view-uses/ ) and sys.sql_expression_dependencies (https://www.sqlrx.com/using-sys-sql_expression_dependencies-as-a-single-source-to-find-referenced-and-referencing-objects/ ) Now I want to loop back just a bit and expand on more information that is found in sp_help […]
Continue readingBy Lori Brown | Dependencies , Object Information , SQL Administration , SQL Development , SQL Server
I thought I would continue to expand on ways to view dependencies. This post will give you an alternate way to find things referencing tables and finding things that are referenced by a stored procedure or view after my previous posts on the subject. See these (https://www.sqlrx.com/finding_things_sql_that_reference_a_table/ & https://www.sqlrx.com/how-to-find-the-objects-and-columns-a-stored-procedure-or-view-uses/ ) A different way to find […]
Continue readingBy 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 readingBy 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 readingBy Lori Brown | Performance Tuning , SQL Administration , SQL Server
I occasionally come across some pretty good sized databases that are set up with a single data file. We recently have been working with a client to break up their single data file into multiple data files so that we can spread them over several different LUNs and so that they can take advantage of […]
Continue readingBy 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