Database Weekly

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

79 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

417 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

519 reads

Blogs

Continuous integration and delivery (CI/CD) in Azure Data Factory using DevOps and GitHub - Part 2

By

(2020-Jan-28) This blog post is a followup to my previous post about DevOps (CI/CD) for...

Extended Events Misperceptions: Profiler is Easier, Part 2

By

I wrote a short blog post about the misperception that Profiler was easier than...

CREATE TABLE MyTable (Col1 CHARACTER VARYING (50))

By

If you read the title to this post and your first thought was That’s...

Read the latest Blogs

Forums

Fastest way to load a CSV file in SQL Server Table

By SQL Kidu

What is the fastest way to load a file in SQL Server Table ?...

Replication question

By pani

Im an Oracle DBA by trade and been tasked with setting up transaction replication...

Software to send Report

By VastSQL

Hi Experts, Currently we are using SQL Server and Database Mail to send reports...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers