PASS Summit 2019 starts up next Monday with pre-conference sessions. I’ve got my schedule all set, and I’m going to be busy: I’m speaking in two full-day pre-conference sessions,...
2019-10-30
15 reads
sometime we observed that errorlog recycle is failed this happens when we monitor/read errorlog using our monitoring tool or monitoring application/scripts during this task if we want to recycle...
2019-10-29
33 reads
I am honored to have been selected to speak at SQL Saturday Oregon this year. They always have so many sessions submitted with only 40 slots available. I was...
2019-10-29
14 reads
Hello and good morning! We have Tuesday morning, which means I experienced a delay in this post. But finally, it is out and have a look at how much...
2019-10-29
22 reads
This is the final installment in my series of posts which I hope will help you (and me!) prepare for the upcoming PASS Summit November 4-8, 2019 in Seattle,...
2019-10-29
15 reads
Watch this week's video on YouTube
With the release of SQL Server 2019 imminent, I thought it'd be fun to rank which features I am most looking forward to in...
2019-10-29
12 reads
Watch this week's video on YouTube
With the release of SQL Server 2019 imminent, I thought it'd be fun to rank which features I am most looking forward to in...
2019-10-29
13 reads
Watch me comment on all of the features in this week’s video. With the release of SQL Server 2019 imminent, I thought it’d be fun to rank which features...
2019-10-29
551 reads
(2019-October-16) Developing conditional logic of your Azure Data Factory control flow has been simplified with introducing of the Switch activity - https://docs.microsoft.com/en-us/azure/data-factory/control-flow-switch-activity. Official documentation resource states, this new data factory activity "provides...
2019-10-29 (first published: 2019-10-16)
8,572 reads
Query hints are always about tradeoffs—typically you are giving up something, such as flexibility, to achieve more consistency, or very specific performance characteristic. One example of this migt when...
2019-10-29 (first published: 2019-10-16)
1,029 reads
By Brian Kelley
Fabiano Amorim has written an excellent article at Simple Talk on securing msdb. Here's...
By Steve Jones
This month we have a new host, which I am grateful for. So many...
I needed to do some research because there is more to #temp tables than...
hi , our business partner is asking s4 sap api's for receivable info and...
I have a really stupid question... Is there an easy way to search for...
Comments posted to this topic are about the item How to Work with On-Premises...
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