Database Weekly

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

354 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

450 reads

Which Service in Azure Should You Use for SQL?

  • Editorial

I remember when Azure SQL Database was first released in 2010. Microsoft has tweaked the name a couple of times over the years, and back then it was called SQL Azure. The largest database you could create was just 50 GB, and there were quite a few restrictions, such as heaps not being supported. Since […]

2019-10-05

182 reads

Blogs

Data Lake Architecture using Delta Lake, Databricks and ADLS Gen2 Part 4

By

This is the fourth and final post in a series about modern Data Lake...

SQLOrlando 2019

By

We just had our final event of the year and looking back, not bad...

Read the latest Blogs

Forums

Instructions on how to prevent interference when placing a bet

By thanhthuy02

Instructions on how to prevent interference when placing a bet[/b] We have all been...

From Source Control to Database using SQL Compare Command Line

By Additional Articles

Comments posted to this topic are about the item From Source Control to Database...

The Schema Name

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Schema Name

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers