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 …
[Video] Office Hours: Nine Minutes of Answers
Post your questions at https://pollgab.com/room/brento and upvote the ones you’d like to see me discuss during my live streams. This week, I took a break from working on my PASS Summit sessions in order to chat: Here’s what we covered: 00:0 …
Oracle optimizer Or Expansion Transformations
Jonathan Lewis’ continuing series on the Oracle optimizer and how it transforms queries into execution plans: Transformations by the Oracle Optimizer The effects of NULL with NOT IN on Oracle transformations Oracle subquery caching and subquery pushing …