This stairway level will expand on the subquery topic by discussing a type of subquery known as a correlated subquery, and explores what a correlated subquery is and how it is different from a normal subquery.
Take a look at some of these DBA request examples and things you could do to improve your request process.
A company has both a server without a password and live data in test environments. Not a good situation.
Introduces modular programming with the Execute Package task, and shows bi-directional parameter passing.
If you want to understand the fundamentals of MDX in less than 3 hours - this article can be helpful.
Azure Data Studio (ADS) is a lightweight IDE built on Visual Studio Code. I've written a few articles on how ADS works, shown here: Getting Started with Azure Data Studio Getting Comfortable Writing Code in Azure Data Studio Using Notebooks in Azure Data Studio Using Azure Data Studio with TFVC Using Azure Data Studio with […]
Learn how to find the current identify column value in your Microsoft SQL Server tables.
Software often controls hardware, which can make it the critical part of a system. That's something we should be learning from the Boeing 737-Max crashes.
In this level, learn about how to get the tools needing for coding in R and how to execute some code that connects to SQL Server.
Learn how to configure SQL Server Agent to allow emails to be sent for job notifications and alerts.
By Steve Jones
Don’t reserve your kindest praise for a person until their eulogy. Tell them while...
I wanted to try out the new JSON index which is for the moment...
By Brian Kelley
I thought it would be good to put my thoughts down on how to...
Comments posted to this topic are about the item Learning a New Language
Hi, we have a few people who like to experiment on our prod sql...
Comments posted to this topic are about the item Guidelines and Requirements
If I use DBCC CLONEDATABASE, can I remove some of the information from the copy?
See possible answers