Databases in Azure… Where to begin? Create a Database and log in!
Ready to create your first Database in Azure. Here are the step by step instructions with plenty of definitions and terms.
2019-10-23 (first published: 2016-06-16)
6,000 reads
Michael Morin
Windowing Functions: Tell me when that changes
Windowing functions aren't just for analyzing numbers/dates. Using windows functions to analyze when a character field changes is a little know resource
2017-03-17 (first published: 2016-02-17)
10,638 reads
Databases in Azure: Copy and Exports
Toady we are going to make a copy and export your DB to Azure Storage. Lets get started.
2016-07-19
1,357 reads
Finding Special Characters within Character Strings
Special Characters can lead to many problems. Identifying and reporting on them can save a lot of headache down the road.
2016-04-08 (first published: 2014-08-19)
131,150 reads
Blogs
Extended Events in Azure Data Studio
I know I can use extended events (xevents) in Azure SQL DB when in...
Azure Workbooks
I’m saddened that the Workspace Summary is being deprecated in Log Analytics Workspace. I...
SQL Prompt Tips–Using $surroundtext$ in a Snippet
By Steve Jones
A user on the SQL Community Slack was asking about what the $surroundtext$ variable....
Forums
data security for a data warehouse
I'm working with someone whose client says "Yes, we have a data warehouse. But...
Review of DB Activity
Hi Folks, I have been tasked with reviewing all the activity on a...
Ask SSC