Editorial

Automatic Install of Azure Data Studio

  • Editorial

Microsoft recently announced that you’ll get Azure Data Studio (ADS) when you install SQL Server Management Studio (SSMS) starting with version 18.7.1. Azure Data Studio has been around for a couple of years, and it has some great features that most of us never imagined for SSMS, like the ability to connect to PostgreSQL databases […]

2020-11-07

445 reads

What is Possible?

  • Editorial

There’s the old saying “Whether you think you can or you think you can’t -- you’re right” from Henry Ford. I’ve thought about this more recently while reading the book The Rise of Superman Decoding the Science of Ultimate Human Performance which talks about how athletes have performed so called impossible feats over the past few […]

2020-10-31

77 reads

What's Causing the Pushback with DevOps?

  • Editorial

The term DevOps gets horribly abused. Don’t get me started on all the weird additions to it like DevSecOps. No, I just mean the term itself gets beaten up quite a lot. It’s to the point where people are starting to shy away from talking about it. I’ve even changed my approach when discussing DevOps […]

2020-10-24

119 reads

Mentoring

  • Editorial

Over the years when I changed careers and then advanced in IT, many people helped me learn or provided opportunities. Some of these people gave specific in-person help, like my brothers who taught me programming logic and database normalization before I ever thought about working in technology. Others assisted from a distance when I read […]

2020-09-05

89 reads

Controlling Intelligent Query Processing Features

  • Editorial

I always look forward to new T-SQL features and optimizer enhancements with every new version of SQL Server. Starting in 2017, Microsoft came up with a set of features called Intelligent Query Processing (IQP). These features work to improve performance without changing any code. If you’d like to learn more about these features, take a […]

5 (2)

2020-07-11

241 reads

Blogs

P2 Puts Easy, Flexible Project Tracking Tools In Your Hands

By

Improve your team's workflow and productivity with these project tracking blocks.

Daily Coping 22 Jun 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Why are my permissions missing?

By

You’d be amazed (or maybe you wouldn’t) how often I hear this: “I used...

Read the latest Blogs

Forums

Handling OLEDB waits.

By JasonO

I have an application which runs on SQL 2016 & has a link server...

Finding the Group

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Finding the Group

How to create SQL script to backup transaction log with append

By itmasterw 60042

Hi,   I am trying to write a backup script, in a way that...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers