Steve Jones

Exporting Data with PowerShell

Recently I had the need to help someone download some data from SQL Server as a part of an automated process. In this case, the person wanted to use PowerShell (PoSh), since they were performing a few other actions with PoSh as well. This article is a short tutorial on exporting data from SQL Server […]

5 (7)

2020-01-02

4,068 reads

Prompt in ADS

Ever since VS Code and Azure Data Studio came out, people have been asking for SQL Prompt to port over. I’ve been right there with you, though unsure of...

2020-01-02 (first published: )

226 reads

Looking Back at the Decade

Today is the last day of 2019, and the last day of the 2010 decade. I'm still somewhat amazed by the fact that we're entering the 2020s and we still don't really have flying cars. We're well past 2001 and 2010, and still not much space exploration, though the growth in computing power and AI/ML […]

5 (1)

2019-12-31

167 reads

Blogs

Actual Difference Between EXISTS(SELECT 1 …), EXISTS(SELECT * …), and EXISTS(SELECT column …)

By

Is EXISTS(SELECT 1 ...) better than EXISTS(SELECT * ...)? Who would know better than...

ANSI_WARNINGS = OFF can break update statements with some SQL features

By

Working on a SQL 2017 database where an external, non-Microsoft application has direct access...

Bring Your Own Key to Azure SQL Database Managed Instance TDE

By

Last year Azure SQL Database Managed Instance saw the introduction of bring your own...

Read the latest Blogs

Forums

https://probowl-bowl.com/

By streamlive

https://the-grammyawards.com/ https://the-grammyawards.com/2020/ https://the-grammyawards.com/live/ https://grammyawards-grammy.com/ https://grammyawards-grammy.com/2020/ https://grammyawards-grammy.com/live/ https://probowl-bowl.com/ https://probowl-bowl.com/2020/ https://probowl-bowl.com/live/ https://probowl-bowl.com/nfc-vs-afc/   https://the-grammyawards.com/ https://the-grammyawards.com/2020/ https://the-grammyawards.com/live/...

https://grammyawards-grammy.com/

By streamlive

https://the-grammyawards.com/ https://the-grammyawards.com/2020/ https://the-grammyawards.com/live/ https://grammyawards-grammy.com/ https://grammyawards-grammy.com/2020/ https://grammyawards-grammy.com/live/ https://probowl-bowl.com/ https://probowl-bowl.com/2020/ https://probowl-bowl.com/live/ https://probowl-bowl.com/nfc-vs-afc/

How to update status with conflict data where chemical temp table have same chem

By ahmed_elbarbary.2010

How to update status with conflict data where chemical temp table have same chemical...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers