#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
Kenneth Fisher
Dynamic SQL Crossword
This crossword is based on terms you might come across in an article about Dynamic SQL.
2018-08-08
604 reads
Putting Object Explorer etc on the right side of SSMS rather than the left.
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
T-SQL Formatters
The other day I was given a truly horribly formatted piece of SQL. Something a bit like this only worse,...
2018-08-06
396 reads
Balancing Security Concerns.
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,960 reads
SQL Homework – August 2018 – Set up database mail
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
RESTORE VERIFYONLY what does WITH LOADHISTORY do?
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,944 reads
#SQLCareer 1/4 July 19th 2018
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
Processes can dramatically improve your work until they don’t.
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
Code I’d Hate To Live Without: T-SQL Tuesday #104
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
Blogs
My 2024 in Data: Music
By Steve Jones
This is my last week of the year working (I guess I come back...
A New Word: Suente
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Side Projects
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
Forums
Real Illuminati Agent Call+256750549868/+256768817448
Real Illuminati Agent Call +256750549868/+256768817448. If you are interested in joining illuminati call now...
DTEXEC Not working for my project: Cannot create a task from XML for task
I recently created an SSIS package and then converted it to a Package Deployment...
Migrated to new server, 2019 enterprise, jobs taking 300% longer to run. Ideas?
Hi all, So here's the situation. We migrated to a new server as our...