SSMs and ADS are the new tools for SQL Server and the data platform, both of which are now available separately from SQL Server.

Managing Power BI Workspaces with PowerShell

by Additional Articles

MSSQLTips.com

PowerShell

In this article we look at how to manage Power BI workspaces using PowerShell cmdlets.

SQL IntelliSense and Autocomplete in SSMS

by Additional Articles

Redgate

Vendors/3rd-party Products

Phil Factor reviews the major features of SSMS IntelliSense and autocomplete and then explains how SQL Prompt fills in the gaps, and how to use to use the two in tandem to 'get the best of both worlds'.

What is Possible?

by Kathi Kellenberger

SQLServerCentral

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

The Spookiest Year

by Steve Jones

SQLServerCentral

Misc

Steve looks back a bit at the strangeness of 2020.

Efficiently Polling Remote Data Sources

by Additional Articles

SimpleTalk

Performance

In this article, Edward Pollack describes some of the issues when querying against remote data sources. He covers remote SQL Servers and also connecting to a PostgreSQL database.

Better SQL Server Agent Job Failure Monitoring

by Team xTEN

SQLServerCentral

SQL Server Agent has a built-in alerting process for when jobs fail, but the information it provides isn’t very useful. You’re only told which job, what time, who ran it, and which step failed. If you want to see why it failed, you have to review the job history manually. On a busy system with […]

Building Quality In

by Steve Jones

SQLServerCentral

DevOps and Continuous Delivery (CI/CD)

I heard someone at the 2020 DevOps Enterprise Summit conference say that quality needs to be built in. That's something that many, or hopefully most, of us believe. Everyone ought to do quality work and build it into their daily tasks. However, the person speaking went further and defined this in a way I like: […]