Victor Sánchez Jáuregui

  • Skills: Database development, data architecture, data analytics, data integration. SQL Server, Power BI, SSRS, SSIS.

Power Query or SQL Server? Which, when and why

When it comes to developing a Power BI report, we can use it for accessing data, transforming the data, and turning the data into information using visuals. With no doubt Power BI can do the job from beginning to end. Now, this is not the only, nor necessarily the best, tool for all the steps […]

4 (3)

2021-01-25

5,197 reads

Blogs

Book Review: High Performance SQL Server (Second Edition)

By

One of the technical books that sit on my work desk (or dining table,...

The PowerShell Basics If Statement–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

T-SQL Tuesday Retrospective #013: What the business wants

By

Click here to read previous retrospective entries. From Steve Jones (blog | Twitter) in December 2010...

Read the latest Blogs

Forums

SQLCMD.exe get installed with SSMS?

By doughora

Is the  SQLCMD.exe  supposed to be installed when SSMS is installed on a workstation?...

Complex .Json Data Parsing with multiples Array elements into SQL (MS-SQL 2016)

By manihindus

DECLARE @JSON NVARCHAR(MAX) =N'{ "code": 200, "msg": "success", "data": [{ "ITEM": "SP", "FACTORY_NO": [{...

How to Display FeatureName of Comptitor First then Npx Feature Name second Based

By ahmed_elbarbary.2010

How to Display Feature Name of Comptitor First then NXP Feature Name second Based...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers