Problems displaying this newsletter? View online.
SQL Server Central
Featured Contents
The Voice of the DBA
 

A Little Appreciation

I'd like to take a moment and simply voice my appreciation for Steve Jones.

Steve's still on sabbatical, so I've been doing some of the work, along with my co-worker, Kellyn Gorman (who I also appreciate, very much).

I'm sure you've noticed. Oh, not simply that the editorials are different. That's to be expected. Nah, there have been more than a few glitches. Sadly, almost all caused by me (yeah, this, and probably most other things, Kellyn does better). There's just a learning curve and a bit of a balancing act to get the articles published, the newsletter defined, and all of it scheduled in a way that it comes together flawlessly. I sincerely thought I had it down, but I've messed up a number of times.

My apologies to you for that. Still, most of all, my appreciation for Steve. He does a lot to keep this site running. I thought I had a good handle on all that was involved. I learned better. Nice job Steve. Thanks for all you do.

For the rest of you, a few more weeks of me and Kellyn. Best of luck!

Grant Fritchey

Join the debate, and respond to today's editorial on the forums

 
 Featured Contents
SQLServerCentral Article

Best Way to Repair SQL Database: How to Restore SQL Server?

durrani from SQLServerCentral

Summary: SQL Server administrators frequently enco...

SQLServerCentral Article

MongoDB and Python in action

sabyda from SQLServerCentral

Overview As a part of this article, we will learn ...

Stairway to Transaction Log Management

Stairway to Transaction Log Management in SQL Server, Level 6: Managing the Log in BULK_LOGGED Recovery Model

Gail Shaw from SQLServerCentral.com

A DBA may consider switching a database to the BULK_LOGGED recovery model in the short term during, for example, bulk load operations. When a database is operating in the BULK_LOGGED model these, and a few other operations such as index rebuilds, can be minimally logged and will therefore use much less space in the log

Introduction to PostgreSQL for the data professional

Introduction to PostgreSQL for the data professional

Site Owners from SQLServerCentral

Adoption and use of PostgreSQL is growing all the time. From mom-and-pop shops to large enterprises, more data is being managed by PostgreSQL. In turn, this means that more data professionals need to learn PostgreSQL even when they have experience with other databases. While the documentation around PostgreSQL is detailed and technically rich, finding a simple, clear path to learning what it is, what it does, and how to use it can be challenging. This book seeks to help with that challenge.

 

 

 

 

 Yesterday's Question of the Day (by dbakevlar)

TCP Provider Errors in SQL Server

You're troubleshooting a connectivity issue between a client application and a remote SQL Server instance. The client receives a "provider: TCP Provider, error: 0 - No such host is known" message. You verify that SQL Server is running and reachable on the server. The SQL Server instance is configured with a named instance and uses dynamic ports. Which of the following steps is most likely to resolve the issue?

Answer: Configure the SQL Server Browser service to run and ensure UDP port 1434 is open.

Explanation:

When using named instances with dynamic ports, the SQL Server Browser service is essential because it tells clients which TCP port the named instance is listening on. The Browser service listens on UDP 1434, so if it’s not running or blocked, clients won’t know how to connect.

  • A only applies if using the default instance on static port 1433, which isn’t the case here.

  • C could work but isn’t the most likely fix.  Changing to a static port adds unnecessary changes, so I didn't mark this as the correct answer for our QotD.

  • D is often enabled by default and wouldn’t cause a "host not known" error.

Discuss this question and answer on the forums

 

 

 

Database Pros Who Need Your Help

Here's a few of the new posts today on the forums. To see more, visit the forums.

SQL Server 2016 - Administration
How to fix transactional replication latency - Good Morning All, We are facing replication latency issue. I checked for blocking, long running transactions or bulk operations running. I tried re-running the distribution agent job also. But still the latency exists. Could you please tell me what all I need to do to fix the latency Thanks, Chaitanya
Editorials
Transactional DDL in SQL Server: In Oracle, It Does Not Compute - Comments posted to this topic are about the item Transactional DDL in SQL Server: In Oracle, It Does Not Compute
How Microsoft Fabric Is Reshaping Data Value - Comments posted to this topic are about the item How Microsoft Fabric Is Reshaping Data Value
Article Discussions by Author
How a Legacy Logic Choked SQL Server in a 30-Year-Old Factory - Comments posted to this topic are about the item How a Legacy Logic Choked SQL Server in a 30-Year-Old Factory, which is is not currently available on the site.
Database Architecture Considerations for Implementing Content Moderation Services - Comments posted to this topic are about the item Database Architecture Considerations for Implementing Content Moderation Services
Database Architecture Considerations for Implementing Content Moderation Services - Comments posted to this topic are about the item Database Architecture Considerations for Implementing Content Moderation Services
TCP Provider Errors in SQL Server - Comments posted to this topic are about the item TCP Provider Errors in SQL Server
Migrate from Linux to Windows with Availability Groups - Comments posted to this topic are about the item Migrate from Linux to Windows with Availability Groups
We Gave Memory-Optimized Tables a Hash Lookup — Then Tried Pattern Matching Instead - Comments posted to this topic are about the item We Gave Memory-Optimized Tables a Hash Lookup — Then Tried Pattern Matching Instead
Always On AG Latency for Read-Only Workload After Failover? - Comments posted to this topic are about the item Always On AG Latency for Read-Only Workload After Failover?
Unlocking Interoperability: A Guide to Foreign Data Wrappers in PostgreSQL and Aurora PostgreSQL AWS RDS - Comments posted to this topic are about the item Unlocking Interoperability: A Guide to Foreign Data Wrappers in PostgreSQL and Aurora PostgreSQL AWS RDS
An Introduction To Database Diagrams - Comments posted to this topic are about the item An Introduction To Database Diagrams
SQL Server 2022 - Administration
Disaster Recovery for Azure SQL - I am creating a Disaster Recovery plan for Below Data pipeline. I need to plan for Azure SQL Data recovery and Partial Data recovery. May someone please help me with list what all I must consider while doing DR Plan for Azure SQL Data recovery and Partial Data recovery. Thanks a lot.    
SQL Server 2022 - Development
Archiving data older than 5 years - Hi We have databases with data stored for over 20 years, this is required by law. We though want to move data to a Archive database where is can be accessed at any time, at times directly using a view linking the 2 databases and at other times manually having to select the data using […]
Database growth - Hi all I am currently using the following script to store database growth at clients. There are 2 issues though. One is that it is not taking into account free space on the database, so if there is as an example 100GB free space we do not see any growth until the 100GB is used […]
 

 

RSS FeedTwitter

This email has been sent to {email}. To be removed from this list, please click here. If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com. This newsletter was sent to you because you signed up at SQLServerCentral.com.
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
webmaster@sqlservercentral.com

 

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -