2018-07-09
72 reads
Editorials
Who Likes NULL?
The use of NULL values in a database can be controversial. Today Steve talks about his views on this concept.
2018-07-06
134 reads
2018-07-05
502 reads
2018-07-04
36 reads
2018-07-03
59 reads
Detecting SQL code smells using code analysis
Watch out, watch out, there's a NOLOCK hint about. And probably a few other SQL code smells.
2018-07-02
321 reads
DevOps is Really Helpful
Steve Jones talks about the practical benefits of using DevOps to smooth out your software development.
2018-07-02
128 reads
How are you recharging this year?
Steve Jones asks about your plans to get away from work and refresh yourself.
2018-06-29
51 reads
String or binary data would be truncated
This is an error that has plagued SQL Server for a long time. It should be fixed.
2018-06-28
313 reads
When Work Gets in the Way of Work
Work sometimes gets in the way of work. Steve Jones notes this can cause stress and problems over time.
2018-06-27 (first published: 2014-10-21)
209 reads
Blogs
A New Word: Nachlophobia
By Steve Jones
nachlophobia – n. the fear that your deepest connections with people are ultimately pretty...
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)...
Forums
A Strange Query
Comments posted to this topic are about the item A Strange Query
Primary and Secondary Filegroup
Hello, I am having database primary and secondary filegroup. Few tables/indexes are partitioned on...
Import data from json file with special characters
I am using the following script to import data from a json file. This...
Question of the Day
A Strange Query
What does this return?
SELECT x=1 WHERE (SELECT 1) IN ( 1, 2, 3)See possible answers