The PASS Data Community Summit Session Schedule is LIVE!
The post The PASS Data Community Summit Session Schedule is LIVE! appeared first on SQLServerCentral.
Free Webcast: How to Think Like the Engine, Big Data Edition
Brent, Big Coat Edition You’ve watched my free How to Think Like the Engine class that focuses on the small 1GB Users table. Let’s take things up a notch by using the ~164GB Posts table full of questions & answers. You’ll learn: W …
Yes, Cardinality Estimation Keeps Changing After SQL Server 2014.
About 10 years ago, Microsoft made changes to the Cardinality Estimator (CE) which caused some problems for SQL Server upgrades. When folks upgraded to SQL Server 2014, they also casually switched their databases’ compatibility level to the lates …
Raising the Cost Threshold for Parallelism (CTFP) Affects SQL Server Missing Indexes
The post Raising the Cost Threshold for Parallelism (CTFP) Affects SQL Server Missing Indexes appeared first on SQLServerCentral.
TRY/CATCH Doesn’t Always Work.
If you’re using TRY/CATCH to do exception handling in T-SQL, you need to be aware that there are a lot of things it doesn’t catch. Here’s a quick example. Let’s set up two tables – bookmarks, and a process log to track whe …
Simple Talks at the PASS Summit
This year at Simple Talk has been exciting, after a slow start with me being more or less out for a few months. We have made changes to the website, which are still being evolved. We have started a podcast and as of this writing, we have 6 posted episo …
Rounding Numbers
I would hope by now everybody has figured out when you see a price like $39.99 that it might as well be forty bucks. Dropping that penny from the price is done is to fool the consumer! Since we read numbers left to right, the merchant hopes you will se …
Boosting Database Development Efficiency Using AI SQL Code Generators
Database development has become more complex over the years due to the introduction of new data and storage formats by big data. This along with modern applications that often depend on multiple databases and APIs, plus newer data analytics and data sc …
Setup Excel as Front End Application for SQL Server
The post Setup Excel as Front End Application for SQL Server appeared first on SQLServerCentral.
[Video] Office Hours: Open Q&A About Databases
I went through your top-voted questions from https://pollgab.com/room/brento plus hit live ones from the TikTok viewers. Here’s what we covered: 00:00 Start 00:52 chandwich: If SSMS had a dark mode option that was equally as good as the existing …
How To Use Managed Identities in your Azure Logic Apps
Azure Logic Apps are a cloud-based service where you can create low code workflows to automate your business processes or to integrate different applications or services. The article How To Embed Your Azure Logic Apps in a Metadata-driven Data Platform …
Query Exercise Answers: Why Are These 3 Estimates So Wrong?
This week’s Query Exercise challenged you to figure out why these 3 estimates went so badly: SELECT TOP 250 p.Id, p.Title, COUNT(*) AS VotesCast FROM dbo.Users u INNER JOIN dbo.Posts p ON u.Id = p.OwnerUserId INNER JOIN dbo.Votes v ON p.Id = v.Po …
Microsoft return to PASS Summit 2024 as Sapphire sponsor
The post Microsoft return to PASS Summit 2024 as Sapphire sponsor appeared first on SQLServerCentral.
Contest: What’s Your Biggest Database Regret?
PAST ME, WHAT WERE YOU THINKING We all make mistakes. I certainly have. I’ll give you a recent one, actually: when we designed the database for SQL ConstantCare®, when we’re storing diagnostic data like wait stats, we thought these 3 column …
AWS Services Using SQL for Big Data Analysis
SQL’s ability to manipulate data makes it relevant for people creating tools for data analysis. Analysts can create specific and customized queries to extract essential data subsets, making it easier to begin exploring and comprehending the datas …