Blog: Kenneth Fisher

210 blogs updated: 27 min. ago
You can't DELETE TOP (x) with an ORDER BY
Did you know you can't do this? Msg 156, Level 15, State 1, Line 8 Incorrect syntax near the keyword ... Continue reading
19-09-2018 15:17:20 Kenneth Fisher SQL Server
How do I grant permissions to view users and their permissions?
tl;dr; VIEW DEFINITION Every now and again you'll have a user that needs to be able to see what permissions ... Continue reading
17-09-2018 15:05:39 Kenneth Fisher SQL Server
Using Table Valued Parameters with sp_executesql
Recently I did a presentation on dyanmic SQL. In the presentation I pointed out the similarity of using sp_executesql to ... Continue readin...
13-09-2018 15:08:21 Kenneth Fisher SQL Server
What happens in a trigger stays in the transaction: T-SQL Tuesday #106
Anything that happens in a trigger happens within the same transaction of the command that called it. Part of me ... Continue reading
11-09-2018 15:55:31 Kenneth Fisher SQL Server
I/O vs Logical I/O
tl;dr; While the difference is very important 90% of the time you won't care and should just add the two ... Continue reading
05-09-2018 15:10:28 Kenneth Fisher SQL Server
SQL Homework – September 2018 – Backup and Restore continued.
In the very first SQL Homework post you were asked to take a backup. In fact it asked you to ... Continue reading
03-09-2018 15:46:18 Kenneth Fisher SQL Server
SQL Puzzle: Advent of Code
A few years back someone started the Advent of code. If you aren't familiar with it, it's an advent calendar ... Continue reading
29-08-2018 15:04:37 Kenneth Fisher SQL Server
Copying formatted text out of a grid column.
I was reading a post today by Bert Wagner (b/t). Displaying Long Variable Values in SQL Server By the way, ... Continue reading
27-08-2018 15:01:33 Kenneth Fisher SQL Server
#SQLCareer 3/4 August 6th 2018
Last month Steve Jones (b/t) suggested that it might be helpful if those of us that work in the IT/database ... Continue reading
22-08-2018 15:20:28 Kenneth Fisher SQL Server
Nada to Speaker: Demystifying and Diminishing Dynamic SQL Difficulties
Last Thursday I spoke at NTSSUG (North Texas SQL Server User Group). This is my local group (only 1.5 hours ... Continue reading
20-08-2018 16:07:07 Kenneth Fisher SQL Server

© Jiri Pinkas | this project on GitHub | related: SQL školení | Top Java Blogs | monitored using: sitemonitoring

Top SQL Blogs is a blog aggregator (with English-written blogs only) focused on MySQL, PostgreSQL, MS-SQL and Oracle databases.