The 2021 State of Database Monitoring survey is now open, and we want to know how you’re currently tackling your server, instance, and database monitoring. By taking part, you’ll contribute to the sole industry-wide report on database monitoring, and provide insights into how SQL Server professionals manage their estates and what challenges they face. Plus, you’ll receive an advanced copy of the report and entry to a prize draw to win a $500 Amazon voucher.

The Thriving Data Community

by Grant Fritchey

SQLServerCentral

A while back I wrote an editorial about how I believed the data community would easily continue after the PASS organization was no more. I'm pleased as punch to be able to report that I was right. Not because I enjoy being right (I do, who doesn't), but because I care very much for the […]

Things We Are Missing

by Grant Fritchey

SQLServerCentral

I read this great little blog post called "Trying to Notice What's Missing." It's not real long and it's worth your time. If you'd like a TLDR, the author points out how in-person meetings at conferences resulted in enhancements to open source software due to superior, in-person, communication. Strictly on a personal level, I miss […]

An Efficient Set-based Solution for Islands and Gaps

by Goce Smilevski

SQLServerCentral.com

Advanced Querying

After reading a recent article on identifying islands and gaps in sequential numbers, one of our readers was inspired to develop a more efficient solution for fragmented data. New Author Goce Smilevski brings us his solution and supporting data to show how this can be done better.

Finding a Break

by Steve Jones

SQLServerCentral

Work environment

A year of remote work has made life hard, and harder to get a break from the same environment you are in most of the time.

Code Review & DevOps

by Additional Articles

Redgate

Vendors/3rd-party Products

A frequent question among those learning about DevOps is "How do we do code reviews in this automated process?". Grant Fritchey shares three options - and a word of caution - to ensure you can appropriately understand the changes happening in your system.

What to monitor for SQL Server security

by Additional Articles

SimpleTalk

SQL Server security

Keeping databases secure is critical. In this article, Robert Sheldon explains what to monitor for SQL Server security.

Always Retry

by Steve Jones

SQLServerCentral

software development

Retry logic is coming to the SqlClient driver.

Load Multiple Excel Files and Worksheets with SSIS

by pramodh kumar tammana

SQLServerCentral

I was asked to load multiple Excel files, each with multiple Excel worksheets. I found a very easy way to complete this in SSIS using a Script Task. This article will explain how I did this. For this example, I have two Excel files, File1.xlsx and File2.xlsx, as shown here: Each Excel File has three […]

Power Apps Canvas Apps Examples

by Additional Articles

MSSQLTips.com

Microsoft

In this article we will focus on Power Apps canvas apps which are natively optimized for mobile devices and we will look at potential use cases for canvas apps.

Tell us about how you monitor your databases

The Thriving Data Community

Things We Are Missing

An Efficient Set-based Solution for Islands and Gaps

Finding a Break

Code Review & DevOps

What to monitor for SQL Server security

Always Retry

Load Multiple Excel Files and Worksheets with SSIS

Power Apps Canvas Apps Examples

Blogs

How to Connect to SQL Server When Nothing Else Works – DAC

Get a Range of Sequence Values: #SQLNewBlogger

The Agent Era: When “How do I…?” Replaces “Where do I click?”

Forums

that one limitation in replication

Local Agents

Detecting Deadlocks

Question of the Day

Detecting Deadlocks