By 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 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 | SQL Administration , SQL Server
Tempdb is a system database used in SQL Server to hold 1) temporary user objects like temp tables and stored procedures, 2) internal objects like work tables used for sorting, and 3) row versions created from data modification transactions. When configuring a new SQL Server, the tempdb should be set to a size that will […]
Continue readingBy Ginger Daniel | Backup and Restore , Database Mail , SQL Administration , SQL Server
According to best practices for a SQL environment, you should never place your test or development databases on a production server. However sometimes best practices are ignored, sometimes the DBA’s advice is disregarded (ahem…), or sometimes an organization simply does not have the financial resources to spin up separate servers for testing or development. Whatever […]
Continue readingBy Ginger Daniel | SQL Administration , SQL Server , Trace Flags
Tempdb database is a system database that is shared across all databases and all connections in SQL Server. As a general rule, I configure all my client’s servers to have multiple tempdb files with consistent sizes and consistent auto growth set according to best practices. The number of tempdb files created equals the number of […]
Continue readingBy Ginger Daniel | SQL Administration , SQL Server
While doing some work on a test environment recently I realized the AlwaysOn Group was failing. (On a production system I would have had several Alerts set to notify me of any issues). The dashboard on my test instance showed that the secondary replica was not synchronizing and from clicking on the blue warning links […]
Continue readingBy Ginger Daniel | Helpful Scripts , Miscellaneous , SQL Administration , SQL Server
If you ever have a need to monitor connections to your SQL server, and any related information about the connections such as database, logins, etc., there are some DMVs that can give you tons of information. Previously you might have used the sys.sysprocesses table to derive much of this information, but this is being deprecated […]
Continue readingBy Ginger Daniel | Backup and Restore , Log Shipping , SQL Administration , SQL Server
For years the SQL Agent service account on my client’s SQL Server instance ran the Maintenance Plans and SQL Agent jobs with no issues. Many of the SQL databases were set to Full recovery model, and Tlog backups executed on regular bases with no problems. The client decided to migrate to new hardware in a […]
Continue readingBy Ginger Daniel | SQL Administration , SQL Server
It is not uncommon for a DBA or other IT staff to set up AlwaysOn in a SQL environment and later leave the company. We ran into this recently with a client and were asked to delete the previous employee’s login from everything SQL related. We were able to remove the login from all databases […]
Continue reading