--SQLUser Group

SQL Server Blog: Five reasons to run SQL Server 2016 on Windows Server 2016 — No. 1: Security

This is the first blog in a five-part series. Keep an eye out for upcoming posts, which will cover cutting costs and improving performance of storage, BI, and analytics; improving uptime and reliabili...
--Read more...

Power BI Blog: The Power of SharePoint

Do you have SharePoint Online and want to better automate and streamline your business processes? Have you heard of PowerApps, Microsoft Flow, or Power BI, but you’re not sure how to use them with S...
--Read more...

Power BI Blog: Custom visuals now available in the Office store

Custom visuals have come a long way since the platform was announced as part of Power BI GA back in July 2015. From best visual contest, to a new and improved version of the platform and the…...
--Read more...

Power BI Blog: The Microsoft Data Insights Summit is back – check out our full session catalog today!

In February, we announced that our Microsoft Data Insights Summit will return for the second year, and invited you to register and join us June 12-13, 2017 in Seattle, WA. This is THE user conference ...
--Read more...

Power BI Blog: March Madness Community Updates

If you've visited the Power BI Community this week, you've probably spotted a few exciting new additions! Learn more about the new Report Theme Gallery, the Custom Visuals Community site, and the Desi...
--Read more...

Kimberly Tripp: SQLskills SQL101: Indexes on Foreign Keys

As many of you know, we started our SQLskills SQL101 series a couple of weeks ago… it’s been great fun for the whole team to go back through our most common questions / concerns and set th...
--Read more...

Power BI Blog: Filter a report with a URL query string parameter

You may have seen some forum posts showing how to filter a report with a URL query string parameter. We also have this in the main documentation as well. It isn’t very widely known. So, I thought I...
--Read more...

Power BI Blog: New custom visuals community site: developers and users unite!

Custom visuals are all about the community, whether the community developers who drive the awesome visuals in the gallery, create visuals privately for their organization use, or enthusiastic users…...
--Read more...

Power BI Blog: Announcing Custom Cache Refresh Schedules in the Power BI Service

Today, we are announcing the upcoming availability of an exciting new feature in the Power BI service: we are giving dataset owners full control over the scheduled cache refresh cadence of their Direc...
--Read more...

SQL Server Blog: SQL Server next version CTP 1.4 now available

Microsoft is excited to announce a new preview for the next version of SQL Server (SQL Server v.Next). Community Technology Preview (CTP) 1.4 is available on both Windows and Linux. In this preview, w...
--Read more...

SQL Server Blog: SQL Server on Linux: Running jobs with SQL Server Agent

In keeping with our goal to enable SQL Server features across all platforms supported by SQL Server, Microsoft is excited to announce the preview of SQL Server Agent on Linux in SQL Server vNext Commu...
--Read more...

Power BI Blog: Power BI Community Report Theme Gallery

We are very excited to announce the launch of the new theme gallery in the Power BI Community. This gallery is a dedicated space for you to share and find new themes for use in your Power BI reports....
--Read more...

Paul Randall: Do you get our bi-weekly newsletter?

You may not know this, but for the last six years I’ve been producing a bi-weekly newsletter for everyone signed up for our mailing list (which we only use for the newsletter). It’s a bit ...
--Read more...

Power BI Blog: Dive into Power BI at Summit EMEA

I invite you to join me at Summit EMEA and learn about how you can maximize the value in your data by using the amazing capabilities in Power BI. At the event, you’ll hear what’s new with Power BI...
--Read more...

SQL Server Blog: Introducing Microsoft Data Amp

This post was authored by Mitra Azizirad, Corporate Vice President, Cloud Application Development & Data Marketing, Microsoft Today, I am excited to announce that on April 19, we will host a new o...
--Read more...

Power BI Blog: Power BI Gateways–March Update

This month we have an exciting on-premises data gateway release, and it’s been a while! We've made several improvements, from re-designing the summary page for the gateway, to adding new functionali...
--Read more...

Kimberly Tripp: SQLskills SQL101: Indexing Basics

SQLskills introduced our new SQL101 recently and well… indexing is something that everyone needs to get right. But, it’s not a simple task. And, as I start to sit down to write a SQL101 ...
--Read more...

Paul Randall: SQLskills SQL101: Temporary table misuse

As Kimberly blogged about recently, SQLskills is embarking on a new initiative to blog about basic topics, which we’re calling SQL101. We’ll all be blogging about things that we often see done ...
--Read more...

Power BI Blog: Announcing granular tenant settings in Power BI

Power BI allows organizations to monitor and analyze their most critical business data. As such, it’s very important for administrators to have control over how Power BI is used in their…...
--Read more...

Power BI Blog: Congratulations to this month's Featured Data Stories

Last month we put out the call for submissions using mapping tools -- along with other topics that interest you -- for the Data Stories Gallery, and we got some fantastic entries! Congratulations to t...
--Read more...

Power BI Blog: Power BI publish to web helps nonprofits do more good

It’s been just over a year since we launched Power BI publish to web, and in that time, it’s become an important tool for bloggers, journalists, newspaper columnists, and authors who want to tell ...
--Read more...

Power BI Blog: Tech Tip Thursday: Embed a dashboard into your application

A couple of weeks ago we enabled embedding Power BI dashboards into your business applications. This week, Guy in a Cube walks through the process of embedding the dashboard, using the public develope...
--Read more...

Power BI Blog: Announcing support for Amazon Redshift connectivity in the Power BI service

A few months ago we released a Preview of the Amazon Redshift connector in Power BI Desktop. This new connector allows users to easily build reports based on their Redshift data, either by importing t...
--Read more...

Paul Randall: SQLintersection Spring 2017

As we head into our 9th SQLintersection in May, I’m excited to say that it’s once again our most diverse, complete, and information-packed show yet! One of the pieces of feedback we hear o...
--Read more...

Paul Randall: 50 online SQL Server training courses and a free trial

With the publication of our most recent Pluralsight course last month, we now have a whopping 50 online training courses available through Pluralsight, totally more than 150 hours of content. If you&#...
--Read more...

SQL Server Blog: Gartner names Microsoft a leader in the Magic Quadrant for Data Management Solutions for Analytics (DMSA)

This post was authored by Rohan Kumar, General Manager, DS SQL Engineering. We’re excited that Gartner has recognized Microsoft as a leader in the Magic Quadrant for Data Management Solutions for An...
--Read more...

Kimberly Tripp: Work-Life-Balance and Alternative-Obsessions

  Over the past few years, Paul and I have worked to get to a point where we can work with SQL but also satisfy our urge to explore (and dive!). Finding a perfect balance between work and life c...
--Read more...

Power BI Blog: Announcing the Power BI solution template for Microsoft Dynamics 365 for Project Service Automation

Today we are excited to announce the release of the Power BI solution template for Microsoft Dynamics 365 for Project Service Automation. This template includes sets of reports designed for profession...
--Read more...

Power BI Blog: Announcing the Advanced Search Solution Template for Bing News

Today we are excited to announce the advanced search solution template for Bing News (a counterpart to the Twitter template released last September). Upon defining a search term of interest, a brand m...
--Read more...

Power BI Blog: Power BI Desktop March Feature Summary

We have a very exciting Power BI Desktop update for you this month! We have several highly-requested features in this month’s release, including textbox font color, several visual improvements, and ...
--Read more...

Power BI Blog: How Power BI Embedded Helps MB3M Provide A More Dynamic Reporting Solution To Its Customers

MB3M is a French software company founded in 2007 that builds applications for travel agencies. Its flagship product, MB3M Travel, covers a vast array of CRM, financial, and accounting needs of travel...
--Read more...

Power BI Blog: Microsoft Power BI receives the Esri New Technology Integration Award for 2017

Today we’re excited and humbled to receive the 2017 Esri Partner Conference (EPC) - New Technology Integration award for taking map visualization and geo-analytics to the next level by integrating A...
--Read more...

Paul Randall: Why PFS pages cannot be repaired

Last week there was a short discussion on Twitter about why PFS pages can’t be repaired (prompted by a #sqlhelp question about why they can’t be single-page restored, like other per-databa...
--Read more...

Power BI Blog: Power BI Service February Feature Summary

It’s been another busy month for the Power BI team. Each week, we’ve released updates to the Power BI service, rolling out new features and improving existing. Worried you missed something? Fear n...
--Read more...

Power BI Blog: Explore your K2 Process Analytics Data with Power BI

With K2’s business process application platform, organizations can use visual designers to rapidly build and deploy low-code applications that are agile, scalable and reusable, resulting in modern p...
--Read more...

SQL Server Blog: Now available! SQL Server Premium Assurance provides six more years of product support

Today we are announcing general availability of SQL Server Premium Assurance, a new offering that enables flexibility to keep systems running without disruption while modernizing on your own schedule...
--Read more...

Paul Randall: SQLskills SQL101: Dealing with SQL Server corruption

As Kimberly mentioned last week, SQLskills is embarking on a new initiative to blog about basic topics, which we’re calling SQL101. We’ll all be blogging about things that we often see ...
--Read more...

Power BI Blog: Embed Dashboards in Your Applications to Monitor Your Business in Context

Power BI dashboards are optimized to monitor the status of your business at a glance. Business applications are optimized to manage your business. Wouldn’t it be great if you could monitor your busi...
--Read more...

Power BI Blog: March 2 Webinar: Inventory optimization with Neal Analytics and Microsoft

Delight customers by carrying the right products on every shelf! To stay competitive, retail and consumer packaged goods companies need to apply complex business intelligence (BI) to their SKU portfol...
--Read more...

Kimberly Tripp: USE THIS: sp_helpindex

Since I’ve rewritten sp_helpindex a few times, I have a few blogs posts in this category. Each time I do an update I’ll make the NEW version titled USE THIS and I’ll change all others to (OL...
--Read more...

Power BI Blog: Power BI mobile apps feature summary – February 2017

Earlier this month we introduced the preview of Q&A for Power BI iOS app, and while we've received amazing feedback so far, we'd still love to hear from you in the Power BI community thread. Speaking ...
--Read more...

Power BI Blog: Register now for the Microsoft Data Insights Summit

On June 12th we are going to have a big celebration here in Seattle: our second Data Insights Summit. This is THE user conference for Power BI, Excel and whole of the Microsoft Data and Analytics fami...
--Read more...

Power BI Blog: Tech Tip Thursday: Connecting from Power BI Mobile to SSRS

Microsoft's Guy in a Cube has been providing tips and tricks for Power BI and Business Intelligence on his YouTube channel since 2014. On Thursdays we highlight a different helpful video from his coll...
--Read more...

Kimberly Tripp: SQLskills SQL101: Stored Procedures

Sometimes going back-to-the-basics is the best thing to do to fully understand something. Some of us have been doing things in a certain way for so long that we’ve missed a very basic / importan...
--Read more...

SQL Server Blog: SQL Server next version CTP 1.3 now available

Microsoft is excited to announce a new preview for the next version of SQL Server (SQL Server v.Next). Community Technology Preview (CTP) 1.3 is available on both Windows and Linux. In this preview, w...
--Read more...

SQL Server Blog: SQL Server on Linux: Mission-critical HADR with Always On Availability Groups

This post was authored by Mihaela Blendea, Senior Program Manager, SQL Server In keeping with our goal to enable the same High Availability and Disaster Recovery solutions on all platforms supported b...
--Read more...

Power BI Blog: Gartner positions Microsoft as a leader in BI and Analytics Platforms for ten consecutive years

Gartner has recognized our vision and execution for the tenth consecutive year, positioning Microsoft as a Leader in the Magic Quadrant for Business Intelligence and Analytics Platforms. Also, for sec...
--Read more...

Paul Randall: Who is overriding MAXDOP 1 on the instance?

In Monday’s newsletter I discussed an email question I’d been sent and promised to blog about it. The question was “how can latch waits for ACCESS_METHODS_DATASET_PARENT occur when t...
--Read more...

Paul Randall: Who is overriding MAXDOP 1 on the instance?

In Monday’s newsletter I discussed an email question I’d been sent and promised to blog about it. The question was “how can latch waits for ACCESS_METHODS_DATASET_PARENT occur when t...
--Read more...

Power BI Blog: Power BI, Flow, and PowerApps Webinars for February 23 - April 6

If you haven’t attended one of the free Business Application Platform webinars, the intent is to offer world-class best practices, giving you not just insight into your data but also into how to aut...
--Read more...