SQL v.Next Gets Native Python in SQL Server

The next version of SQL Server is in early preview and there is a new feature that is going to be very useful for large enterprises that want to run Big Data Clusters and perform additional data science tasks. Instead of embedding Python code in a string and submitting it to the Launchpad engine, we […]

SQL Server Transaction Log Management eBook Download

Free eBook: SQL Server Transaction Log Management

When a SQL Server database is operating smoothly and performing well, there is no need to be particularly aware of the transaction log, beyond ensuring that every database has an appropriate backup regime and restore plan in place. When things go wrong, however, a DBA's reputation depends on a deeper understanding of the transaction log, both what it does, and how it works.

Blogs

How to Think Like a Certification Exam at the PASS Professional Development Virtual Group

By

Thanks for the 90+ who joined today's PASS Professional Development Virtual Group webinar on...

Deploy BACPAC to Azure Managed Instance failing from SSMS?

By

Recently I ran into an error when trying to copy a small database bacpac...

Daily Coping–3 Apr 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is...

Read the latest Blogs

Forums

Replacing / Removing All Text In Multiple Sets of Characters in SQL

By mnovosel

One of the result fields has multiple html references in it such as in...

steps testing and moving workloads from SQL Server 2014 to SQL Server 2019

By sqlguy80

Hello, SQL Server Gurus, Can any one please suggest  steps regarding performance testing all workloads...

Causes for The query processor could not produce a query plan

By YSLGuru

SQL Server 2016 (13.0.5598.27) The first version of the below query produces results while...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers