I wrote about TempDB Internals and understand that Tempdb plays very important role on SQL Server performance and everything temporary / memory spill comes to tempdb and it is...
2026-03-09 (first published: 2026-03-02)
507 reads
I wrote about TempDB Internals and understand that Tempdb plays very important role on SQL Server performance and everything temporary / memory spill comes to tempdb and it is...
2026-03-02
8 reads
continuing from Day 1 where we covered the history of AI and GPT family, today on Day 2 i would like to discuss what came next after Generative AI...
2026-03-02
23 reads
it has been a year since i have not written much on the blog and i would like to start a “blog a day” series. i have been continuously...
2026-03-01
34 reads
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part of all the Versions!! 7 (70)– Foundation, OLAP Services, Query Analyzer 2000 (80) – SSAS,...
2026-02-27 (first published: 2026-02-26)
25 reads
Microsoft announced on November 2024 a preview for SQL Server 2025 another major release /revolution from Microsoft SQL Server prospect, including – AI Buildin’, as AI plays an important...
2025-01-19
137 reads
As this is an Artificial Intelligence (AI) World, things are changing. We can see that everywhere you look, even now, when writing a blog, I could feel it today :)....
2024-12-01
42 reads
this month is the big month and a month to remember their are so many announcements has been done in this month – May -2024 . As this is...
2024-05-23
37 reads
yes SQL Server 2022 is coming and would have many advance features. https://www.microsoft.com/en-us/sql-server/sql-server-2022 whats new in SQL Server 2022 would be know more here: https://techcommunity.microsoft.com/t5/microsoft-mechanics-blog/what-s-new-in-sql-server-2022/ba-p/2922227 Bob Ward would be...
2021-11-07
195 reads
Azure arc is another great stuff coming with Microsoft Azure, as we were expecting Azure cloud Microsoft has great DevOps options and nice for everyone. Azure has multiple subscribtion...
2021-06-20
66 reads
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
By Steve Jones
It’s been some time since I provided a car update, so I decided to...
By James Serra
An architecture scenario Imagine separate Sales, Finance, Shared Data, and Executive Analytics workspaces. Sales...
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...
Comments posted to this topic are about the item 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