One Flyway Migration Script for Diverse Database Systems
The post One Flyway Migration Script for Diverse Database Systems appeared first on SQLServerCentral.
Disable or Enable All SQL Server Agent Jobs
The post Disable or Enable All SQL Server Agent Jobs appeared first on SQLServerCentral.
[Video] Office Hours: Ask Me Anything About SQL Server in Stokkseyri
Before Fjöruborðið opens for lunch, I answer a few of your questions from https://pollgab.com/room/brento including: 00:00 Introductions 00:29 Peter: What is your opinion about the SQL generated by Entity Framework? 02:00 Peter: When would …
[Video] Office Hours: Ask Me Anything About SQL Server On My Patio
I sit on the porch and discuss your highly voted questions from https://pollgab.com/room/brento. Today’s discussion includes: 00:00 Introductions 00:27 DK: What was your Gordian Knot problem? 03:25 George: How exactly does locking work on INSERT …
How To Find A Perfect Match
Introduction This article presents a script that finds a perfect match in any bipartite graph or shows why one cannot exist. Overview Recall that a bipartite graph is any undirected graph [1] where its nodes (or vertices) can be partitioned into two se …
Plotting in Python for Financial Time Series Data for Exponential Moving Averages
The post Plotting in Python for Financial Time Series Data for Exponential Moving Averages appeared first on SQLServerCentral.
Sharing knowledge in communities of practice
The post Sharing knowledge in communities of practice appeared first on SQLServerCentral.
Register Now For PASS Data Community Summit 2021
The post Register Now For PASS Data Community Summit 2021 appeared first on SQLServerCentral.
Create, Populate, and Subset a Pandas Dataframe from a CSV File
The post Create, Populate, and Subset a Pandas Dataframe from a CSV File appeared first on SQLServerCentral.
[Video] Office Hours: Ask Me Anything at the Westman Islands Harbor
You upvoted questions at https://pollgab.com/room/brento, and today I’m at the harbor in Heimaey to cover ’em. Questions we talked through: 00:00 Introductions 01:00 Zach: What happens when I change a VARCHAR(MAX) to VARCHAR(2500)? 04:26 Sc …
Who’s Hiring in the Database Community? September 2021 Edition
Is your company hiring for a database position as of September 2021? Do you wanna work with the kinds of people who read this blog? Let’s set up some rapid networking here. If your company is hiring, leave a comment. The rules: Your comment …
Connect to and Query Salesforce Data in QlikView
QlikView is a business discovery platform that helps anyone perform self-service business intelligence. This article explains how to use the CData ODBC Driver to connect to Salesforce data and create data visualizations in …
Discovering What’s Changed by Flyway Migrations
The post Discovering What’s Changed by Flyway Migrations appeared first on SQLServerCentral.
Join SQL Server tables where columns include NULL values
The post Join SQL Server tables where columns include NULL values appeared first on SQLServerCentral.
[Video] Office Hours at the Eldfell Volcano Crater
You posted and upvoted questions at https://pollgab.com/room/brento, and I ascended – well, drove into – the Eldfell Volcano in the Westman Islands to answer ’em: Questions we covered in the video: 00:00 Introductions 01:55 Do you not …