Excel and Power BI work well together. This allows you to use the two tools together to provide for many types of business workflow and BI practices. You can publish an Excel file to Power BI to share with others, analyse a Power BI dataset in Excel or import either an Excel workbook or Excel data to Power BI. You can gain the workgroup power and business-orientation of Power BI without losing the ease and versatility of Excel. Saurabh shows how.

SQL Server 2016 SSIS Basics - Install SQL Server Data Tools

by bake13

SQLServerCentral.com

Integration Services (SSIS)

Step-by-step instructions for downloading and installing SQL Server Data Tools (SSDT) for SQL Server 2016.

The Avalanche of Cloud Computing

by Steve Jones

SQLServerCentral.com

Editorial

Today Steve Jones talks about the tipping point of cloud computing.

Purging Old Database Mail Items

by Additional Articles

Database Journal

Database Mail

Are you purging the old database mail items stored in msdb? In this tip, Greg Larsen shows you how to purge database mail.

Interviews: What is ACID?

by Steve Jones

SQLServerCentral.com

Editorial

While thinking about interviews, Steve Jones shares a story of a job situation he encountered.

Stairway to U-SQL Level 17: Executing U-SQL Jobs with PowerShell

by Mike McQuillan

SQLServerCentral.com

Automate your Data Lake with PowerShell! Learn how PowerShell can be used to execute U-SQL scripts, as well as a few other little tricks.

Investigating the Cause of SQL Server High CPU Load Conditions When They Happen

by Additional Articles

SimpleTalk

Performance

Any DBA who is trying to find the cause of an intermittent problem with a server or database dreams of being able to use a query or procedure take a snap of the relevant variables at the point when the problem occurred. Laerte takes an example of a slow-running query hogging resources to show that you can run queries when a WMI alert is fired, and save the results for later inspection, whenever it happens.

The Library Job Hunt

by Steve Jones

SQLServerCentral.com

Editorial

Find a new career in the library.

Searching and finding a string value in all columns in a SQL Server table

by Additional Articles

MSSQLTips.com

SQL Server

Sometimes there is a need to find if a string value exists in any column in your table. Although there are system stored procedures that do a "for each database" or a "for each table", there is not a system stored procedure that does a "for each column".

Avoiding the Hell of having to Remember DDL syntax

by Phil Factor

SQLServerCentral.com

Editorial

What's your favorite productivity tool when writing SQL? Phil Factor has has flirted with most of them, from templates and snippets to a programmer's clipboard and back again.

The Best of Both Worlds: Using Excel and Power BI Together

SQL Server 2016 SSIS Basics - Install SQL Server Data Tools

The Avalanche of Cloud Computing

Purging Old Database Mail Items

Interviews: What is ACID?

Stairway to U-SQL Level 17: Executing U-SQL Jobs with PowerShell

Investigating the Cause of SQL Server High CPU Load Conditions When They Happen

The Library Job Hunt

Searching and finding a string value in all columns in a SQL Server table

Avoiding the Hell of having to Remember DDL syntax

Blogs

ISACA AI Material/Exam Prep Discount (May 18 – June 30, 2026)

A Fabric solution can be very cost effective

Track SQL Server Configuration Changes Using the Error Log

Forums

We Are Eating Our Own Seed Corn

Before Using AI with Business Data, Read This

Designing SQL Server ETL Pipelines That Don't Break at Scale

Question of the Day

Detecting Deadlocks Quickly