Connect to and Query Salesforce Data in QlikView
This short article shows how to connect to Salesforce data with CData and produce a chart from a query.
2021-09-01
661 reads
Articles
Discovering What’s Changed by Flyway Migrations
A set of PowerShell cmdlets that will 'diff' two versions of a database and provide a high-level overview of the major database changes made by successive Flyway migrations. You can 'diff' a SQL Server database to the same one on PostgreSQL and find out which objects are the same and which are different.
2021-09-01
Join SQL Server tables where columns include NULL values
Dealing with NULL values especially when joining tables can become a challenge. Let's take a look at this issue and how this can be resolved.
2021-09-01
Tracking Failed Job Steps
Recently a customer was asking for a way to alert on job steps that failed, but the job succeeded. They really wanted a custom metric for SQL Monitor, which I submitted, but this post looks at the query in general, trying to determine if a job step failed. Note: Let me start by noting that […]
2021-08-30
7,654 reads
Diagnose and resolve latch contention on SQL Server
This guide describes how to identify and resolve latch contention issues observed when running SQL Server applications on high concurrency systems with certain workloads.
2021-08-30
Schedule Azure SQL DB Processes using Azure Functions
Learn how to schedule processes in Azure SQL Database using an Azure Function in this easy to follow step by step tutorial.
2021-08-30
Formatting T-SQL Scripts using ScriptDOM and PowerShell
Well-formatted scripts are always easier to maintain and enhance readability to high degree. Formatting standards are an important part of coding standards anywhere and if not, they need to be. If there are a large number of scripts this can add up to a significant amount of time needed to maintain them. It is also […]
2021-08-27
9,427 reads
Executing a TSQL batch multiple times using GO
Learn how to execute the same batch of SQL Server commands X number of times using the GO command.
2021-08-27
Flyway with SQLite for Those of a Nervous Disposition
Get started with running Flyway migrations on SQLite databases, using PowerShell.
2021-08-27
Azure Data Factory Incremental Pipeline from Azure SQL Database to Databricks
In this tip find out how to use Azure Data factory to build an incremental pipeline from Azure SQL Database to Databricks.
2021-08-25
Blogs
The Intersection Between DevOps and FinOps
By HeyMo0sh
DevOps is about shortening the system development lifecycle. Plan faster, build faster, test faster,...
Fabric Mirroring doesn’t start copying Rows
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
Forums
PostgreSQL String Functions Part 1
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
Working Better Under Pressure
Comments posted to this topic are about the item Working Better Under Pressure
Identities and Sequences V
Comments posted to this topic are about the item Identities and Sequences V
Question of the Day
Identities and Sequences V
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers