Back to basics: What is a HEAP table?
Understanding the fundamentals is key for success, with everything you do. These days SQL Server has expanded into much more...
2018-05-24 (first published: 2018-05-16)
5,765 reads
Removing servers from the SSMS connection dialog (Day 36)
One of the things that you will no doubt end up experiencing as a DBA is that you will see...
2018-05-16
2,032 reads
Cosmos DB for the Data Professional
Cosmos DB is one of the fastest growing Azure services in 2018. As its popularity grows, data professionals are faced...
2018-05-24 (first published: 2018-05-16)
2,869 reads
Dates and Times in SQL Server: more functions you should never use
Previously we looked at four built-in functions to get the current date and time in SQL Server and Azure SQL...
2018-05-23 (first published: 2018-05-16)
3,894 reads
Webinar Followup: Overview of Azure Data Factory V2
About 3 weeks ago I presented a free webinar for Pragmatic Works where I talked about Azure Data Factory V2. You can watch the recording here if you missed...
2018-05-16
24 reads
Webinar Followup: Overview of Azure Data Factory V2
About 3 weeks ago I presented a free webinar for Pragmatic Works where I talked about Azure Data Factory V2....
2018-05-16
386 reads
Tea with Kalen! An interview with Kalen Delaney (#DBAsAtMidnight)
We had an AMAZING talk with Kalen Delaney – wait, you do know who Kalen is, don’t you? Rightfully, @SQLQueen on Twitter. Over 30 years...
2018-05-16
361 reads
The trials and tribulations of REVERTing from impersonation
Impersonation is a highly useful tool in your toolbox. With the EXECUTE AS clause you can allow your stored procedure...
2018-05-16
391 reads
Day 16 Security
MySQL user format it as ‘User_name’@’hostname’ To create the user account use following syntax: CREATE USER ‘User_name’@’Host_name’ IDENTIFIED BY <Pwd>;...
2018-05-16
229 reads
Query to determine last statistics update for a database
Statistics are a vital part of SQL Server database engine, these are used for the query optimizer to create query...
2018-05-16
140 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Risk Vs Reward, The never ending ROI discussion.
Comments posted to this topic are about the item Risk Vs Reward, The never...
Trigger isn't working
Hi, I have a trigger, that works fine elsewhere but is not working at...
Question of the Day
Hyperscale Replicas IV
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers