Azure Data Factory vs SSIS vs Azure Databricks
The post Azure Data Factory vs SSIS vs Azure Databricks appeared first on SQLServerCentral.
How Bad are Bad Page Splits – The Rest of the Story
In Part 1 of this article we looked at a specific use case (probably exaggerated) that gave us an idea about how CPU and IO performance might be affected by a bad page split. We continue this analysis looking at what really happens to the data on the l …
Easily manage SQL Server licensing with SQL Monitor 10.1
The post Easily manage SQL Server licensing with SQL Monitor 10.1 appeared first on SQLServerCentral.
What Do You Do Better Than the Cloud?
It sounds like a trick question, but I’m serious. If your company’s management is just now starting to consider the cloud in 2020, your reaction shouldn’t be to cast a shadow on cloud vendors. Instead, think of it as writing your own …
SQL Server Data Masking with DbDefence
The post SQL Server Data Masking with DbDefence appeared first on SQLServerCentral.
You Can Disable Parameter Sniffing. You Probably Shouldn’t.
During my parameter sniffing classes, people get a little exasperated with the complexity of the problem. Parameter sniffing is totally hard. I get it. At some level, it’d be great to just hit a magic button and make the whole thing go away. So i …
Generate Role Member Reports using dbatools and the ImportExcel PowerShell modules
As one of dbatools’ first members, I’ve been using it for years and it’s really my goto tool. This task was no different! Today’s tip and trick using dbatools is about generating an Excel workbook that contains lists o …
Understanding Views in SQL
The post Understanding Views in SQL appeared first on SQLServerCentral.
The post Redgate Streamed appeared first on SQLServerCentral.
All 2020 classes now online in September and October!
Back in April when nearly everyone was locked down, we moved all our Chicago classes to October. Now, given the continuing COVID-19/coronavirus pandemic and the many travel restrictions companies have in place, we decided that in-person classes ar …
Things To Consider When Submitting Sessions to Paid Online Conferences
Lots of paid conferences are happening online these days, so some of you will be presenting an online session or pre-con for the first time. I’ve done a bunch of these and been burned in a bunch of ways, so lemme save you some time and heartache. …
Creating a Serverless Database in Azure
I have been experimenting with Azure in my spare time, trying to better understand this cloud service and how I can use it for data projects. My employer is considering building some applications here, so I want to be prepared. In this article, I decid …
Cloud adoption rates see increase in 2020
The post Cloud adoption rates see increase in 2020 appeared first on SQLServerCentral.
Using SQL Server Profiler to Capture Stored Procedures Executions
The post Using SQL Server Profiler to Capture Stored Procedures Executions appeared first on SQLServerCentral.
Sit Down. We Need to Talk About Your Scalar Functions.
Thanks for coming today. I apologize for baiting you in here with a picture of toilet paper. That’s not even in the US – that’s from my Iceland trip, before I flew back here to the US. Look, we all make mistakes. That’s not the …