Key Sets, or Inverted Keys - defining a key as a set of tuples
TL;DR:
I have been doing a lot of thinking about data models for the last couple of weeks. I have, just...
2017-12-19
474 reads
Blog Posts
Mapping SQL Trace to Extended Events
Since I started actively participating in SQL community, I found it is very common that people will approach to seek...
2017-12-19
2,196 reads
Moving to an Azure SQL Database via Command Line
I have moved many databases to Azure via different methods but I recently came across a new way. Well technically...
2017-12-19 (first published: 2017-12-07)
1,554 reads
Power BI Custom Visuals Class (Module 82 – Text Filter)
In this module you will learn how to use the Text Filter Custom Visual. This visual allows you to filter...
2017-12-19
625 reads
Recovering the PsGallery Repository behind a Corporate Proxy
While getting a new workstation is usually nice, reinstalling all your softwares and settings is definitely not the most pleasant...
2017-12-19
888 reads
Start/Stop Group of Azure RM VM's
For testlab purposes, I often have a group of Azure VMs to manually spin up/spin down at once. I've had...
2017-12-19
375 reads
What The Doctor Ordered
I recently went to our local pharmacy to pick up some prescriptions. There was one for my boy and one...
2017-12-19
329 reads
ARMED - Azure ARM VS Code extension
I have been working with ARM templates for a little while and have found it really annoying to test functions...
2017-12-18 (first published: 2017-12-06)
1,169 reads
Azure ARM template function internals
I have been working with azure arm functions for quite a while and they are exceptionally useful but also quite a pain to work with, visualizing what it is...
2017-12-18
13 reads
Azure ARM template function internals
I have been working with azure arm functions for quite a while and they are exceptionally useful but also quite...
2017-12-18
50 reads
Blogs
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Creating a SQL Stored Procedure to Load a SCD2
By DataOnWheels
This is a blog that I am writing for future me and hopefully it’ll...
Funny Money: #SQLNewBlogger
By Steve Jones
While wandering around the documentation looking for some Question of the Day topics, I...
Forums
Backup Availability Group
Please I am hoping for some feedback Specifications: Windows Server 2022 SQL Server 2022...
How Do the Experts Become Experts?
Comments posted to this topic are about the item How Do the Experts Become...
Stairway to Reliable Database Deployments Level 4 – Preparing for Production Deployment
Comments posted to this topic are about the item Stairway to Reliable Database Deployments...
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers