Category Archives: SQLServerPedia Syndication
-
I/O vs Logical I/O
Leave a commentSeptember 5, 2018 by Kenneth Fisher
tl;dr; While the difference is very important 90% of the time you won’t care and should just add the two …
Continue reading -
SQL Homework – September 2018 – Backup and Restore continued.
Leave a commentSeptember 3, 2018 by Kenneth Fisher
In the very first SQL Homework post you were asked to take a backup. In fact it asked you to …
Continue reading -
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 -
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 