Install SQL Server Integration Services in Visual Studio 2019
Learn the step by step process to install SQL Server 2019 Integration Services in Visual Studio as well as the history for the tool.
An Introduction: Level 1 of the Stairway to Row-Level Security
Learn the basics of how Row-Level Security works in SQL Server.
Heaps in SQL Server: Part 2 Optimizing Reads
In the second article of this series, Uwe Ricken discusses ways to affect the performance of queries involving heaps, including the TOP operator, compression, and partitioning.
Using SQL Data Compare to Sync Reference Data
Let's say your QA team maintain two similar test databases. They run tests to verify that different versions of the same application still produce the same, correct results. Therefore, any differences in the test data, between the two databases, needs to be corrected before the tests start. This is the sort of task for which SQL Data Compare is ideally suited, and Bob Sheldon explains how it all works.
Using SQL Server Query Store & Plan Guides to Fix Problem Queries
This webinar will cover how to use SQL Server plan guides and the query store to fix problematic queries and ways to improve query performance.
Beating the Cloud Vendors
Can you run a system better than cloud vendors? You should know and be able to prove it.
Loading data in Azure Synapse using Copy
Learn how to create a Synapse resource and upload data using the COPY command.
Connecting to a SQL Server Docker Container Running in macOS
Since SQL Server is supported in containers, you can now run a SQL Server instance in your macOS without dual-booting or running a virtual machine. In this article of the series, Carlos Robles demonstrates how to connect to the SQL Server once it’s running.
Blogs
Measuring RAG Solutions: Are We Retrieving the Right Information?
A RAG pipeline that answers questions in the demo is not the same thing...
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Building a DBA Agent for Your SQL Server Estate with MCP
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Forums
How do I connect to a SQL Server database on my ISP?
I've got a web application for my side business. I've added a SQL Server...
Looking for New Blood
Comments posted to this topic are about the item Looking for New Blood
Server-Level Row Counts for Tables and Views
Comments posted to this topic are about the item Server-Level Row Counts for Tables...
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers