By Lisa Dominy | Advice , Cloud , Partners , SQL Server , SQLRX
Whether you currently host your SQL Server in the Cloud or are considering moving it to the cloud, here are a few guidelines that can lead you to select the right hosting provider for your specific requirements. Set the stage for a tech discussion. Familiarize yourself with your current technology profile so you can have […]
Continue readingBy SQLRx Admin | Beginner , Helpful Scripts , SQL Administration , SQL Server , Tip of the Month
Find out if any of your tables are compressed in your database using the query below. Compressed tables can save space and make queries run faster. — Compressed Tables select distinct t.name AS CompressedTables from sys.partitions p inner join sys.tables t on p.object_id = t.object_id where p.data_compression > 0 If you don’t have any tables […]
Continue readingBy Jeffry Schwartz | Missing Indexes , Performance Tuning , Query Tuning , SQL Development , SQL Server
Overview Most analysts are familiar with missing index recommendations provided by SQL Server when query plans are displayed within SSMS or reported by various missing index DMVs. Several questions arise concerning these recommendations: What determines whether a column becomes a key or included in the new index? Where does the ordering of the included columns […]
Continue readingBy Ginger Daniel | Encryption , SQL 2016 , SQL Administration , SQL Server
In the AlwaysOn 2016 release, there are several enhancements that have improved manageability, scalability, and availability. One of the enhancements is the ability to add encrypted databases to an AlwaysOn group. Encrypted databases were allowed in earlier versions of AlwaysOn, however they could not be accessed if there was a failover to a secondary replica […]
Continue readingBy Lori Brown | CTP , SQL 2017 , SQL Server
–By Lori Brown @SQLSupahStah SQL Server 2017 is rolling our way like a big ole train. And, with the new features that are going to be available there may be quite a few shops that want to jump onboard. As of this writing SQL Server 2017 CTP 2.1 is available for download and testing. (https://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2017-ctp/ […]
Continue readingBy Ginger Daniel | SQL 2016 , SQL Administration , SQL Server
–By Ginger Keys SQL Server 2016 provides some awesome new enhancements and features, especially in Enterprise Edition. One of the new features relating to AlwaysOn is Direct Seeding. Good stuff – No more time consuming backup and restore Direct Seeding allows you to initialize the databases to your secondary replica(s) without having to configure a […]
Continue readingBy Lori Brown | Beginner , Helpful Scripts , Partitions , SQL Administration , SQL Server , Tip of the Month
Here is a good way to find out if any of your tables are partitioned in your database using the query below. It is important to know so that you can find out how the tables are partitioned. — Partitioned Tables SELECT DISTINCT t.name AS ParitionedTables FROM sys.partitions p INNER JOIN sys.tables t ON p.object_id […]
Continue readingBy Lori Brown | Expert , Performance Tuning , Security , SQL Administration , SQL Server
If you have ever wondered what happens when you mistakenly enable Common Criteria compliance in SQL, well wonder no more!! We have a client who has no idea how or when Common Criteria was enabled on their production system. All they know is that performance has been slowly degrading. After collecting performance data, we found […]
Continue readingBy Lori Brown | Expert , SQL 2016 , SQL Administration , SQL Server , Trace Flags
I came across something today that I did not know existed in AG’s, Automatic Seeding. This allows SQL to automatically create the secondary replicas for all databases in an AG. Pretty cool!! So if you set things up correctly when you set up your AG’s, you don’t have to worry about backing up databases and […]
Continue reading