Database Weekly

SQLServerCentral Editorial

Microsoft and Oracle Cloud Partnership

  • Editorial

Many of us checked to make sure it wasn’t April Fools Day a couple of years ago when Microsoft announced that SQL Server 2017 would run on Linux. This means that some shops who want to run SQL Server, but not Windows Server, now can. But it also means that SQL Server professionals need to […]

You rated this post out of 5. Change rating

2019-06-15

203 reads

SQLServerCentral Editorial

Building or Buying Analytics

  • Editorial

One of the decisions that I've been involved with at the beginning of every software project is whether to buy software to solve the problem or build our own. This might be a quick "is there software anyone knows about to do this?" query, or an in-depth review of the marketplace or something in between. […]

You rated this post out of 5. Change rating

2019-06-08

211 reads

SQLServerCentral Editorial

Why Tools Can Help You Do Your Job

  • Editorial

Back in my days as a SQL server DBA, I didn't have many third-party tools at my disposal. I remember having a monitoring tool with licenses for only three or four SQL server instances. Whenever there was a problem with one instance that wasn’t currently being monitored, I would have to stop monitoring another instance […]

You rated this post out of 5. Change rating

2019-05-18

208 reads

SQLServerCentral Article

The Ego, the Id and the DBA

  • Article

In most organizations, the DBA team is seriously outnumbered by headstrong developers and clock driven managers, and "great" DBAs will often be outnumbered by...well...the not so great. In order to be heard in this environment, a DBA will not only need to be very skilled, but will also need a healthy dose of ego.

You rated this post out of 5. Change rating

2012-09-03

196 reads

Blogs

What happens when we drop a column on a SQL Server table? Where's my space?

By

This article was initially posted on SQLServerCentral @ 2024-04-26. Short answer: The column is marked...

Why the masters and what lies ahead

By

I recently graduated with a Master’s in Strategic Communication from the University of Delaware....

Copilot Reminded Me How To Find a File Handle

By

Recently I was trying to delete a folder and kept getting the “something is...

Read the latest Blogs

Forums

Adapt the query to 2012

By meryemkurs072

Hello I have a query that works as a loop but it is slow....

Invoke-SQLCMD

By Bruin

If my server has dashes seems like that is throwing an error -serverinstance at-ts-cblsql ...

Red Gate SQL Change Automation

By Simon Hundleby

Hi, What's happened to this product has it now become Flyway?

Visit the forum

Question of the Day

Automated Azure SQL VM Patching

There is an Automated Patching service for VMs running SQL Server in the Azure Cloud. This uses the SQL Server IaaS Agent Extension to work with PowerShell. What types of patches are installed with this service? Note: All updates are marked with tags, such as Important, Critical, or something else

See possible answers