Broken Update With Join
Last month I wrote a post titled Broken Left Join which covered an easy to make mistake that I see...
2016-05-26 (first published: 2016-05-18)
1,806 reads
Blog Posts
CPU Scheduling Basics – Windows and SQL Server
In this post we’re going to introduce the basics of CPU scheduling.
In a computer system, only one thing can happen at a time. More specifically, only one task can...
2016-05-26
23 reads
CPU Scheduling Basics – Windows and SQL Server
In this post we’re going to introduce the basics of CPU scheduling.
In a computer system, only one thing can happen...
2016-05-26
1,402 reads
Just a week to SQL Saturday in Pensacola
Next week is SQL Saturday #491 in Pensacola. I’ll be there, along with a number of other great speakers. It’s...
2016-05-26
799 reads
Migrate from on-prem SQL server to Azure VM IaaS
Hopefully you went through my presentations Should I move my database to the cloud?, Introducing Azure SQL Database and Implement SQL Server on an...
2016-05-26 (first published: 2016-05-18)
3,216 reads
SQL Server – Rollback transaction completely in case of error
Hi friends, I recently found an issue while inserting data into table during transactions that transaction will not completely rollback...
2016-05-26
671 reads
A Basic Recursive CTE and a Money Lesson
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2016-05-25
810 reads
A Moment For Reflection…
While this is a personal blog, I try to keep it focused on either technical topics or personal development and...
2016-05-25
500 reads
Azure Storage pricing
Azure storage is a great, inexpensive solution for storing your data in the cloud. There are many types of Azure...
2016-05-25
959 reads
Connecting to Azure SQL Database
Recently I created my first Azure SQL Database. But now I need to connect to it.
You can connect using...
2016-05-25
553 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
Training the next generation
Comments posted to this topic are about the item Training the next generation
Reusing Customer Specific Order Filtering Logic with CROSS APPLY and an Inline TVF (Part 4)
Comments posted to this topic are about the item Reusing Customer Specific Order Filtering...
PostgreSQL psql Meta Commands: Databases
Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Databases
Question of the Day
PostgreSQL psql Meta Commands: Databases
Which of the following meta commands (sometimes called backslash or slash commands) within psql will provide you with information about the databases on the cluster?
See possible answers