Database Weekly

SQLServerCentral Editorial

The Social Impact of Data

  • Editorial

Let the data drive your decisions. This has been something of a mantra for many technical people, and even many business people, across the last twenty or so years. The allure of business intelligence is harnessing lots of data to make decisions that are rooted in some rational analysis of what has happened. Many companies […]

You rated this post out of 5. Change rating

2020-06-06

74 reads

SQLServerCentral Editorial

The Build Book of News

  • Editorial

Every year Microsoft has held the Build conference for developers. I've been lucky enough to go a few times, and I was hoping to get the chance to attend again. With the pandemic, the entire event went virtual, and was held across 48 continuous hours. I was slightly disappointed as a few sessions I wanted […]

You rated this post out of 5. Change rating

2020-05-23

94 reads

SQLServerCentral Editorial

Bad Managers

  • Editorial

I’m constantly hearing stories about terrible managers, and, of course, I’ve experienced quite a few myself. In fact, I can’t come up with many nice things to say about most managers when I look back over my career. (Luckily, my manager at Redgate is wonderful!) Early in my tech career, I was working at a […]

5 (1)

You rated this post out of 5. Change rating

2020-05-16

187 reads

SQLServerCentral Editorial

The SQL Community Steps up in Time of Need

  • Editorial

Healthcare workers are some of the many heroes working bravely in the face of the Covid-19 pandemic. To protect themselves and their patients, they must wear face masks during their entire shifts. This causes a great deal of ear irritation, so a strap was designed to make wearing the masks easier and alleviate pressure on […]

You rated this post out of 5. Change rating

2020-04-18

129 reads

SQLServerCentral Editorial

Now Is a Good Time for Choices

  • Editorial

The whole world is going through some interesting times. Chances are pretty high that you’re working from home and your principal interaction with others is through virtual means. I know I’m that way as is my company, Redgate Software. It can be challenging or rewarding, depending on how you go about it. What’s even more […]

5 (1)

You rated this post out of 5. Change rating

2020-03-28

126 reads

SQLServerCentral Editorial

Azure Data Studio and Deployment Notebooks

  • Editorial

Azure Data Studio (ADS) is a cross-platform tool that you can use to run T-SQL queries much as you have done using SQL Server Management Studio. No, the databases do not need to be hosted in Azure; the tool works fine for on-premises SQL Servers as well. I’ve started using ADS more as I teach […]

You rated this post out of 5. Change rating

2020-03-21

216 reads

Blogs

Query multiple Azure SQL Databases

By

I was sick of changing context in Azure Data Studio while cleaning up things...

KDA: Echoes of Deception - Case 3

By

The crime spree in Digitown is not ending. This time 20 cars have been...

The Book of Redgate: Do Your Best Work

By

One of our mission statements in the Book of Redgate says: attempt to do...

Read the latest Blogs

Forums

Sustainable Procurement Best Practices for ESG-Driven Supply Chains

By danriq

In today’s business world, Environmental, Social, and Governance (ESG) criteria are no longer optional. Customers, investors,...

Shining a Light on Shadow AI - Responsible Data Protection When AI is Everywhere

By dbakevlar

Comments posted to this topic are about the item Shining a Light on Shadow...

CAST(VARCHAR(n)) resolved performance issue?

By mikael_ljunghorn

Hi, I would love to hear if anyone can tell me why a CAST...

Visit the forum

Question of the Day

The Internals of Writing a Page

In SQL Server, when the buffer manager write pages to disk, page protection is added to the pages. There are two types of protection: torn page protection and checksum page protection. What happens with regards to concurrency with page protection during writes?

See possible answers