Maintaining Security and Performance using Stored Procedures Part I – Using EXECUTE AS
Anyone who knows me, or has worked with me, knows that I am a proponent of using stored procedures for...
2009-10-14
1,825 reads
Jack Corbett
- Interests: Sports, books, Bible
Here Comes SQLSaturday 21 – Orlando
Here it comes! The big event on my schedule SQLSaturday #21 –Orlando. We’ve got over 300 registered so it should...
2009-10-11
495 reads
Maintaining Security and Performance using Stored Procedures Part I – Using EXECUTE AS
Anyone who knows me, or has worked with me, knows that I am a proponent of using stored procedures for...
2009-10-08
1,553 reads
Index on a Foreign Key?
About two weeks ago, I had a discussion on Twitter and via email with Jeremiah Peschka (@peschkaj) about placing indexes...
2009-10-06
660 reads
Speaking at SQLSaturday #21 – Orlando
Well, I guess this isn’t a surprise since I put together the schedule, but I’m still excited to be speaking...
2009-10-01
313 reads
On vs. Where
Does it matter if you put your criteria in the ON clause or the WHERE clause? Well, as with most...
2009-09-30
1,778 reads
Venturing into Powershell
As you probably know if you read my blog regularly, I recently put together a presentation called, Dive into the...
2009-09-23
500 reads
September OPASS Meeting Recap
OPASS met last Tuesday, September 14th, with a mini (15 minute) presentation by Todd Holmes on Backup Basics and Jorge...
2009-09-22
436 reads
What happened to that email?
This question:
Created script to send mails using sp_send_dbmail- working like a charm.
Now searching for a way to get...
2009-09-17
1,143 reads
Orlando PASS Meeting
Tonight is the OPASS bi-monthly meeting. Todd Holmes will be giving a mini presentation on SQL Server Backups and out...
2009-09-15
486 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