Azure Managed Instance Download and Restore SQL Server Backup
Create an SQL Server backup for an Azure Managed Instance that you can download and restore on another SQL Server instance.
2024-10-14
Articles
Adding new files to a log-shipped database (SQL Spackle)
Freshly minted MCM Wayne Sheffield fills a log shipping crack that could otherwise cause you to re-initialize your log shipping.
2024-10-11 (first published: 2013-06-06)
5,764 reads
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 themselves increasingly overworked, overheated, and at their wits’ end, desperately trying to squeeze just a bit more performance and availability out of their aging database architectures.
2024-10-11
PASS Summit 2025 Dates
You heard it here first, PASS Data Community Summit will return to Seattle next year! Save the date, as PASS Summit will take place in person at Summit, Seattle Convention Center, from November 17-21, 2025!
2024-10-11
Identify CPU Intensive SQL Server Queries from an Implicit Conversion
Learn how to use the SQL Server Query Store to find CPU-intensive queries and how you can use Query Store to resolve these issues.
2024-10-09
Microsoft to Headline PASS Data Summit 2024 as Sapphire Sponsor
Join Microsoft at PASS Summit 2024 to explore the latest database innovations and how Azure solutions enhance app performance, security, and scalability in the AI era. Learn new SQL database capabilities, connect with Microsoft engineering leaders, and attend expert-led sessions on topics from database migration to modernization.
2024-10-09
111 reads
How to Delete Large Amounts of Data in Microsoft SQL Server
A short look at some of the options for deleting lots of data from a SQL Server table.
2024-10-07
6,512 reads
Introducing the PASS Data Community Summit Keynotes from Microsoft, Redgate, and a Community Star
After meeting the stellar pre-con speakers and exploring the 5 learning pathways at #PASSDataSummit 2024, we’re excited to reveal the keynote lineup. Each day will kick off with inspiring keynotes from Microsoft, Redgate, and a special community-driven session led by industry experts. Don’t miss out on these insightful sessions designed to energize and empower you throughout PASS Summit 2024.
2024-10-07
Uniqueness, Keys, and Identity
If you’ve ever had a traditional logic course, you’ll have run into “The Law of Identity” as the founding principle of all Western thought. It says that: “To be is to be something in particular; to be nothing in particular or anything in general, is to be nothing at all.”
2024-10-07
Display More Than 8000 Characters (SQL Spackle)
SQL Server MVP Jeff Moden shows us a quick and dirty bit of SQL Spackle to display the content of VARCHAR(MAX) and NVARCHAR(MAX).
2024-10-04 (first published: 2011-01-27)
24,223 reads
Blogs
Solving SQL Server Mysteries with a Whole Gang of Sleuths -Scooby Dooing Episode 4
One thing I’ve always loved about the Scooby-Doo cartoon is that he never solved...
SQL Server Availability Groups
By Kevin3NF
Flexibility and Scale at the Database Level When SQL Server 2012 introduced Availability Groups...
Modify Power BI page visibility and active status with Semantic Link Labs
Setting page visibility and the active page are often overlooked last steps when publishing...
Forums
Password Guidance
Comments posted to this topic are about the item Password Guidance
Using table variables in T-SQL
Comments posted to this topic are about the item Using table variables in T-SQL
Azure elastic query credential question
I am trying to check out elastic query between two test instances we have...
Question of the Day
Using table variables in T-SQL
What happens if you run the following code in SQL Server 2022+?
declare @t1 table (id int); insert into @t1 (id) values (NULL), (1), (2), (3); select count(*) from @t1 where @t1.id is distinct from NULL;See possible answers