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 other...
2018-09-17
335 reads
SQLStudies
Using Table Valued Parameters with sp_executesql
Recently I did a presentation on dynamic SQL. In the presentation I pointed out the similarity of using sp_executesql to...
2018-09-24 (first published: 2018-09-13)
3,696 reads
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 feels...
2018-09-11
209 reads
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...
2018-09-13 (first published: 2018-09-05)
3,562 reads
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...
2018-09-03
799 reads
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...
2018-08-29
518 reads
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, if...
2018-08-27
884 reads
#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...
2018-09-06 (first published: 2018-08-22)
1,651 reads
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...
2018-08-20
216 reads
What are my permissions?
Permissions are a common concern. One of the most frequent requests I get is I need X, Y and Z...
2018-08-29 (first published: 2018-08-16)
3,193 reads
Blogs
Export a Power BI Report that cannot be Downloaded
Yes, you’re reading that right, we’re going to download a report that cannot be...
Query Intelligence in SQL Server 2025: What Developers Need to Know
By Chris Yates
When Microsoft announced SQL Server 2025, I was curious about what would truly change...
Finding and Killing Blockers with Redgate AI Tech
By Steve Jones
Redgate has a research arm, called the Foundry, that has been experimenting with AIs...
Forums
Poor Name Choice
Comments posted to this topic are about the item Poor Name Choice
Getting the Indexed Columns
Comments posted to this topic are about the item Getting the Indexed Columns
T-SQL in SQL Server 2025: Substring Changes
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Question of the Day
Getting the Indexed Columns
I run this code on SQL Server 2022 to get a list of all the indexes and their key columns. What is returned?
SELECT
INDEX_COL (N'AdventureWorks2017.Sales.SalesOrderDetail') See possible answers