Database Weekly

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 […]

2020-02-01

126 reads

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)

2019-12-28

84 reads

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 […]

2019-11-30

440 reads

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)

2019-11-02

623 reads

Blogs

Your First Databricks Notebook

By

On August 4, 2020, I presented this on the weekly Pragmatic Works webinar series....

SQL Clone Works with FILESTREAM

By

SQL Clone is an amazing product that virtualizes your data, allowing multiple instances to...

Fun and profit with UTF-8

By

When SQL Server 2019 was announced, it brought with it UTF-8 support. Also available...

Read the latest Blogs

Forums

Removing TDE from a Database: Level 4 Stairway to TDE

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Removing TDE from a Database:...

SQL Deadlock

By 6pravin9@gmail.com

I have Simple SP to Insert Single Record from Application. When I executes it...

Connecting and working with SQL server in SSMS without WMI is extremely slow.

By SystemlordAnubis

Hi All, I have a slightly weird situation; on one PC that is domain...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers