Viva
Microsoft is working on the future of work, and adapting to remote work. Steve isn't sure this will work, but they have at least one interesting technology idea he likes.
sqldf in R Example for SQL Server
R has a package called sqldf that allows developers to manipulate data inside a dataframe in the same way a SQL developer queries a SQL table which we will cover with examples in this article.
Common Table Expression Misunderstandings
I frequently use Common Table Expressions (CTEs) when I demo windowing functions and get questions about them. Windowing functions are limited to the SELECT and ORDER BY clause which means that you can’t filter or group on them directly. Using a CTE is one way to separate the logic of the query into multiple steps […]
Monitoring the Number of Connections
Monitoring your SQL Server is important. This article examines one of the metrics you might want to keep an eye on.
Stairway to SQL Server Extended Events Level 3: Working with the Extended Events UI
In the next installment of our stairway to Extended Events, we delve into the Live Data and Target Data Viewers.
What's a Lot of Money?
Handling a budget can be an interesting experience for many technical professionals. Today Steve wonders if you treat this differently than your budget at home.
Customizing Database Deployments using Flyway Callbacks and Placeholders
How to customize a database deployment process using Flyway, demonstrating how to incorporate tasks such stamping a version number into the latest database build, or writing to the SQL Server log.
Partitioned Tables Cause Longer Plan Compilation Times
Folks sometimes ask, “When a table has more indexes, and SQL Server has more decisions to make, does that slow down execution plan generation?”. Brent Ozar talks through his response in this article.
Query Optimizer Suggests Wrong Index and Query Plan -- Why?
A good example where the Query optimizer picks the wrong query plan and suggested index.
UX Matters
User interface is a part of software development that many technical people pay little attention to during the process of building something. However, it can be a problem for your customers.
Blogs
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Advice I Like: In 100 Years
By Steve Jones
In 100 years a lot of what we take to be true now will...
Forums
Lots of FKs
Comments posted to this topic are about the item Lots of FKs
Real-time On-prem SQL Server Data in Excel – Over the Internet
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
Can You Let Go of Determinism
Comments posted to this topic are about the item Can You Let Go of...
Question of the Day
Lots of FKs
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers