Monitoring Azure SQL Databases
There are many reasons you should monitor your databases, including avoiding performance problems or running out of disk space. Ideally, you want a scalable monitoring solution where you can monitor all your SQL databases in one single place. This article will describe two options that are available: Azure SQL Analytics and Azure SQL Insights. Both […]
Bulk Formatting of the SQL Server SQL Files
In this article, Phil Factor explains how to apply SQL formatting styles as part of an automated process, using the SQL Prompt command line formatter, with examples of bulk applying styles from the command prompt, PowerShell or a DOS batch.
The effects of NULL with NOT IN on Oracle transformations
IN and NOT IN subqueries are frequently used in Oracle. Jonathan Lewis explains how the optimizer handles NULL with IN and NOT IN.
Prevent Accidental Resource Deletion Using Locks in Azure Data Factory
Learn how to protect production resources from accidental changes in Azure Data Factory.
The Chief Data Officer
The idea of a Chief Data Officer is growing in many companies. Steve thinks this is a good thing.
Summit 2022 Call for Speakers Now Open
Share your knowledge and insights at the world's largest gathering of data platform professionals! The PASS Data Community Summit conference is going hybrid this year, and whether you're planning to attend in-person in Seattle or online, this is your chance to reach a global audience and advance your career as a speaker. If you're an expert in a data-related topic, we want to hear from you. Speakers of all experience levels are welcome to submit a proposal and the Call for Speakers is open until March 31. Registration also opens on March 24, so don't miss your chance to register for Summit's homecoming in Seattle at early bird pricing.
The basic T-SQL SELECT statement
The SQL language is used across many relational database platforms. Greg Larsen explains the basics of the SELECT statement for SQL Server.
Query History and Server Reports in Azure Data Studio
Introduction to Query history and server reports i...
The Challenges of Changing Software Tools
The way different generations use computers could affect how we built software tools.
Blogs
Simple Talks Episode 9–Data masking and subsetting
By Steve Jones
The episode on data masking and subetting is out. You can see it here:...
T-SQL Tuesday #180: Avoid Perfect for Good Enough
By Brian Kelley
I'm listening to Effortless by Greg McKeon (link to author's page) through Audible.com. He...
Book Review – Humanizing Data Strategy by Tiankai Feng
This book was making its rounds on social media, and the concept seems interesting...
Forums
SQL server help (converting rows to columns)
I am using the following sql to convert rows into columns for each pid,...
Ingesting Data From REST API endpoints: Data Engineering with Fabric
Comments posted to this topic are about the item Ingesting Data From REST API...
Separate Reads
Comments posted to this topic are about the item Separate Reads
Question of the Day
The Hash Join I
What are the two inputs called to a hash join operation in SQL Server? (choose 2)
See possible answers