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 …
Hands-On with Columnstore Indexes: Part 2 Best Practices and Guidelines
The series so far: Hands-On with Columnstore Indexes: Part 1 Architecture Hands-On with Columnstore Indexes: Part 2 Best Practices and Guidelines A discussion of how columnstore indexes work is important for making the best use of them, but a practical …
How to Upgrade SQL Server Evaluation Edition to Developer Edition
Six months ago today, you installed SQL Server Evaluation Edition. You told yourself you’d take care of that sooner or later, and…you forgot. Now, your SQL Server won’t start: Error 17051: SQL Server evaluation edition has expired. A …
When SQL Server Performance goes Bad: the Fill Factor and Excessive Fragmentation
The post When SQL Server Performance goes Bad: the Fill Factor and Excessive Fragmentation appeared first on SQLServerCentral.
Solving Oracle Performance Issues in 4 Easy Steps
The post Solving Oracle Performance Issues in 4 Easy Steps appeared first on SQLServerCentral.
Bad Idea Jeans: Building Big Query Plans
When you build a monitoring tool that sends advice via email, you discover two things: Some people have really, really big execution plans Email servers have reasonable limits on file attachment sizes Add those two things together, and Richie found him …
How to Find the Estimation Cost for a Query
execut The post How to Find the Estimation Cost for a Query appeared first on SQLServerCentral.
SSIS Variable and Parameter Analysis
Introduction If you have an SSIS project that’s matured over time and makes good use of variables and parameters, you’re probably nervous about deleting any of them, even if you think that they are no longer in use. Wouldn’t it be great to be sure and …