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
When the optimizer doesn’t estimate the correct amount of memory for a query, either memory is wasted that could be used for other processes or some operations will spill to disk. Microsoft has added Memory Grant Feedback to help overcome this issue. In this article, Greg Larsen explains what you need to know about this new feature.
2020-06-10
Nearly 1000 database professionals took part in this year's State of Database Monitoring survey. Providing insights into how they monitor their estates, the technologies they work with, what their biggest challenges are, and emerging trends for 2020. For the detailed analysis of the responses, download your free copy of the report.
2020-06-09
n SQL cursors serve as a pointer that enables application programming language to deal with query results one row at a time. Read on to explores the concept behind and learn how to declare cursors, open, retrieve data from them, and then close them.
2020-06-09
In some shops, testing is entirely in the realm of quality analysts. In this article, Julio Sampaio argues that testing should be automated and start with the developers.
2020-06-08
We’re pleased to announce that the SQL Prompt extension for Azure Data Studio is now available to download for free. With SQL Prompt in Azure Data Studio, you can use an extensive collection of code snippets to write your SQL code quickly and efficiently. You can also keep your code consistent using the powerful formatting capability, and customize the applied style to suit your preferences.
2020-06-08
Josh Crang explains why SQL Monitor will be switched to run on .NET Core, and how the team tested the potential performance improvements in the monitoring service.
2020-06-05
In this article of the series, Robert Sheldon discuses emerging trends in storage like virtual SANs, intelligent storage, computational storage and storage-class memory.
2020-06-05
By Steve Jones
I was looking over the CHOOSE() function while editing an article at SQL Server...
By Brian Kelley
Here is another short video (~ 15 minutes). This is by the author of...
By Steve Jones
I had a briefing for the 2026 PASS Data Community Summit, which is just...
Comments posted to this topic are about the item SQL Server 2025 Server-level Roles
Comments posted to this topic are about the item Stairway to DAX and Power...
Comments posted to this topic are about the item AI Is Improving Security
In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?
See possible answers