sqlcat

72 Topics

AlwaysOn Availability Groups, Listener, Named Instances, Port Numbers, etc.
First published on MSDN on Feb 03, 2014 Authored by Sanjay MishraAuthor: Sanjay MishraReviewers: David P.
DataCAT team
Jul 24, 2025 Place SQL Server Blog
41KViews
2likes
2Comments
Changes in SQL Server 2016 Checkpoint Behavior
First published on MSDN on Aug 03, 2016 Authored by Mike RuthruffReviewed by: Denzil Ribeiro, Mike Weiner, Arvind Shyamsundar, Sanjay Mishra, Murshed Zaman, Peter Byrne, Purvi ShahSQL Server 2016 introduces changes to the default behavior of checkpoint.
DataCAT team
Jul 17, 2024 Place SQL Server Blog
4.9KViews
0likes
1Comment
SQLSweet16!, Episode 6: DBCC CHECKDB with MAXDOP
First published on MSDN on Aug 17, 2016 Authored by Sanjay MishraReviewed By: Dimitri FurmanDBCC CHECKDB is a common database maintenance task.
DataCAT team
Feb 02, 2024 Place SQL Server Blog
2.5KViews
0likes
1Comment
Backing up a VLDB to Azure Blob Storage
First published on MSDN on Mar 10, 2017 Reviewed by: Pat Schaefer, Rajesh Setlem, Xiaochen Wu, Murshed ZamanAll SQL Server versions starting from SQL Server 2012 SP1 CU2 support Backup to URL, which allows storing SQL Server backups in Azure Blob Storage.
Dimitri_Furman
Jan 24, 2024 Place Azure SQL Blog
13KViews
0likes
3Comments
How to tell which version of SQL Server data access driver is used by an application client
First published on MSDN on Oct 25, 2010 Authored by Kun ChengIn a recent engagement with an ISV, we’ve run into a sporadic application failure problem when the application is deployed in a mixed environment.
Kun Cheng
May 12, 2023 Place SQL Server Blog
6.8KViews
0likes
1Comment
Azure SQL DB Managed Instance - sp_readmierrorlog
First published on MSDN on May 04, 2018 Reviewed by: Kun Cheng, Borko Novakovic, Arvind Shyamsundar, Mike WeinerAzure SQL Database Managed Instance is a new offering that provides an instance-based SQL PaaS service in Azure.
Dimitri_Furman
May 03, 2023 Place Azure SQL Blog
11KViews
0likes
1Comment
SQLCAT.com consolidated index of Whitepapers
First published on MSDN on Sep 05, 2013 Authored by Shep ShepardIn an effort to migrate as much content as possible from SQLCAT.
DataCAT team
Mar 29, 2023 Place SQL Server Blog
4.7KViews
0likes
2Comments
SQL Server Backup to URL – a cheat sheet
A quick reference for using Backup to URL in SQL Server and in Azure SQL Database Managed Instance
Dimitri_Furman
Oct 28, 2022 Place Azure SQL Blog
21KViews
3likes
6Comments
Real-time performance monitoring for Azure SQL Database Managed Instance
First published on MSDN on Sep 26, 2018 This article was co-authored by Dimitri Furman and Denzil RibeiroReviewed by: Danimir Ljepava, Borko Novakovic, Jovan Popovic, Rajesh Setlem, Mike WeinerIntroductionIn our ongoing engagements with the SQL DB Managed Instance preview customers a common requirement has been to monitor database workload performance in real time.
denzilr
Oct 28, 2022 Place Azure SQL Blog
18KViews
6likes
4Comments
Turbo boost data loads from Spark using SQL Spark connector
First published on MSDN on May 12, 2018 Reviewed by: Dimitri Furman, Xiaochen WuApache Spark is a distributed processing framework commonly found in big data environments.
denzilr
Oct 28, 2022 Place Azure SQL Blog
21KViews
2likes
0Comments