Tips and tricks

Technical Article

How to hot-add a vCPU to a virtual SQL Server

  • Article

One of the benefits of running SQL on virtual environment is the capability to present additional vCPUs to the virtual server online and real-time without interruption to running processes. Our VM administrator normally presents only 1 vCPU on the virtual server and extends as required. This article describes how SQL Server is able to detect hot-added vCPUs in my virtual server.


2,865 reads

Technical Article

Easier way to use a path

  • Topic

Is there an easier way to refer to a path, such as:\\servername\f$\folder 1\folder 2\folder n\application.exeCan I somehow give this path a "logical" name so that I can refer to that, instead of the long path everytime I use it in a job ?I have a server that points to other servers via jobs (enterprise mgr) […]


Technical Article

Online Resources

  • Reply

No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!


Technical Article

RE: Storing an Excel Sheet in an SQL field.

  • Reply

Ok, some thoughts about why you shouldn't put them in the DB. I will grant you this is a bit old school in thinking but it is something to consider. Why put something in a database -- You need to search on it -- You need to really control access and NTFS security is too […]



Daily Coping 26 Jan 2023


Today’s coping tip is to focus on what’s good, even if today feels tough....

Working With Tags in FlashArray using PowerShell


Introduction Purity is the operating environment that runs Pure Storage products like FlashArray and...

Using SQL Data Compare from the Command Line with a Project


SQL Data Compare (SDC) is a great way to sync data among tables. It’s...

Read the latest Blogs


what does the backup log init do?

By vpmaciel

what does the backup log init do?

Backup Log Init run again by mistake manually.

By vpmaciel

backup log to int run every hour. If a log init backup is run...

Speakers Are Normal People

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Speakers Are Normal People

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers