Guy Glantser is an Israeli SQL Server guru with a ton of great presentations on YouTube. I’ve had the privilege of hanging out with him in person a bunch of times over the year, and I’ll always get excited to do it again. He’s not just smart, but he’s friendly and funny as hell.
I recently came back from a trip to Las Vegas. I was privileged to be able to take part in the very first Fabric Community Conference. It was a great event, well attended. BUT... It was in Las Vegas. I am not a fan. First of all, Vegas is just far too noisy for me. […]
In this article, learn how to use the PowerShell DSC to patch your SQL Server instances.
Steve asks the question today about when you might think about changing employers. He has some advice for you, whether you're happy or in need of a new position.
In this step-by-step article, learn how to quickly install Python and start writing Python code using Jupyter Notebooks or Visual Studio Code.
A CTE is a temporary result set defined by a simple query, and is used within the execution scope of a single INSERT, UPDATE, DELETE, or SELECT statement. In this article we will explore how to define and use CTE's.
Today Steve discusses a disturbing trend, where technical workers are being thrown under the bus by management.
Andy Leonard discusses and demonstrates using Fabric Data Factory to load a CSV file stored in Azure Blob Storage to Azure SQL DB.
New enhancements in SQL Server 2024 will allow MongoDB and Cassandra clients to store their data in a SQL Server database, in native NoSQL format.
In a previous post we went through how to use Docker Build Cloud to...
By Steve Jones
We’re taking the roadshow across the water. Hope the plane makes it. The Redgate...
SQL aggregate functions are your go-to tools for transforming raw data into actionable insights....
Comments posted to this topic are about the item Creating Statistics on XML
Comments posted to this topic are about the item Managing SQL Agent in Azure...
Hi, I hope this isn't too long of a question- I tried to make...
I have a table in SQL Server 2022 that is an XML data type. I have an index on this column and want to create statistics using CREATE STATISTICS for some of the data in the column. What should I do?
See possible answers