Crossing Borders
I’m about to cross a country border for the first time in almost two years. I last left the United States in December 2019. Today I’m flying to Belgium...
2021-10-07
42 reads
The Voice of the DBA
Daily Coping 7 Oct 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-10-07
41 reads
Using NULLIF–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I ran across the NULLIF() function recently, and...
2021-10-06
24 reads
Daily Coping 6 Oct 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-10-06
8 reads
Daily Coping 5 Oct 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-10-05
9 reads
Using SQL Data Compare with Joins
Recently a customer was asking about how they could move data with SQL Data Compare from one server to another. In this case, the customer had a complex join...
2021-10-20 (first published: 2021-10-04)
363 reads
Quick Database Copies and Branching with Spawn
I delivered a talk last week at the Future Data Driven summit. It’s one I’ve done a few times, but I really enjoy it. It’s on the Future of...
2021-10-15 (first published: 2021-10-04)
270 reads
Daily Coping 4 Oct 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-10-04
17 reads
Daily Coping 1 Oct 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-10-01
38 reads
Daily Coping 30 Sep 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-09-30
40 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