Priorities and Productivity
Managing a complex workload is a skill many of us need to acquire and maintain. Today Steve has a few ideas on how to do that.
2019-10-09
201 reads
Editorials
Very Hot Patches
Azure SQL Database can be patched without stopping the sqlsrvr.exe process. Quite a feat of engineering.
2019-10-08
181 reads
T-SQL Context Switching
Being a standards advocate, Steve has a few thoughts on team code structure.
2019-10-07
406 reads
Which Service in Azure Should You Use for SQL?
I remember when Azure SQL Database was first released in 2010. Microsoft has tweaked the name a couple of times over the years, and back then it was called SQL Azure. The largest database you could create was just 50 GB, and there were quite a few restrictions, such as heaps not being supported. Since […]
2019-10-05
426 reads
Documenting with Tests
The idea of using more unit tests to improve code quality has been around for some time. However Steve Jones notes today that some people use tests for documentation.
2019-10-04 (first published: 2015-05-14)
269 reads
2019-10-03
230 reads
Searching for Answers Inside
Learning how an organization, or even just a codebase, works can be a challenge for new employees.
2019-10-02
136 reads
It's Natural to Avoid Problems
Culture change is hard, and it's one of the most difficult things to implement when trying to get your team to work in a DevOps fashion.
2019-10-01
224 reads
Unreliable Data Sensors
Steve doesn't like the idea of cars using data from cameras to update a display instead of a mirror.
2019-09-30
175 reads
Celebrate Success
Today Grant reminds us to not only think about the things we can do better, but remember the good things that we accomplish.
2019-09-28
154 reads
Blogs
Finding fields used in a Power BI report in PBIR format with Semantic Link Labs
Have you ever wondered where a certain field is used in a report? Or...
Adding Test data to msdb.sysjobhistory
By Steve Jones
One of our internal people was looking to test some process in (I assume)...
Microsoft Ignite Announcements Nov 2024
By James Serra
Announced at Microsoft Ignite last week were some new product features related to the...
Forums
Import data from json file with special characters
I am using the following script to import data from a json file. This...
% processor Time in Activity monitor is greyed out
When I connect to my SQL Server using SQL Server Management Studio (SSMS) from...
Tools for MySQL memory estimations and optimization?
Hi all! I’ve been using MySQLCalculator.com for memory calculations, but I’m looking for alternatives...
Question of the Day
The Hash Join II
Which of these inputs is the smaller input to a hash join?
See possible answers