Monthly Archives: July 2018
-
#SQLCareer 2/4 July 25th 2018
Leave a commentJuly 30, 2018 by Kenneth Fisher
Earlier this month Steve Jones (b/t) suggested that it might be helpful if those of us that work in the …
Continue reading -
#SQLCareer 1/4 July 19th 2018
3July 25, 2018 by Kenneth Fisher
Earlier this month Steve Jones (b/t) suggested that it might be helpful if those of us that work in the …
Continue reading -
Processes can dramatically improve your work until they don’t.
Leave a commentJuly 23, 2018 by Kenneth Fisher
As always with something like this, I like to start with a definition so we are all starting in the …
Continue reading -
RESTORE VERIFYONLY what does WITH LOADHISTORY do?
2July 18, 2018 by Kenneth Fisher
Recently someone mentioned the LOADHISTORY option of RESTORE. It’s not horribly hard to find in BOL but it wasn’t the …
Continue reading -
Counting NULLs
4July 16, 2018 by Kenneth Fisher
Recently I was doing one of Kendra Little’s (b/t) SQL Server quizzes. Specifically the Quiz: COUNT() in SQL Server. As …
Continue reading -
Balancing Security Concerns.
2July 12, 2018 by Kenneth Fisher
I have a presentation I do every now again on security basics that I’m actually quite proud of. One of …
Continue reading -
Code I’d Hate To Live Without: T-SQL Tuesday #104
3July 10, 2018 by Kenneth Fisher
It’s TSQL Tuesday again! This time our respected host is Bert Wagner (b/t). Quick aside, if you haven’t seen his …
Continue reading -
SQL Homework – July 2018 – Create a SQL Agent Job
1July 2, 2018 by Kenneth Fisher
For this month’s homework let’s try something a bit different. SQL Agent jobs are a very powerful tool frequently used …
Continue reading