Could you spare 3 minutes to help us out at SQL Server Central? Take this short survey, tell us about who you are and why you come to SQL Server Central, and you could win a $50 Amazon voucher.
2020-06-17
Microsoft provides a number of different deployment options for its Azure SQL Database offerings. While most of them share the same characteristics, one in particular warrants special attention from the standpoint of its infrastructure dependencies. That exception is Azure SQL Database Managed Instance, which will be the topic of this article.
2020-06-16
From performance to recruitment, cloud adoption to estate growth, the findings from the 2020 State of Database Monitoring report offer us some key insights into the trends and challenges facing the industry this year. Redgate’s Jamie Wallis unpicks the findings in this latest blog.
2020-06-16
SQL Change Automation enables users to make database changes to production safely and efficiently using PowerShell cmdlets, which can be integrated easily into any release management tool. This article will show you how to automate database deployments safely, by using SQL Change Automation from within PowerShell scripts, and how a deployment script for a release can be checked and amended as part of the process.
2020-06-15
Most advice you see online about heaps is to avoid them. In this article, Uwe Ricken describes the basics of heaps so that you can determine when heaps are the best choice.
2020-06-15
Phil Factor distills the basic tasks of the database development stage and explains how SQL Compare can help tackle them.
2020-06-12
As organisations move to cloud platforms like Azure and AWS, understanding security is more important than ever. In this article, Vasanth Makam explains what companies need to know to make sure their data is secure.
2020-06-12
Alexander Diab demonstrates how a team of developers can work on and test features in different branches of a SQL Server database development project, while their local development database automatically remains 'synchronized' with the current branch in version control.
2020-06-11
In this article we look at different examples of how to use GROUP BY with your SQL Server queries and the different results you get with the various options.
2020-06-11
Grant Fritchey explains what's involved in masking a SQL Server database. It can seem a daunting task, but it all becomes a lot more logical if you start from a plan, based on agreed data classifications, and then use a tool like Data Masker to implement the masking, and track progress.
2020-06-10
Next up in my series talking about The Burrito Bot is diving into the...
By DataOnWheels
Two years ago, two things happened within a few days of each other. I...
By gbargsley
This is it. The final chapter of PowerShell Strikes Back. Over the past four...
Comments posted to this topic are about the item Unraveling the Mysteries of the...
Comments posted to this topic are about the item QUOTENAME Behavior
Good Morning. I have a T-SQL Script which has been developed to execute a...
I use QUOTENAME() like this in code?
DECLARE @s VARCHAR(20) = 'Steve Jones' SELECT QUOTENAME(@s, '>')What is returned? See possible answers