Storing a variable with a SELECT, and why it didn't work.
Using SELECT to store values into variables is an important technique, but you need to know some of the gotchas as well.
How to Back Up SQL Server to Azure Blob Storage
When you’re planning for disaster recovery, offsite backups in the cloud are an attractive option. SQL Server Management Studio makes it easy to back up to the cloud inside the GUI, and you can learn how in just 90 seconds.
Exam 70-462: Using Azure for the Practice Setup
A step-by-step guide to creating a practice setup for the 70-462 exam using Azure virtual machines.
SQL Server Authenticated Users, why are we still using them?
AD Authentication in SQL Server has been around for a long time, so why do we still use SQL Authentication?
Troubleshooting Parameter Sniffing Issues the Right Way: Part 1
Tara Kizer explains that many of you are troubleshooting Parameter Sniffing issues the wrong way in production. In this three-part series, she will show you how to troubleshoot it the right way.
SQL Server Graph Databases – Part 1: Introduction
SQL Server 2017 now includes a new feature to represent complex relationships in data called Graph Databases. Robert Sheldon introduces Graph Databases in the first article of this new series.
How does GDPR impact your SQL Server Recovery Plans
With GDPR on the imminent horizon, there are many things that Data Platform engineers need to consider with regards to the rights of data subjects. Primary among these is understanding the impact of requests to be forgotten and updates to a person's data when it comes to restoring databases. If you have data that is within the scope of the GDPR then here are some thoughts on extra processes for your DR planning.
Small Changes and Big Impacts
Using new features and changing code can cause problems in your environment. Always test to be sure that the impact is acceptable.
Blogs
Optimizing Redshift Performance by Configuring WLM Queues
Efficient query performance in Amazon Redshift often comes down to how well you manage...
PowerShell Strikes Back: Return of the Loop
By gbargsley
Welcome back to PowerShell Strikes Back. We’re three weeks in, and the training is...
Breaking Rules in Rome
By Steve Jones
Last week I was honored with a trip to Rome for the Redgate President’s...
Forums
Why Your Index Isn't Being Used? - Reading Execution Plans to Find the Real Culprit
Comments posted to this topic are about the item Why Your Index Isn't Being...
Distance Metric Algorithms
Comments posted to this topic are about the item Distance Metric Algorithms
What Can AI Really Do?
Comments posted to this topic are about the item What Can AI Really Do?
Question of the Day
Distance Metric Algorithms
What are the distance metric algorithms that can be used in VECTOR_DISTANCE()?
See possible answers