By Lori Brown | Helpful Scripts , SQL Administration , SQL Maintenance , SQL Server
I ran into a situation where we were working on a migration and had been directed to put all databases into FULL recovery model in anticipation of using log shipping to push databases to the new server. Once we are ready to go live on the new server the plan was to ship the last […]
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 SQLRx Admin | ColumnStore , SQL Administration , SQL Server , Tip of the Month
Find out if any of your tables contain special columnstore or spatial indexes. Columnstore indexes organizes the data in columns instead of rows like traditional indexes and can increase performance on large data sets as found in data warehouses. Spatial indexes are a special type of index on a spatial column such as geometry or […]
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 readingBy Lori Brown | Backup and Restore , Beginner , Helpful Scripts , SQL Administration , SQL Server
We recently started using a third party software to do our in-house SQL backups so that the backup files are stored in a redundant and safe place. To confirm that the software was indeed compressing backups as it stated it would, we wanted to see what each backup size actually was in SQL so that […]
Continue readingBy Ginger Daniel | Encryption , SQL Administration , SQL Server
It is common knowledge that encrypting a database causes degraded performance in a SQL server. In an AlwaysOn environment performance can be even more sluggish because there is the extra element of data replication latency. How much difference does it really make? Of course the answer is “it depends” on your environment and your workload. […]
Continue readingBy SQLRx Admin | Database Mail , SQL Administration , SQL Server , Tip of the Month
If you are planning on installing SQL Server 2016, take note that you need SP1 or .NET 3.5 for Database Mail. Database Mail is a very important and widely used part of SQL that allows us to send e-mail. I found this when mail could not be sent and the Database Mail log was empty […]
Continue readingBy Ginger Daniel | Cloud , SQL Administration , SQL Server , Stretch Database
Microsoft has added another cool feature in SQL Server 2016 – Stretch databases – that provides a cost effective way to store historical or ‘cold’ data. This feature is ideal for transactional databases with large amounts of cold data, typically stored in a small number of tables. Stretching is better than the traditional method […]
Continue readingBy Lori Brown | Installation , SQL 2017 , SQL Administration , SQL Server
SQL Server 2017 is available as a CTP for testing (https://www.microsoft.com/en-us/sql-server/sql-server-2017) and is able to be installed on a system running Linux. Because I have done all of my professional work on Windows systems, the leap to a Linux system was a bit of a stretch. I learned that while Linux is the OS kernel, […]
Continue reading