TGI SQL Friday - 16th September 2016 Weekly roundup
I have had an interesting week teaching Learning Tree course 534 Developing SQL Queries for SQL Server. I had an...
2016-09-16
449 reads
Blog Posts
Using Logins and Certificates to evelate Permissions
Problem
A common question I get asked by SQL developers is to be able to query the sys.dm_db_index_usage_stats table to see...
2016-09-16
1,058 reads
"SQL Server Permissions and Security Principals" at SQLSaturday Charlotte This Weekend!
I'll be presenting my talk on SQL Server Permissions and Security Principals this weekend at SQLSaturday #560 Charlotte, NC.
As a SQLSat...
2016-09-15
380 reads
#SQLSpeaking this Fall!
I have some great speaking dates coming up this Fall - here is the list:
--
First - the big one. I am honored...
2016-09-15
427 reads
Converting SQL Agent Job Duration to TimeSpan using PowerShell
When you look in msdb for the SQL Agent Job duration you will find that it is an int.
This is...
2016-09-15 (first published: 2016-09-12)
1,495 reads
Emojis in SQL Server
I blame Aaron Bertrand (b/t) and Kevin Kline (b/t). Aaron who posted a great #BackToBasics blog about naming stored procedures...
2016-09-15
1,312 reads
Future DBA part 2
I do not say you should be expert in other technologies but you should be aware of what it is...
2016-09-15
390 reads
Great Value IT Training - Awesome ITIL offers
This week's Great Value IT Offers are in. If you want to your ITIL learning on this autumn we have...
2016-09-15
383 reads
More PowerShell for the Azure World
The collection of Azure SQL Database cmdlets can be found at – https://msdn.microsoft.com/en-us/library/mt574084.aspx. There are alot, however I tend to use...
2016-09-15
493 reads
Quick #SQLPrompt Tips – Expanding Wildcards
I tend to try and get code on the screen quickly and then start to remove things. I’m a visual...
2016-09-15
618 reads
Blogs
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Cleaning Up My Blog's SEO and AEO with Claude in GitHub Copilot
I’ve been running this blog on Hugo for a long time, and like most...
Using the SIGN() Function: #SQLNewBlogger
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers