SQL Server stores the full definition of certain T-SQL objects — Stored Procedures, Functions, Views, and Triggers — in their original form,...
2018-01-09
943 reads
Let’s say you need to create a new SQL Server database, which is going to grow very fast, but you...
2018-01-18 (first published: 2018-01-08)
1,771 reads
There is a growing need for Graph Databases in the market. This is a type of database, which is capable...
2018-01-08
560 reads
Have you ever had a script where you needed to run parts of it on different instances of SQL Server...
2018-01-08
443 reads
Query tuning ain’t easy.
Figuring out which index is getting used is one step, and generally simple, look at the execution...
2018-01-17 (first published: 2018-01-08)
2,250 reads
Some of my previous articles on Python provided insight of the basics and the usage of Python in SQL Server...
2018-01-08
817 reads
Today I found out that it is now possible to enable the setting optimize for ad-hoc workloads at the database...
2018-01-16 (first published: 2018-01-08)
1,605 reads
First blog post of the year and I’d like to take the opportunity to wish everyone the best, professionally and...
2018-01-08
359 reads
The latest security issue with the name "Meltdown and Spectre" affecting Intel processors was made public last week. This security...
2018-01-08
617 reads
Hey everyone, hope you all had a great Christmas and New Year!
I took December off from blogging as had started...
2018-01-08
361 reads
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Comments posted to this topic are about the item The New World Of AI...
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Security has long been a problem for me. Every time I think I understand...
What does this return on SQL Server 2025?
select bit_count(null)See possible answers