SQL PROMPT

The Sins of SELECT * (BP005)

  • Article

If Prompt warns you of use of the asterisk, or 'star' (*), in SELECT statements, consider replacing it with an explicit column list. It will prevent unnecessary network load and query performance problems, and avoid problems if the column order changes, when inserting into a table.

2019-05-27

Securing Code Early

  • Editorial

Last year I started to get alerts from Microsoft Repos that someone had put a piece of security information in their code that pertained to one of my Azure services. At first I was worried, but then I realized this was the public version of AdventureWorks we maintain in Azure. We've published the login so […]

2019-04-17

114 reads

Blogs

Weekly reading #15

By

SQLDay 2019 is gone. The Data Community.PL has now a new goal – it...

Last Weeks Reading (2019-05-26)

By

It was tremendously extensive week for me (a week ago) when I spent time...

Migrating SSIS to Azure – Slidedeck (Techorama 2019)

By

Techorama 2019 is over and it was a blast, as usual. Neatly organised, great...

Read the latest Blogs

Forums

The Change Failure Rate

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Change Failure Rate

Streamlining a Power BI Solution

By Additional Articles

Comments posted to this topic are about the item Streamlining a Power BI Solution

Memorial Day

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Memorial Day

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Memorial Day

See possible answers