Database Weekly

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)

2020-03-28

118 reads

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

2020-03-21

91 reads

A New World of Data

  • Editorial

I started in the early days of SQL Server, when having a gigabyte of disk storage was unheard of, much less a gigabyte of RAM. My watch has more storage space than the mainframe we replaced with an early version of SQL Server years ago. The technical possibilities and amounts of data we are capable […]

2020-02-15

102 reads

Personal Power

  • Editorial

Because of my job with Redgate (which I love and will never leave even after I’m dead), I spend a lot of time learning about compliance and all the new laws and regulations coming out of things like the GDPR and the CCPA (they changed the name evidently). However, I’m a nerd. I’m not a […]

5 (3)

2020-02-08

135 reads

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

80 reads

Blogs

Covid Thoughts, So Far

By

I’ve gathered a bunch of notes from conversations and time reflecting, thought I’d write...

How to Think Like a Certification Exam at the PASS Professional Development Virtual Group

By

Thanks for the 90+ who joined today's PASS Professional Development Virtual Group webinar on...

Deploy BACPAC to Azure Managed Instance failing from SSMS?

By

Recently I ran into an error when trying to copy a small database bacpac...

Read the latest Blogs

Forums

Advantages and Disadvantage using Temp Table or Fisical Table

By fransiscuscandra

Please share your thought about advantages and disadvantages for processing using temp table or...

Do people process data from beginning of time when there is data change?

By fransiscuscandra

This might be a beginner developer questions but need some clarifications. What is best...

Why would I want to use Compress and Decompress functions?

By VoldemarG

in what live operational or development situation /requirement would I want to use the...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers