Why is the XLOCK table hint broken?
Let’s talk about what XLOCK is supposed to do. XLOCK is a table hint that can be applied to a query to place an exclusive lock on the resources...
2020-02-20 (first published: 2020-02-12)
462 reads
T-SQL Tuesday #123 – Life Hacks
Jess Pomfret is hosting month’s T-SQL Tuesday, and asked us to share our favorite life hacks – something that makes our day easier. I have a few,some people have told...
2020-02-12
6 reads
T-SQL Tuesday #123 – Life Hacks
Jess Pomfret is hosting month’s T-SQL Tuesday, and asked us to share our favorite life hacks – something that makes our day easier. I have a few,some people have told...
2020-02-12
4 reads
T-SQL Tuesday #123 – Life Hacks
Jess Pomfret is hosting month’s T-SQL Tuesday, and asked us to share our favorite life hacks – something that makes our day easier. I have a few,some people have told...
2020-02-19 (first published: 2020-02-12)
543 reads
Power BI Real-time Streaming
With Power BI real-time streaming, you can stream data and update dashboards in real-time. Any visual or dashboard that can be created in Power BI can also be created...
2020-02-19 (first published: 2020-02-11)
3,022 reads
Be Kind
Simply put, we are not always going to agree. Please, take this as someone who was nicknamed “The Scary DBA” for reasons comic and tragic. I’ve screwed up a...
2020-02-18 (first published: 2020-02-11)
480 reads
Configure your tools : T-SQL Tuesday #123
Happy T-SQL Tuesday! Thanks for hosting this month Jess Pomfret (blog|twitter) and great topic. Life Hacks. There is one thing ... Continue reading
2020-02-18 (first published: 2020-02-11)
645 reads
T-SQL Tuesday 123: Life Hacks to make your day easier
This month’s T-SQL Tuesday is hosted by Jess Pomfret. Jess’s theme is ‘Life Hacks to make your day easier’. She talks of some things we do to make life...
2020-02-17 (first published: 2020-02-11)
814 reads
Azure SQL Database and Error Handling
For some reason I have friends / colleagues telling me that when scaling (up and down for this example) that no downtime occurs. Well, not only does Microsoft documentation...
2020-02-11
282 reads
T-SQL Tuesday #123: Lifehacks to Make Your Day Easier
This month, Jess Pomfret (blog | twitter) is trying to beat the winter motivation slump by exploring, and asking us to share, our lifehacks that make daily life a...
2020-02-11
6 reads
Blogs
T-SQL Tuesday #201: Temp Tables
By Steve Jones
This month we have a new host, which I am grateful for. So many...
When Do You Reach For A #temp Table?
I needed to do some research because there is more to #temp tables than...
Accept the no and move on
By Brian Kelley
Here is a short emotional intelligence (EI) post for today, courtesy of Seth Godin....
Forums
jdbc auth failing to sql from sap's cloud middleware CPI
hi , our business partner is asking s4 sap api's for receivable info and...
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...
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