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 …
Download AWS RDS SQL Server Backup
The post Download AWS RDS SQL Server Backup appeared first on SQLServerCentral.
How to Add a New Shared Disk to a WSFC as a SQL Resource
DBAs often face situations when the disk gets full for user database files, logs, or system database files. To overcome this issue, normally disks are extended. Expanding the disk is not a complex process but sometimes, extending the disk requires a fe …
Working with Schema Validation in MongoDB
This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the items in the series, click here. In the previous article in this series, I introduced you to schema validation in MongoDB. I described how you can define validati …
Database Sharding: Strategies for Seamless Scaling and Performance Optimization
Companies of all sizes and across industries are struggling to cope with an explosion of data never before seen in the short history of computing. As applications reach new levels of sophistication and become deeply interconnected, these companies find …
Introducing the New Stars of Data speakers for PASS Summit 2024
The post Introducing the New Stars of Data speakers for PASS Summit 2024 appeared first on SQLServerCentral.
[Video] Office Hours: Database Q&A
I went live on TikTok and took your top-voted questions from https://pollgab.com/room/brento: Here’s what we covered: 00:00 Start 00:23 Andrea Hardesty: Do you have any recommendations for reproducing parameter sniffing issues? I have a copy of a …
Query Exercise: Why Are These 3 Estimates So Wrong?
Our prior Query Exercise introduced SQL Server’s 201 buckets problem: its inability to accurately estimate rows for more than 201 outliers in a table. I followed up with a solution using filtered statistics to help with the next 200 outliers, and …