Too much information can be counter-productive
If you want to be an effective communicator focus on what your audience need to hear rather than what you want to say
2019-09-02 (first published: 2016-01-29)
371 reads
Editorials
Always Check on the Basics
The basics are important, especially with regards to backup and restore in SQL Server.
2019-08-31
340 reads
Do You Deal with UTF-8?
UTF-8 is coming to SQL Server. Steve wonders today how many of you look forward to this, or if you are aware of potential issues.
2019-08-30
320 reads
Grounded
Some laptops are being banned from flights. This could be a hassle, but more, how can anyone tell if you have a banned one?
2019-08-29
382 reads
Protecting Code
We not only need to protect our systems, but the source code as well. Not for IP reasons, but for security.
2019-08-28
236 reads
Should Salary Information Be Confidential?
Today we have a guest editorial from Andy Warren as Steve is away from the office. Salary is a difficult topic for many, but Andy shares some thoughts.
2019-08-27 (first published: 2015-06-05)
608 reads
Growing and Changing
It can be hard to let go of old knowledge and try something new, but we need to find a balance.
2019-08-26
174 reads
SQL Tamagotchi! Mini-Servers as Database Pets
If you've ever stuffed SQL Server onto a Raspberry Pi 4 and given it a pet name, don't worry, you're not alone…
2019-08-24
280 reads
Waits and Queues
This week Steve is wondering if you know how to use waits and queues for troubleshooting.
2019-08-23
555 reads
Don't Get On This Page
There is a page where GDPR fines are tracked. None of us want to get on that page.
2019-08-22
413 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