--SQL User Group





Upcoming Events

06.06.2018

Power BI : Double Trouble!

Power BI Report Server

In this Power BI Report Server session, we get to explore the capabilities of running Power BI reports on-premise and how it relates to powerbi.com and Reporting Services. We will discuss how to aquire the product, a brief overview on licensing as well as dicussing the product from both a BI user and IT Pro user perspective.

 

A day An hour in the life(cycle) of Power BI Reports

So you've built yourself a snazzy report, and minutely layed out the tiles in a dashboard? Excellent! Obviously you want all the right people in your organization to gaze upon the wonder of your creation, so you share the report. What is going to happen when you make some changes, so the report is even more fantastic? What kind of interactions do you require from your end users to stay up-to-date? Are you really prepared to manually share to 20+ people? Sharing reports is cool, but we want it to be as little time consuming for everyone involved as we possibly can.

In this session, we'll take a stroll through some different sharing mechanisms for Power BI Reports and Dashboards and how you can make them accessible for your end users. Using these different mechanisms, we'll lay out a viable way of creating a decent application life cycle for your reports.

 




Latest community news

26.05.2018

Brent Ozar Unlimited : [Video] Office Hours 2018/5/23 (With Transcriptions)

This week, Brent, Tara, and Richie discuss relaying SQL Server performance updates to upper manageme...

 

26.05.2018

Marco Russo : Change culture/collation of an Analysis Services Tabular database

When you create a Tabular model for Analysis Services, the Culture and Collation properties are set ...

 

25.05.2018

Brent Ozar Unlimited : SQL Server Setup Feature List Changes 2008-2017

If you happen to install several SQL Servers in a row, you’ll notice differences from over the...

 

24.05.2018

Brent Ozar Unlimited : A Strange Place For A Memory Grant

If You Hang Around Fetish Bars Long Enough… You learn things about memory grants in execution ...

 

24.05.2018

Paul S. Randal : SQLskills SQL101: Why do some wait types need to be ignored?

SQLskills has an ongoing initiative to blog about basic topics, which we’re calling SQL101. We’re al...

 

23.05.2018

Brent Ozar Unlimited : How to Reduce the CPU Overhead of Dynamic SQL

Dynamic SQL is a good choice for catch-all type queries, but you have to be careful how you execute ...

 

23.05.2018

Marco Russo : Time intelligence issues in DAX for fiscal years starting in March

If you have a fiscal year starting in March, you can have a problem using the time intelligence func...

 

22.05.2018

Brent Ozar Unlimited : Trivial Plans, Simple Parameterization and Check Constraints

Trivial Plans Are Weird They’re the optimizer’s “Yes, Dear”.  The thing is, ...

 

21.05.2018

Brent Ozar Unlimited : Building SQL ConstantCare®: Adding Daily Emails and Recognizing Your Work

When we first launched SQL ConstantCare®, the workflow was: You sent in data about your SQL Servers ...

 

21.05.2018

Marco Russo : From SQL to DAX: Joining Tables

In SQL there are different types of JOIN, available for different purposes. This article shows the e...

 

20.05.2018

Brent Ozar Unlimited : [Video] Office Hours 2018/5/16 (With Transcriptions)

This week, Brent, Erik, Tara, and Richie are back in action again to and are discussing sys.dm_db us...

 

19.05.2018

Stacia Misner : Handling JSON in SSIS

I believe the first time I ever learned JSON was a thing in the data world was when I attended SQLSa...

 

18.05.2018

Brent Ozar Unlimited : Stuff People Tell Me Is The Default

Playing The Odds Assuming that life carries on as usual for a couple more weeks, I’ll have bee...

 

17.05.2018

Brent Ozar Unlimited : How to Create Deadlocks and Troubleshoot Them

Watch in awe and wonder as I create a deadlock, then use sp_BlitzLock after the fact to show you whi...

 

16.05.2018

Kevin Kline : Quick Tip – Speed a Slow Restore from the Transaction Log

Here’s a quick tip for you: During some restore operations on Microsoft SQL Server, the transa...

 

16.05.2018

Brent Ozar Unlimited : Quick Tips For Debugging Large Stored Procedures

Hell Here! Get Your Fresh Hell, Here! Let’s face it — as far as developer tools go, SSMS...

 

15.05.2018

Brent Ozar Unlimited : How to Screw Up Your Database Updates in 3 Simple Steps

Hi. I’m not Brent. My name’s Alex, and I care about databases, DevOps and data protectio...

 

15.05.2018

Glenn Berry : SQLskills SQL101: The Importance of Maintaining SQL Server

SQLskills has an ongoing initiative to blog about basic topics, which we’re calling SQL101. We’re al...

 

14.05.2018

SQL Server Blog : A new update for mssql-cli, an interactive CLI, is now available

We have released our second major update for mssql-cli since our public preview announcement in Dece...

 

14.05.2018

SQL Server Blog : Visualize geographic spatial data from SQL Server directly in Tableau 2018.1

This is a partner post authored with the Tableau team As part of Microsofts open and flexible platfo...

 

14.05.2018

Brent Ozar Unlimited : Building SQL ConstantCare®: I Love Unit Tests

You know what my biggest regret is about sp_Blitz? No unit tests. Seriously. Back then, I wrote a bu...

 

14.05.2018

Brent Ozar Unlimited : Today’s Press Conference Transcript: I’m Running for Database Administrator General

Thanks for joining me today – I know you reporters are all really busy, and I appreciate you t...

 

12.05.2018

Stacia Misner : Revisiting Dynamic Web.Contents()

Thus far in my series of posts using hockey data to explore the subject of data analytics in Power B...

 

12.05.2018

SQL Server Customer Advisory Team : Turbo boost data loads from Spark using SQL Spark connector

Reviewed by: Dimitri Furman, Xiaochen Wu Apache Spark is a distributed processing framework commonly...

 

11.05.2018

Brent Ozar Unlimited : Informal Poll: What Are Your Favorite Error Log Messages?

I Know You Have Yours I have mine. When I go looking at a server for the first time, I wanna know ab...

 

11.05.2018

Erin Stellato : Do you need to update statistics after an upgrade?

There are a variety of methods we use for helping customers upgrade to a new SQL Server version, and...

 

11.05.2018

Brent Ozar Unlimited : Where Clustered Index Keys Dare

Colonel Clustered We’ve blogged a couple times about how clustered index key columns get store...

 

10.05.2018

Erin Stellato : Query Store Examples: Stories from customers

In the past week I’ve used Query Store to troubleshoot performance issues for two different cu...

 

10.05.2018

Brent Ozar Unlimited : Book Review: Microsoft SQL Server Training, Volume 1

Last week, I shared a few pictures out of Ron Soukup’s Inside SQL Server 6.5 book. You had a b...

 

09.05.2018

SQL Server Blog : SSMS 17.7 is now available

This post is co-authored bySandy Winarko, Principal PM, SQL Server. We are excited to announce the r...

 

09.05.2018

Brent Ozar Unlimited : When Query Plans Lie Part 2

Getting Weirder In Part 1, we looked at how query plans can tell us little lies. Now we’re goi...

 

08.05.2018

SQL Server Blog : The May release of SQL Operations Studio is now available

This post is co-authored by Karl Burtram, Senior Software Engineer, SQL Server. We are excited to an...

 

08.05.2018

SQL Server Blog : Database scoped default online options is in preview for Azure SQL DB

This post is authored byJosh Gnanayutham, Program Manager, Azure SQL Database. We are happy to annou...

 

08.05.2018

Brent Ozar Unlimited : The DeWitt Clause: Why You Rarely See Database Benchmarks

Back in the early 1980s, Dr. David DeWitt – who you might know from past PASS Summit keynotes,...

 

07.05.2018

Marco Russo : Using COMBINEVALUES to optimize DirectQuery performance

This article describes the behavior of the COMBINEVALUES function in DAX, and how it can optimize th...

 

07.05.2018

Brent Ozar Unlimited : When Query Plans Lie Part 1

Freaking Out Brent Is a full time job. Some days I can get him to hit the desk drawer tequila, and o...

 

07.05.2018

Brent Ozar Unlimited : Availability Groups Bug with Indexed Views

The short story: if you drop an index on an indexed view, queries on the Always On Availability Grou...

 

06.05.2018

Marco Russo : DAX Formatter now uses a different color for variables names

In the latest weeks I received several requests to support a different color for variable names in D...

 

06.05.2018

Stacia Misner : Numerical Variable Relationships

In the previous post in this series (which began all the way back in February 2018 with Getting Star...

 

05.05.2018

SQL Server Customer Advisory Team : CPU and Memory Allocation on Azure SQL Database Managed Instance

Reviewed By: Ajay Kalhan, Borko Novakovic, Drazen Sumic, Branislav Uzelac In the current Azure SQL D...

 

05.05.2018

SQL Server Customer Advisory Team : Azure SQL DB Managed Instance – sp_readmierrorlog

Reviewed by: Kun Cheng, Borko Novakovic, Arvind Shyamsundar, Mike Weiner Azure SQL Database Managed ...

 

04.05.2018

Marco Russo : Removing column filter in Power BI when Sort by Column is active

A recurring issue for Power BI users writing DAX code is that column filter removal might have an un...

 

04.05.2018

Brent Ozar Unlimited : Parameter Fluid Optimization

Optimizer Studies I don’t have a real job, which means that if something strikes my fancy, lik...

 

04.05.2018

Glenn Berry : Windows Disk Cleanup

One very useful tool for freeing up disk space is the built-in Disk Cleanup application in Windows. ...

 

03.05.2018

Brent Ozar Unlimited : Hey, That’s Not My Sort!

Understand Your Plan When reading query plans, you may sometimes see a sort when you didn’t ex...

 

02.05.2018

Glenn Berry : SQL Server Diagnostic Information Queries for May 2018

This month, there are more minor updates to the SQL Server 2012 and newer versions of the queries, p...

 

02.05.2018

Brent Ozar Unlimited : Book Review: Inside SQL Server 6.5

30 years ago, back in 1988, Microsoft, Ashton-Tate, and Sybase got together to start building SQL Se...

 

01.05.2018

Brent Ozar Unlimited : I’m speaking at SQL Saturday NYC

No, Not Brent Just me. And a few dozen other people, on May 19 (2018). I have sessions on the query ...

 

01.05.2018

Brent Ozar Unlimited : First Responder Kit Release: Darn May Showers

There’s usually something that I think is funny in this space. Instead, I’m going to ext...

 

30.04.2018

Brent Ozar Unlimited : Building SQL ConstantCare®: Refining Our Recommendations

One of the fun things about building SQL ConstantCare® as a cloud-based service is that we can itera...

 

29.04.2018

Stacia Misner : Categorical Variable Relationships

I knew I had a lot to say in this series…and we’re still at the tip of this iceberg with...

 

29.04.2018

Brent Ozar Unlimited : [Video] Office Hours 2018/4/25 (With Transcriptions)

This week, Brent, Erik, Tara, and Richie to discuss cloud server disaster recovery, Availability Gro...

 

27.04.2018

Brent Ozar Unlimited : Concurrency Week: How to Delete Just Some Rows from a Really Big Table

Say you’ve got a table with millions or billions of rows, and you need to delete some rows. De...

 

26.04.2018

Brent Ozar Unlimited : Concurrency Week: An Odd Case of Blocking

It’s Not A Trigger Because I know, I know. It’s always a trigger. Ha ha ha this query on...

 

25.04.2018

SQL Server Blog : The April release of SQL Operations Studio is now available

This post is authored by Alan Yu, Program Manager, SQL Server. We are excited to announce the April ...

 

25.04.2018

SQL Server Blog : Modernize to cloud with Azure SQL Database

Companies are embracing digital transformation by migrating to the cloud. IT organizations are conti...

 

25.04.2018

Brent Ozar Unlimited : Concurrency Week: How Entity Framework and NHibernate Can Cause Poison RESOURCE_SEMAPHORE Waits

I’ve already blogged about my dislike for ORMs from a production DBA performance tuning standp...

 

24.04.2018

SQL Server Blog : SQL Server 2016 Service Pack 2 is now available

The SQL Server team is excited to bring you the second service pack release for SQL Server 2016. The...

 

24.04.2018

Brent Ozar Unlimited : Concurrency Week: Can SELECTs Win Deadlocks?

Yes, especially when they’re part of a larger transaction. In this example, I’m going to...

 

24.04.2018

Marco Russo : Time Intelligence in Power BI – Global Power BI User Group

Time Intelligence is probably the most interesting feature of any analytical solution. Computing Yea...

 

24.04.2018

Marco Russo : Using OR conditions between slicers in DAX

This article describes how to implement in DAX a logical OR condition between the selection of two s...

 

23.04.2018

Brent Ozar Unlimited : Building SQL ConstantCare®: Why We Avoided Graphs

When we started building SQL ConstantCare®, one of my early decisions was to focus on a text-based i...

 

23.04.2018

Marco Russo : Budgeting with Power BI – PASS Austria

Budgeting is one of the most challenging scenarios in the Power BI arena. For example, you might nee...

 

21.04.2018

Brent Ozar Unlimited : [Video] Office Hours 2018/4/18 (With Transcriptions) with Special Guest Drew Furgiuele

This week Drew Furgiuele joins Brent and Richie to discuss patching, job interview suggestions, usin...

 

20.04.2018

Brent Ozar Unlimited : Does an Index on Just The Clustering Key Ever Make Sense?

Say you’ve got a table – in this case, I’m using the Stack Overflow Posts table, w...

 

19.04.2018

Stacia Misner : Boxes and Lines…Er, Whiskers

I had to cut short my last dabbling in distribution post because I had to get to Game 2 of Round 1 o...

 

19.04.2018

SQL Server Blog : SQL Server 2017 on SUSE Enterprise Linux Server offer

This post is authored by John ‘JG’ Chirapurath, General Manager, Azure Data. Since SQL Server 2017 o...

 

19.04.2018

Glenn Berry : SQL Server 2017 Cumulative Update 6

On April 17, 2018, Microsoft released SQL Server 2017 CU6, which is Build 14.0.3025.34 I count 39 fi...

 

19.04.2018

Brent Ozar Unlimited : So You Wanna Debug SQL Server Part 2

Birth Control Debugging, and, heck, even learning about debugging, is a time-consuming and often unh...

 

18.04.2018

Brent Ozar Unlimited : Index Key Column Order And Supporting Sorts

Whatever Man When tuning queries that need to sort large amounts of data, sometimes it makes sense t...

 

17.04.2018

Paul S. Randal : Read committed doesn’t guarantee much…

A while back I was involved in an email thread where people were wondering about some ‘weird’ behavi...

 

17.04.2018

Brent Ozar Unlimited : Parking Garages And Predicates

Hotels on Wheels Parking garages and predicates have a “lot” in common. GET IT? No no bu...

 

16.04.2018

Brent Ozar Unlimited : Building SQL ConstantCare®: The Database

I bet, dear reader, that this is the post you’ve been really curious about in my behind-the-sc...

 

16.04.2018

Marco Russo : DAX Optimization Examples – SQLBits 2018

How do you optimize a DAX expression? In this session, Alberto Ferrari analyzes some DAX expressions...

 

16.04.2018

Marco Russo : DAX Best Practices – SQLBits 2018

As with any other language, you can write good DAX but you can also write bad DAX. Good DAX works fi...

 

15.04.2018

Brent Ozar Unlimited : [Video] Office Hours 2018/4/11 (With Transcriptions) with Special Guest Edwin M Sarmiento

This week @EdwinMSarmiento joins Brent, Tara, Erik, and Richie to discuss high availability disaster...

 

13.04.2018

Stacia Misner : Dabbling in Distributions Part 2

One playoff game down, three to go. So far, so good for my Vegas Golden Knights! Not only did we win...

 

13.04.2018

Brent Ozar Unlimited : Training Week: Data Science Fundamentals with a Real Project

When Steph Locke first ran her Data Science Fundamentals with R class, I was amazed at the work she ...

 

12.04.2018

Brent Ozar Unlimited : Training Week: Announcing Ben Miller’s PowerShell for DBAs: Level 2

Drew Furgiuele‘s PowerShell for DBAs class has been getting rave reviews, including: “Fa...

 

11.04.2018

Glenn Berry : PASS Summit 2018 Pre-con:Fixing Query Performance Problems from Estimates, Statistics, Heuristics, and Cardinality

PASS has publicly announced their Pre-conference Sessions for the PASS Summit 2018 in Seattle, WA. T...

 

11.04.2018

Brent Ozar Unlimited : Training Week: Announcing Edwin’s New Class on Failover Clustered Instances

This week, we’ve got a bunch of announcements about new training classes. Next up, Edwin Sarmi...

 

11.04.2018

Brent Ozar Unlimited : Training Week: PASS Summit 2018 Pre-Con: Performance Tuning in 21 Demos

You’re a developer or DBA who wants to tune indexes and queries to make your application go fa...

 

10.04.2018

SQL Server Blog : Celebrating 1M installations milestone for mssql extension for VS Code with another update

This post is authored by Alan Yu, Program Manager, SQL Server. We are excited to announce that a new...

 

10.04.2018

SQL Server Blog : Cloud data and AI services training roundup

To help you stay up to date on online training opportunities, we’re releasing a monthly list of the ...

 

10.04.2018

Brent Ozar Unlimited : Training Week: Announcing a New Instructor: Kalen Delaney!

Kalen Delaney has been a Microsoft MVP for SQL Server since 1993. She is the author of several highl...

 

09.04.2018

Marco Russo : Expanded tables in DAX

Expanded tables are the core of DAX; understanding how they work is of paramount importance. This ar...

 

09.04.2018

SQL Server Blog : Celebrating data and you with #SQLDataWins

Hey you, data whiz! You’re an expert, a data aficionado, a steward of a finely tuned database – but ...

 

09.04.2018

Brent Ozar Unlimited : [Video] Office Hours 2018/4/4 with Special Guest Pinal Dave

This week, Pinal Dave joins Brent, Tara, and Richie to discuss replication latency, partitioning tab...

 

07.04.2018

Stacia Misner : Dabbling in Distribution

Hockey season is almost over and I’m very excited to see my home team, Vegas Golden Knights, n...

 

07.04.2018

Brent Ozar Unlimited : How To Break SQL Server’s XML Data Collection

Oh, XML When we first met, it was about 2011. I had to load files full of you into a table. It wasn&...

 

06.04.2018

Brent Ozar Unlimited : Column Store Deadlocks: Missing Information

People seem to care about deadlocks That’s why I wrote sp_BlitzLock. Why not sp_BlitzDeadlock?...

 

06.04.2018

Marco Russo : International year_end_date for YTD functions in DAX

If you used the DATESYTD and TOTALYTD functions in DAX, you might have noticed that the optional par...

 

05.04.2018

Brent Ozar Unlimited : Building SQL ConstantCare®: 10% of you have Priority Boost on.

One of my favorite things about my job is being able to take the pulse of how real companies are man...

 

04.04.2018

Paul S. Randal : SQLskills SQL101: Why does repair invalidate replication subscriptions?

SQLskills has an ongoing initiative to blog about basic topics, which we’re calling SQL101. We’re al...

 

04.04.2018

Brent Ozar Unlimited : The Many Mysteries of Merge Joins

Not A Single Picture Of A Zipper There are some interesting things about Merge Joins, and Merge Join...

 

03.04.2018

Glenn Berry : New TPC-E Result for SQL Server 2017

On March 31, 2018, Fujitsu submitted a new TPC-E result for a two-socket PRIMERGY RX2540 M4 system r...

 

03.04.2018

Glenn Berry : SQL Server Diagnostic Information Queries for April 2018

This month, there are more minor updates to the SQL Server 2014 and newer versions of the queries, p...

 

03.04.2018

Brent Ozar Unlimited : Building SQL ConstantCare®: The Minimum Viable Product (MVP)

When you wanna build something, how early do you let the public in? Where do you draw the lines with...

 

02.04.2018

Paul S. Randal : New live online training class on Query Store in May!

Continuing our series of live, online classes, Erin will be delivering her new IEPS: Immersion Event...

 

02.04.2018

Brent Ozar Unlimited : Building SQL ConstantCare®: What Data We Collect (and What We Avoid)

Next up in my series of behind-the-scenes posts about our new SQL ConstantCare®, let’s talk ab...

 




Interested?

Receive our monthly newsletter



;