Manage Power BI Dataset with PowerShell

• by Additional Articles

• MSSQLTips.com

• Power BI
• PowerShell

Learn how to manage Power BI datasets with PowerShell with examples to give Developers and DBAs the flexibility have real time data stored in the Power BI service for reporting.

Bad career advice from a 14 year old

• by Kathi Kellenberger

• SQLServerCentral

• Database Weekly

I was having a conversation with my 14-year-old grandson Thomas the other day. He was telling me that is signed up to take a programming class in school next term and sees a future career in technology. He loves playing video games, so maybe developing them would be a good choice. He also was thinking […]

Black Friday Wishes

• by Steve Jones

• SQLServerCentral

• State of the Business

Today Steve asks if there are things you might wish your employer would do for you this holiday season.

Using Notebooks in Azure Data Studio

• by Steve Jones

• SQLServerCentral

• Azure Data Studio
• Jupyter Notebook

Learn how to use the notebook feature of Azure Data Studio to keep a set of queries together with some documentation.

BMWs SQL Server Enterprise Architect on the challenges of monitoring

• by Additional Articles

• Redgate

• Vendors/3rd-party Products

Tony Maddonna, BMW’s SQL Server Enterprise Architect, writes about the challenges of database monitoring. Drawing on experiences throughout his career, this blog covers manual vs third party, proactive monitoring in dev and test, and managing expectations of the cloud. To learn more, and read his tips on how to build a business case for third-party tooling, check out his blog.

Continuous deployment at scale

• by Additional Articles

• SimpleTalk

• DevOps and Continuous Delivery (CI/CD)
• sysadmin

More organisations are adopting DevOps, but what happens as the codebase grows? In this article, Siddharth Rao gives advice on how to implement continuous deployment at scale.

Exporting Stored Procedure Results to a Table

• by Pamela Mooney

• SQLServerCentral

• Stored Procedures

A quick trick from Pamela Mooney for getting results from a proc into a table.

Thanksgiving 2020

• by Steve Jones

• SQLServerCentral

• holiday

A few thoughts from Steve today on Thanksgiving.

Monitoring SQL Server Instance Version and Builds with PowerShell

• by Additional Articles

• MSSQLTips.com

• Monitoring
• PowerShell

In this article we continue our PowerShell monitoring series with scripts that check the current version and build for all SQL Server instances in your environment.

Win a three-month subscription to Pluralsight

• by Additional Articles

• Redgate

• Vendors/3rd-party Products

Redgate is giving you the chance to win a three-month subscription to Pluralsight (the technical skills training platform) in this month’s forum competition. To enter, simply share ‘how SQL Compare has helped you’.