Enable Mail Profile – Back to Basics
I’ve seen many people go through the trouble of setting up database mail and configuring SQL Agent Alerts only to...
2019-03-13
266 reads
Blog Posts
How Do You Export A Database in Azure Data Studio
I’ve been writing a bunch about Azure Data Studio. I’ve also been recording videos on the topic. A comment I...
2019-03-13 (first published: 2019-02-25)
2,373 reads
PASS Summit 2019 Call for Speakers is Open – How I Sketch Out My Submission Ideas
Are you interested in speaking at the Professional Association for SQL Server’s annual Summit conference? The call for speakers is now open, and you may submit up to three...
2019-03-13
5 reads
Power BI Monthly Digest – March 2019
In this month’s Power BI Digest with Manuel Quintana [Blog | Twitter] and I will again guide you through some of...
2019-03-13
947 reads
Quick tip: Zoom in Azure Data Studio
If you finally have given a try to Azure Data Studio, and if you use it on a regular basis,...
2019-03-13
2,449 reads
Quick tip: Zoom in Azure Data Studio
If you finally have given a try to Azure Data Studio, and if you use it on a regular basis, maybe you want to customize it to suit your...
2019-03-13
10 reads
SQL Server Deadlocks
A quick video clip showing how to create a deadlock in SQL Server and find information about it.
2019-03-13
1,119 reads
Telegraf Setup FAQ for Troubleshooting
I often get emails asking the same time of questions about the setup of Telegraf for SQL Server and Windows...
2019-03-13
487 reads
Whats a SQL Notebook in Azure Data Studio?
Azure Data Studio is a cross-platform database tool for data professionals using the Microsoft family of on-premises and cloud data...
2019-03-13
637 reads
#TSQL2sDay – #112 – Mini cookies
This months TSQL Tuesday is hosted by Shane O’Neill (Blog | Twitter) Shane explains the Topic as:
Dipping into the Cookie Jar...
2019-03-12
278 reads
Blogs
RANK() vs DENSE_RANK(): #SQLNewBlogger
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
Forums
Creating JSON II
Comments posted to this topic are about the item Creating JSON II
Engineer Lessons
Comments posted to this topic are about the item Engineer Lessons
Question of the Day
Creating JSON II
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers