Daily Coping 18 May 2020
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-05-18
16 reads
SQL Prompt Fixes Missing Begin End in Procs
SQL Prompt is a fantastic coding aid, but it does more than format your code and provide intellisense. Over time, the team has enhanced SQL Prompt to also guide...
2020-06-01 (first published: 2020-05-18)
241 reads
Negative (-) is an operator and will affect the order of operations.
An interesting question came to my attention the other day. A strange operation problem in SQL Server: -100/-100*10 = 0 ... Continue reading
2020-05-18
414 reads
LANDMARK OF 1000 SUBSCRIBERS ACHIEVED. THANK YOU ALL FOR SUPPORT.
Thank you, everyone, to stay along with me on this journey. I started this blog for the self repository of SQL Server knowledge articles, Later I made it public...
2020-05-18
35 reads
Which Azure Data Platform service should I choose?
So you’ve decided to use Azure for your existing or new data project? This blog series is focused on choosing the right technology for your project. It’s tough right?...
2020-05-28 (first published: 2020-05-17)
788 reads
Stairway to Microsoft Azure SQL Database Part 3 : Purchase Models DTU vs vCore continue
In the last post, we have discussed the DTU purchase model. Azure also provides another purchase mode which is called vCore. vCore purchase model available with all three deployment...
2020-05-17
11 reads
Stairway to Microsoft Azure SQL Database Part 3 : Purchase Models DTU vs vCore continue
In the last post, we have discussed the DTU purchase model. Azure also provides another purchase mode which is called vCore. vCore purchase model available with all three deployment...
2020-05-26 (first published: 2020-05-17)
839 reads
Power BI Monthly Digest – April 2020
This month we will likely have two releases of the Power BI Desktop. The April release was delayed into May so it could be announced
2020-05-15
80 reads
Daily Coping 15 May 2020
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-05-15
30 reads
Formatting Code in ADS with SQL Prompt
One of the most popular and widely used features of SQL Prompt is formatting code. The SQL Prompt extension is in public preview and you can get it here....
2020-05-27 (first published: 2020-05-15)
311 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