#SQLCareer 2/4 July 25th 2018
Earlier this month Steve Jones (b/t) suggested that it might be helpful if those of us that work in the...
2018-08-13 (first published: 2018-07-30)
1,493 reads
Earlier this month Steve Jones (b/t) suggested that it might be helpful if those of us that work in the...
2018-08-13 (first published: 2018-07-30)
1,493 reads
This crossword is based on terms you might come across in an article about Dynamic SQL.
2018-08-08
602 reads
A while back I was given the advice Move your tabs (Object Explorer etc) to the right side of SSMS....
2018-08-08
282 reads
The other day I was given a truly horribly formatted piece of SQL. Something a bit like this only worse,...
2018-08-06
393 reads
I have a presentation I do every now again on security basics that I’m actually quite proud of. One of...
2018-08-02 (first published: 2018-07-12)
1,959 reads
This month’s homework is pretty simple to say, not necessarily easy to do. Set up database mail.
Why database mail?...
2018-08-01
330 reads
Recently someone mentioned the LOADHISTORY option of RESTORE. It’s not horribly hard to find in BOL but it wasn’t the...
2018-07-31 (first published: 2018-07-18)
2,934 reads
Earlier this month Steve Jones (b/t) suggested that it might be helpful if those of us that work in the...
2018-07-25
228 reads
As always with something like this, I like to start with a definition so we are all starting in the...
2018-07-23
168 reads
It’s TSQL Tuesday again! This time our respected host is Bert Wagner (b/t). Quick aside, if you haven’t seen his...
2018-07-19 (first published: 2018-07-10)
3,642 reads
By Steve Jones
The episode on data masking and subetting is out. You can see it here:...
By Brian Kelley
I'm listening to Effortless by Greg McKeon (link to author's page) through Audible.com. He...
This book was making its rounds on social media, and the concept seems interesting...
Hi Dbatools is used to copy table data from domain a to domain b...
I am using the following sql to convert rows into columns for each pid,...
Comments posted to this topic are about the item Ingesting Data From REST API...
What are the two inputs called to a hash join operation in SQL Server? (choose 2)
See possible answers