All Posts by Ginger Daniel

Steps for Installing AlwaysOn Availability Groups – SQL 2019

By Ginger Daniel | Always On , Installation , SQL Administration , SQL Server

With SQL Server 2012 Microsoft introduced the AlwaysOn Availability Group feature, and since then many changes and improvements have been made.  This article is an update to our previous article https://www.sqlrx.com/steps-for-installing-sql-server-alwayson-availability-groups/ , and will cover the prerequisites and steps for installing AlwaysOn in your SQL Server 2019 environment. Prerequisites Add Windows Failover Cluster (WSFC) Install […]

Continue reading

Move Data from SQL Server to Azure Blob Storage with Incremental Changes – Part 2

By Ginger Daniel | Azure , Cloud , SQL Administration , SQL Server

In Part 1 of this series, we demonstrated how to copy a full SQL database table from a SQL Server database into an Azure Blob Storage account as a csv file.  My client needed data moved from their on premise SQL Server database to Azure, and then needed the daily incremental data changes uploaded as […]

Continue reading

Move Data from SQL Server to Azure Blob Storage with Incremental Changes – Part 1

By Ginger Daniel | Azure , Cloud , SQL Administration , SQL Development , SQL Server

One of many options for Reporting and Power BI is to use Azure Blob Storage to access source data.  Most of the documentation available online demonstrates moving data from SQL Server to an Azure Database, however my client needed data to land in Azure Blob Storage as a csv file, and needed incremental changes to […]

Continue reading

Troubleshoot SLEEP_TASK Wait Type

By Ginger Daniel | Miscellaneous , Performance Tuning , Query Tuning , SQL Development , SQL Server

Jobs on a SQL server can take milliseconds or minutes to complete depending on the size and complexity of your query and also the SQL environment on which it’s executing.  It’s important to have a baseline or at least be familiar with the normal amount of time your SQL jobs take to execute.   For a […]

Continue reading

SSRS – Keep Column Headers Visible

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 reading

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

Notification for Restored Database

By 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 reading

Inconsistent Tempdb Growth

By 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 reading

AlwaysOn – Connection Handshake Failure

By 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 reading