COMING SOON – New Content
Hey everyone. Long time no chat. I wanted to write this quick post to let you know why there haven’t been any videos in a while. If you are...
2020-07-16
13 reads
Hey everyone. Long time no chat. I wanted to write this quick post to let you know why there haven’t been any videos in a while. If you are...
2020-07-16
13 reads
Watch this week's video on YouTube
Hey everyone. Long time no chat. I wanted to write this quick post to let you know why there haven't been any videos in...
2020-07-16
3 reads
Watch this week’s video on YouTube. This week, I want to share my process for analyzing Twitter. Specifically, I want to find who all of my friends follow on...
2020-01-14 (first published: 2020-01-07)
288 reads
Watch this week's video on YouTube
This week, I want to share my process for analyzing Twitter. Specifically, I want to find who all of my friends follow on Twitter...
2020-01-07
6 reads
Watch this week’s episode on YouTube. Pop quiz: What will be the output of the below three statements? As you might have guessed, the first conversion truncates the value,...
2019-12-17
185 reads
Watch this week's video on YouTube
Pop quiz: What will be the output of the below three statements?
DECLARE @val_varchar varchar(3) = '100';
DECLARE @val_bigint bigint = 100;
DECLARE @val_tinyint tinyint = 100;
PRINT('varchar...
2019-12-17
1 reads
Watch this week’s episode on YouTube. A year ago I built an app to keep track of pickup volleyball game scores and payments. It works well, but after a...
2019-12-03
2,069 reads
Watch this week's video on YouTube
A year ago I built an app to keep track of pickup volleyball game scores and payments. It works well, but after a year...
2019-12-03
2 reads
Watch this week’s episode on YouTube. At first I wasn’t going to write this post. I thought it would be too simple. Then I watched two experienced SQL developers...
2019-12-09 (first published: 2019-11-26)
2,060 reads
Watch this week's video on YouTube
At first I wasn't going to write this post. I thought it would be too simple.
Then I watched two experienced SQL developers go through...
2019-11-26
6 reads
By Steve Jones
vicarous – adj. curious to know what someone else would do if they were...
Say we have a database that we want to migrate a copy of into...
We are trying to get apps and users off of using SQL accounts to...
Hi I have this view to check if a job is running: SELECT...
All, if you are like me and do not care for the built-in color...
Certain internal SQL Server actions cause internal checkpoints. Which of these actions does not cause an internal checkpoint?
See possible answers