Monthly Archives: August 2018
-
SQL Puzzle: Advent of Code
Leave a commentAugust 29, 2018 by Kenneth Fisher
A few years back someone started the Advent of code. If you aren’t familiar with it, it’s an advent calendar …
Continue reading -
Copying formatted text out of a grid column.
7August 27, 2018 by Kenneth Fisher
I was reading a post today by Bert Wagner (b/t). Displaying Long Variable Values in SQL Server By the way, …
Continue reading -
#SQLCareer 3/4 August 6th 2018
1August 22, 2018 by Kenneth Fisher
Last month Steve Jones (b/t) suggested that it might be helpful if those of us that work in the IT/database …
Continue reading -
Nada to Speaker: Demystifying and Diminishing Dynamic SQL Difficulties
3August 20, 2018 by Kenneth Fisher
Last Thursday I spoke at NTSSUG (North Texas SQL Server User Group). This is my local group (only 1.5 hours …
Continue reading -
What are my permissions?
1August 16, 2018 by Kenneth Fisher
Permissions are a common concern. One of the most frequent requests I get is I need X, Y and Z …
Continue reading -
Complicated linked servers and a bunch of head-desks: T-SQL Tuesday #104
Leave a commentAugust 14, 2018 by Kenneth Fisher
Wayne Sheffield (b/t) is our host this month for the long running blog party (104 months now and running!) started …
Continue reading -
Putting Object Explorer etc on the right side of SSMS rather than the left.
2August 8, 2018 by Kenneth Fisher
A while back I was given the advice Move your tabs (Object Explorer etc) to the right side of SSMS. …
Continue reading -
T-SQL Formatters
3August 6, 2018 by Kenneth Fisher
The other day I was given a truly horribly formatted piece of SQL. Something a bit like this only worse, …
Continue reading -
SQL Homework – August 2018 – Set up database mail
Leave a commentAugust 1, 2018 by Kenneth Fisher
This month’s homework is pretty simple to say, not necessarily easy to do. Set up database mail. Why database mail? …
Continue reading
SQL Studies 