2014-05-12
2,126 reads
PhyData DBA
Mastering Dimensions of Time
A method to create and populate Date and Time dimension tables for a data warehouse project.
2014-01-21
10,533 reads
Blogs
Using SQL Alerts to Spot Suspicious Activity in SQL
SQL doesn’t really give us too many tools out of the box to allow...
How to Change the Browser Used by SSMS for AAD Auth
Did you know that you can change the browser used by SQL Server Management...
Typing with Your Tongue Part 2: Voice Access
By DataOnWheels
A few months ago, I wrote a post on how I use voice technology...
Forums
Azure SQL database AAD user management
I have an Azure SQL DB where I have set up the Azure active...
Use a recursive CTE to produce 1 update statement using dynamic SQL
I want to be able to generate 1 merge statement rather than loop through...
Query to Update balance based on columns from two different rows.
Hello All, Below is the my existing table structure from which I am trying...
Ask SSC