Data Bits – Episode 4 – Jules Behrens
SQL Server DBA Jules joins us on the show to talk DBA work, Chickens, Charity work, Mentoring and Shepherding (actual sheep!) See more at Jules’ site Edit: Honorable mentions: Minionware,...
2020-04-02
15 reads
Blog Posts
How To Fix OBS Black Screen when recording SQL Server Session Demo’s?
Everyone loves a demo. When I say everyone, I mean I personally love seeing a demo in a session which is why 99% of any sessions I present will...
2020-04-02
43 reads
Learn SSIS and ADF for Free
It’s not from SQLServerCentral, though I hope to do more training across the next few months. Andy Leonard is offering Free Training for People Who Have Lost Their Jobs....
2020-04-02
54 reads
Moving to a New SqlClient
DotNet developers, if you’re using the System.Data.SqlClient, stop. Move over to Microsoft.Data.SqlClient now. It’s easy to do, well, it’s relatively easy to say that. The actual work isn’t that...
2020-04-02 (first published: 2020-03-26)
1,266 reads
Quickly Editing Data in SSMS
WARNING: do not do this in production. A quick blog post on a SSMS trick: how to quickly edit data. Sometimes you directly want to manipulate data without having...
2020-04-02
49 reads
Stress Cases and Data Visualization
Times are stressful right now. There is an ongoing pandemic affecting people’s health and livelihoods. Schedules are messed up, kids are home. People who aren’t used to working remotely...
2020-04-02 (first published: 2020-03-26)
416 reads
User Defined Types and Temp Tables Gotcha
This tripped me up a few weeks ago, but once I stopped and thought about for a moment it made total sense. I was trying to copy some data...
2020-04-02
7 reads
User Defined Types and Temp Tables Gotcha
This tripped me up a few weeks ago, but once I stopped and thought about for a moment it made total sense. I was trying to copy some data...
2020-04-02
4,334 reads
ADF – Deployment from master branch code (JSON files)
In the previous episode, I showed how to deploy Azure Data Factory in a way recommended by Microsoft, which is deployment from adf_publish branch from ARM template. However, there...
2020-04-01
38 reads
ADF – Deployment from master branch code (JSON files)
In the previous episode, I showed how to deploy Azure Data Factory in a way recommended by Microsoft, which is deployment from adf_publish branch from ARM template. However, there...
2020-04-01
9 reads
Blogs
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Forums
what data type i should use for roversion col and can i use less than greater
can i use Rowversioncol ( in my database it's synonyme timestamp is used) to...
Radius Latitude Longitude
I have a table with latitude longitude in the format. 45.123456 , -111.123456 ,...
degree of parallelism
Team, I'm trying to figure out what will be the best recommendation to configure...
Question of the Day
A Fun Computer Quote
Which movie featured this quote?
"All programs have a desire to be useful."Happy April Fools! See possible answers