MSBI Tutor

DECLARE @SQLStatement VARCHAR ( 200 ) DECLARE @jobName SYSNAME    DECLARE c1 CURSOR FOR    SELECT name FROM msdb . dbo . sysjobs_view WHERE name not in ( 'syspolicy_purge_history' , 'Agent history clean up: distribution' , 'Distribution clean up: distribution' , 'Expired subscription clean up' , 'INDSBLRHT0VR72-AdventureWorks2017-2' --Change the job name as per your environment , 'INDSBLRHT0VR72-AdventureWorks2017-Adven_Pub-2' --Change the job name as per your environment , 'INDSBLRHT0VR72-AdventureWorks2017-Adven_Pub-INDSBLRHT0VR72-5' --Change the job name as per your environment , 'Reinitialize subscriptions having data validation failures' , 'Replication agents checkup' , 'Replication monitoring refresher for distribution' )    OPEN c1    FETCH NEXT FROM c1 INTO @jobName      IF @@CURSOR_ROWS = 0      PRINT 'No Job found! Please re-c...

We’re excited to bring you a new version of Power BI Report Server this Fall! With the September 2021 update, we have a variety of new enhancements, including line charts improvements, new formatting options for buttons, small multiples new feature, and the new Model View. Please continue to read on! Here’s a complete list of the updates: Reporting Area chart transparency sliders Inner padding for continuous axes Small multiples new feature Conditional formatting for assorted visuals Customize shape formatting Line chart improvements X-axis constant line improvements Line chart series labels New formatting options for buttons Toggle total columns in waterfall charts Modeling New Model View New way of expressing Date and DateTime values Shortcut expression for CALCULATE now supports aggregation functions New parameter for XIRR function Making it easier to format based on a user’s locale Evaluation configuration settings Paginated Reports New version of P...

SQL Saturday Orlando is a free one day training event for data platform professionals. We will be having our 14th annual Saturday on October 30, 2021 at the Orlando Marriott Lake Mary . This is a free event for the Orlando data community organized by SQLOrlando ( blog , Meetup ). Registration is free. We encourage you to register early, but if your plans change please cancel your registration so that others can attend. Our event schedule this year: 8 am. Check-in is open. Grab coffee and a pastry while you visit with our great sponsors in the main foyer. 9 am. Sessions begin. 12:30 pm. Lunch break. We have not finalized the lunch plan for this year, but it is very possible that will not have lunch on site - more details on this as we get closer to event day! 1:30 pm. Sessions resume. 4:00 pm. Event ends. 4:30 - 6:30 pm. After party, location TBA. COVID Policy Our goal is to conduct this event and do what we can to keep everyone safe. As a minimum we will enforce whatever poli...