Level Up!
Great news! I was accepted this weekend to speak at SQLSaturday Los Angeles! This officially counts as a level up for me for my deadlock resolution quest. The event...
2020-02-25
21 reads
Blog Posts
Renewed as a Friend of Red Gate
I recently received the news that I’ve been renewed as a Friend of Red Gate. I’ve been a big fan of Red Gate since the days when SQL Compare...
2020-02-25
19 reads
Why I Support Code Automation Tools Like ORMs
I know I’m a weirdo. I’ve always been a weirdo. When I was a DBA (now I only play one on TV), I was a weirdo too. Case in...
2020-02-25 (first published: 2020-02-17)
546 reads
Extended Events: Database Auditing
Extended Events can do things that simply are not possible with Profiler and another example comes from the stack of audit events that exist only in Extended Events. One...
2020-02-24
60 reads
Implementing HA on MSSQL Server (AlwaysOn Availability group)in an on-premise environment (Part 1)
I am very passionate about having a disaster recovery architecture, plan and strategy. This is very important for business continuity. I will be walking you through a journey on implementing High Availability (HA) (AlwaysOn Availability group) on MSSQL Server.
2020-02-24 (first published: 2020-02-14)
707 reads
Redgate Software Needs You!
I’ve been very blessed to be able to work for Redgate Software. We’ve done some amazing stuff over the years. We’re going to be doing even more amazing stuff...
2020-02-24
37 reads
SheLeadsTech Webinar: Braving the Wilderness of Cybersecurity
ISACA has a SheLeadsTech webinar for tomorrow, February 25, 2020 titled Braving the Wilderness of Cybersecurity. Registration Link: https://www.isaca.org/education/online-events/lms_w022520 If you can’t make the talk, ISACA archives all webinars...
2020-02-24
22 reads
Speaking for Omaha Azure User Group Wednesday
This Wednesday, February 26th, I will be presenting a new session entitled “All Things SQL in the Microsoft Cloud” for the Omaha Azure Users Group, starting at 6pm Central...
2020-02-24
11 reads
Top 3 Database Life Hacks
Three very powerful but simple hacks that can give you back dozens of minutes per day.
Related Posts:
Best New(ish) SSMS Feature December 26, 2017
Puzzles and Daily Trivia May 14,...
2020-02-24 (first published: 2020-02-12)
1,456 reads
Use Jupyter Notebooks to Help People on StackOverFlow
I am sat in the PowerShell Saturday in Hamburg. You can see me on the right of this picture writing my previous blog post! I was talking with my...
2020-02-22
50 reads
Blogs
Accept the no and move on
By Brian Kelley
Here is a short emotional intelligence (EI) post for today, courtesy of Seth Godin....
Don’t Fight with AI
By Steve Jones
I was recently trying to handle a simple task with a few AI tools...
Narrow Task Decomposition in AI Pipeline Agents
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
Forums
Searching for my own posts
I have a really stupid question... Is there an easy way to search for...
How to Work with On-Premises AI Models to Generate T-SQL Code
Comments posted to this topic are about the item How to Work with On-Premises...
Escaping Strings
Comments posted to this topic are about the item Escaping Strings
Question of the Day
Escaping Strings
The STRING_ESCAPE() function requires 2 parameters in SQL Server 2025. The first is a string of text and the second is the type of escape rules being used. What are the options for the second parameter?
See possible answers