Database Weekly

SQLServerCentral Editorial

Why Getting Data Right Matters

  • Editorial

An InfoWorld article from 2017 suggests that 80 percent of a data scientist’s job is cleaning and transforming data, and I believe this is probably only true for organizations that spend at least an average effort in designing and implementing their data storage. These persons who have trained to analyze data using complex math formulas […]

You rated this post out of 5. Change rating

2020-02-01

182 reads

SQLServerCentral Editorial

The New Year: A Chance to Start Over

  • Editorial

January 1st is the beginning of a new year thanks to Julius Caesar and Pope Gregory XIII. This date is somewhat arbitrary, and many religions and cultures celebrate their own beginning of a new year at different times. Even though these celebrations don’t fall at the same time, I think the sentiment is similar. The […]

5 (1)

You rated this post out of 5. Change rating

2019-12-28

112 reads

SQLServerCentral Editorial

How SQL Server Can Just Go Faster

  • Editorial

It’s rare to get a call from a customer telling you that the application is fast today and thanks for taking such good care of the database. Instead, you are more likely to hear complaints when things go wrong like slow running queries and timeouts. There is a lot to consider when trying to figure […]

5 (1)

You rated this post out of 5. Change rating

2019-11-30

567 reads

SQLServerCentral Editorial

A Faster tempdb

  • Editorial

I like to call tempdb the “workhorse” of SQL Server. I’ve heard some other people call it other terms that were not so flattering, but since I like to keep things positive, I’ll stick with workhorse. SQL Server uses tempdb for many things. The obvious uses are temp tables and table variables, but tempdb is […]

5 (3)

You rated this post out of 5. Change rating

2019-11-02

1,127 reads

Blogs

A New Word: Amoransia

By

amoransia – n. the melodramatic thrill of unrequited love; the longing to pine for...

The Data API Builder Start and Add Extensions in VS Code

By

One of the things that I like about the Data API Builder (DAB) is...

Using OneLake for Excel Files in Microsoft Fabric

By

Hey data friends! This blog is to discuss an edge case I’ve run into...

Read the latest Blogs

Forums

Technical Pain Behaviors

By Louis Davidson (@drsql)

Comments posted to this topic are about the item Technical Pain Behaviors

trying to call powershell from TSQL statement

By Siten0308

Hello, trying to call a powershell file I created, locally on the server, but...

Counting Bits

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Counting Bits

Visit the forum

Question of the Day

Counting Bits

What does the BIT_COUNT function do in SQL Server?

See possible answers