ANSI PADDING
https://learn.microsoft.com/en-us/sql/t-sql/statements/set-ansi-padding-transact-sql?view=sql-server-ver16
Linked servers: a peek behind the curtain
We recently received a support call from a Gallium Data user. He was executing queries on his instance of SQL Server, but these queries were getting mysteriously changed, which caused his logic in Gallium Data to not run as expected. What was going on? Editor: This looks great. Enter linked servers This issue was caused […]
Monitoring Azure Blob Storage
Learn about how you can monitor your Azure Storage account and set alerts to let you know when to take action.
Different ways to Convert a SQL INT Value into a String Value
In this article we cover different ways to convert a SQL Server numeric value into a string value.
Four ways to elevate team efficiency and code quality
IDC have reported that ‘the shortage of full-time developers will increase from 1.4 million in 2021 to 4.0 million in 2025’. So how do teams keep pace with business demands, without relying on recruiting extra staff? Discover 4 ways that teams can elevate efficiency and code quality to speed up delivery of accurate database changes.
Azure Synapse Link for SQL: From production to a data warehouse in a few clicks
Microsoft announced Azure Synapse Link for SQL. In this article, MVP Dennes Torres explains the new feature.
Using Graph Theory To Group Records
Learn a little basic graph theory in this article that replaces a GROUP BY clause.
Blogs
Convert SQL Audit Files to a CSV Using Read-SqlXEvent
By Patrick
SQL Server Audit is an efficient way to track and log events that occur...
Control Flow Restartability in Azure Data Factory
I presented at SQL Saturday Pittshburgh this past weekend about populating your data warehouse...
Monday Monitor Tips: Knowing Your RPO
By Steve Jones
A customer was asking recently about the RPO for their estate, and I showed...
Forums
New article
Comments posted to this topic are about the item New article
Monitoring Azure Blob Storage
Comments posted to this topic are about the item Monitoring Azure Blob Storage
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers