Leveraging the Script Activity within Azure Data Factory
The post Leveraging the Script Activity within Azure Data Factory appeared first on SQLServerCentral.
Cassandra Springboot Integration
Article Overview In this article, we will learn how to integrate a Spring boot application with a Cassandra database. This article will help us understand what Cassandra is, why is it needed, how to install it, how to use it, and finally how to integra …
Is There a Bug in SQL Server’s MAXDOP Calculation?
I think I’ve found a bug in SQL Server setup’s MAXDOP calculation, and I need you to take a second look. Setup is recommending MAXDOP 8: Which is odd, because this is running on an AWS i3.16xlarge with 2 sockets, 2 NUMA nodes, 32 logical pr …
Who’s Hiring in the Microsoft Data Platform Community? November 2022 Edition
Is your company hiring for a database position as of November 2022? 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 must i …
Welcome to the Black Friday Sale of a Lifetime.
Every November, we run a Black Friday sale with huge discounts on our training and apps. Sales are open now with deep discounts on bundled subscriptions that give you the training and online services you need to be a top-notch SQL Server professional: …
SAP S/4HANA and Microsoft Azure SQL Integration and Hard Deletion Handling
This article will demonstrate the heterogeneous systems integration and building of the BI system and mainly talk about the DELTA load issues and how to overcome them. The main issue is: how can we compare the source table and target table when we cann …
How SQL Monitor gives developers the information they need to develop faster and smarter
The post How SQL Monitor gives developers the information they need to develop faster and smarter appeared first on SQLServerCentral.
SQL Cheat Sheet for Basic T-SQL Commands
The post SQL Cheat Sheet for Basic T-SQL Commands appeared first on SQLServerCentral.
The PASS Sessions I Am Most Excited For
The PASS Data Community Summit is coming up in less than three weeks, so it is time to start finalizing your schedule. My schedule this year is fixed, as I will be working behind the scenes helping to manage one of the live online tracks. But that does …
The PASS Data Community Sessions I Am Most Excited For
Note: Edited to add more sessions… So many The PASS Data Community Summit is coming up in less than three weeks, so it is time to start finalizing your schedule. My schedule this year is fixed, as I will be working behind the scenes helping to ma …
Introducing the MySQL UPDATE statement
Entry in Robert Sheldon’s series on Learning MySQL. The series so far: Getting started with MySQL Working with MySQL tables Working with MySQL views Working with MySQL stored procedures Working with MySQL stored functions Introducing the MySQL SELECT s …
Expert-led PASS Data Community Summit Pre-cons
The post Expert-led PASS Data Community Summit Pre-cons appeared first on SQLServerCentral.
SQL Server Engineering Using Free Tools
You can master engineering for your SQL Server databases, on premises or in the cloud, with a FREE toolkit! SQL Server engineering tasks can be challenging in many ways, and some tasks just seem harder than really necessary. You can make those tasks mu …
SQL Stored Procedure Input and Output Parameters, Types, Error Handling, Security and more
The post SQL Stored Procedure Input and Output Parameters, Types, Error Handling, Security and more appeared first on SQLServerCentral.
[Video] Office Hours: Answering Your Microsoft Data Platform Questions
Ask questions at https://pollgab.com/room/brento and upvote the ones you’d like to see me cover. Here’s what we covered today: 00:00 Start 00:59 neil: is it dangerous/risky to expand a drive in azure with SQL data files on it? sql on azure …