Moving Encrypted Data to Azure SQL Database
Learn how you can move encrypted data from on premises SQL Server to Azure SQL Database.
2019-11-26
1,027 reads
Articles
Introduction to the Partition By Window Function
Window functions can be life savers by making a complicated SQL calculation easy. A window function combines that logic and provides row by row or window by window feedback. Read on to learn more!
2019-11-26
Making the switch to SQL Monitor
Australia and New Zealand’s leading cloud account software provider Xero needed a cost-effective monitoring solution with better features and coverage. Read Xero’s story about how they switched from their old monitoring tool to Redgate’s SQL Monitor.
2019-11-26
2019-11-25
2,955 reads
Understanding Auctions
We participate in auctions all the time even when we don’t realize it. In this article, Joe Celko discusses the many different types of auctions and how they work.
2019-11-25
Best Option for Working with Files in SSIS
This time we will compare different solutions to copy system folders using different SSIS tasks.
2019-11-22 (first published: 2017-05-09)
7,070 reads
Verify your SQL Server database backups
Introduction A popular joke about DBAs and database backups goes like this. There are two types of DBAs: DBAs that do backups DBAs that will do backups The joke is only stating the obvious – lack of database backups might be the end of a DBA career and/or the supported business. Unfortunately, that joke fails […]
2019-11-22
5,083 reads
Recover SQL Server Resource Database
SQL Server Post Update Failure | Troubleshooting - In this tip we look at the steps to recover missing SQL Server mssqlsystemresource database files that cause SQL Server not to startup. This can occur when an update to SQL Server does not complete successfully therefore making these files absent from the folder where they need to reside.
2019-11-22
SQL Clone PowerShell Scripting: The Basics
Phil Factor demonstrates some simple examples of how to use SQL Clone's PowerShell library to pass objects between cmdlets, and simplify common tasks, such as creating and deploying clones from various images. He then documents the objects and cmdlets, and illustrates their inputs and outputs.
2019-11-22
How to Think Like the SQL Server Engine: Using Statistics to Build Query Plans
Every index has a matching statistic with the same name, and each statistic is a single 8KB page of metadata that describes the contents of your indexes. Stats have been around (and been mostly the same) for forever, so this is one of the places where SQL Server’s documentation really shines: Books Online has a ton of information about statistics. You honestly don’t need to know most of that – but if you wanna make a living performance tuning, there’s a ton of great stuff in there.
2019-11-21
Blogs
SQLSaturday Orlando Notes – Large Printed Schedules
By Andy Warren
One of the things we’ve done most years in Orlando is to print poster...
Upgrading Windows 10 Home to Pro
By Steve Jones
I use Hyper-V and a few other things that require Windows 10 Pro. When...
Power Platform Quick Tips – Episode 03: Documenting Power Automate Flow Logic
By Devin-Knight
Welcome back to my series on Power Platform quick tips! In this episode you...
Forums
Impact value about missing indexes
is there relation between Impact from sys.dm_db_missing_index_group_stats and Impact from cache plan? Thanks for...
Migrating DB encrypted by master key
I'm migrating DBs from a 2008 R2 instance onto a 2017 instance. I have...
Ask SSC