Create, Populate, and Subset a Pandas Dataframe from a CSV File
In this article we demonstrate how to transfer data via a CSV file from a SQL Server database to a Pandas dataframe and then subset the dataframe in Python.
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.
Where We Need Better AI Disclosure and Responsibility
The way that AI is used in the world can make it better, but not always. In either case, we ought to have some accountability for the models.
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.
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.
Eyes Wide Open
Trying to architect a new database system so that you don't outgrow it is a challenge, but the more you think about early, the better off you will be.
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 […]
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.
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.
What to do with more free time
Many data professionals have begun working remotely over the past year and a half which translates to less time spent commuting. In my own case, I’ve been a remote worker for almost ten years, but before that I spent two hours on the road each day. This got me wondering what folks have done with […]
Blogs
Should I Learn PostgreSQL
By Steve Jones
I got asked this question recently: I constantly see PostgreSQL on Microsoft slides, email,...
A New Word: Hickering
By Steve Jones
hickering – n. the habit of falling hard for whatever pretty new acquaintance happens...
Minimize Downtime with SQL MI Disaster Recovery
By Arun Sirpal
I speak to many people who use cloud technologies, especially database tech and how...
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