Monday, July 27, 2015

SQLSaturday #423 Baton Rouge

This is I believe the 7th SQLSaturday in Baton Rouge. Please come out this Saturday at the LSU Business Center to enjoy free training, prizes and networking with over 500 IT professionals.

sqlsat423 

Here is the schedule.

Friday, July 24, 2015

Power Bi Desktop Release Today

You can download the much hyped up Power BI Desktop (formerly Power BI Designer). There are many blogs about the new features, but I am going to mention one here that I have been waiting for.

It involves connecting to the Analysis Service database as a connection and not an import all the tables into the Power BI file.

Once Power BI Desktop is Open…

image Click on Get Data…

image  then highlight SQL Server Analysis Services Database

Click Connect…

image 

Now, you have a new option

- Explore the Tabular model by using a live connection

You no longer have to use the option to retrieve the data into the Power BI file.

Once you click OK after entering the instance name…

image

You now can Navigate to the SSAS Database and select the Model or Perspective to connect to. Once selected, click OK

image

Now, you can start building the visualization like PowerView connected to a tabular database.

image

Thursday, July 16, 2015

New Features of SQL Server 2016

The next version of SQL Server looks to add more and more features helpful in database design and administration as well as Business Intelligence.

The first I found interesting is Temporal Tables. This table keeps a history of the changes made to the table over time. This will change how software developed to track changes will be coded in the future. How wonderful it would be not to have to worry about this. Another plus side to all these changes is more and more DBAs will be needed :)

The next feature is Stretch Database. This option lets you use Azure to store and retrieve archival data in the cloud. I was not much of a fan of the cloud in the beginning, but now I see benefits as the technology advances to make it easier to manage.

In-Memory technology as well as Column Store indexes seemed to be the big items for performance improvements. Check here and here for those updates. If you are really interested in reading about Column-store indexes, check out NikoPort’s blog.

Of course, I will have to mention something about SSIS. Incremental Package Deployment is the one that interest me most. Not having to deploy the whole project will help with the manageability of versions on the production server. It was great when SSISDB was released in 2012, and it looks like Microsoft is going to keep improving this option.

Performance improvements to the tabular model of Analysis Services seems to be the direction Microsoft is heading as far as SSAS improvements are concerned. The parallel Processing of Partitions will make it more in line with the advanced features of Multidimensional Cube. I still believe Multidimensional Cube is needed for Enterprise level cubes, but tabular is catching up.

New DBCC commands are added to check for corruptions in Analysis Services database (both Multidimensional Cubes and Tabular Models) as well as new DAX functions for Tabular. Read here for the full list for Analysis Services.

Of course, all of this is in the current CPT release and can change so get updated will the latest.

Friday, June 26, 2015

PASS Summit Selection Process

I was thinking today about why I submit sessions to speak at the PASS Summit.

My first summit was in Denver back around 2006 or 2007. We (my boss and me) saw an ad for it on SQL Server Central. We enjoyed every minute of the Summit and had about 100 things to go back to the office and implement. Problem was, there were too many ideas to implement and we weren’t to successfully at applying the changes. The trip did get us a list of speakers to watch for published articles and blogs, plus a consultant firm or 2 to help us expand the SQL Server environment at a growing company.

The next year our plan was to find 2-3 ideas from the Summit and come back to the office and implement one within a month, the second within 3 months, and hopefully get to the third. The first was Clustering and that went well and on time. The second was Data Mirroring and that took a little longer. I do not remember the last item.

One other thing happened. I sat in a session or 2, and both me and my boss were like ‘I can do that.’ Meaning, we both could have gave that talk. Not really, but that is what we thought.

Patrick LeBlanc had started a SQL Server User Group in Baton Rouge and they were looking for speakers. I signed up. My boss (or bosses at the time) helped me refine the session and off I went. I had been doing Lunch and Learns at the last 2 jobs which helped this process. Everything went well until I got to something I did not have experience, and I could not answer the question posed from the audience. This set in motion a drive to learn more about SQL Server.

I submitted to SQLSaturday in Baton Rouge and prepared for an advanced session. Not many SQLSatuday attendees come for an advanced topic. This got me thinking that sessions at SQLSatuday need to be more introduction to topics or intermediate instead of advanced. This started a successful session building list of ideas: Focus on helping 3-5 individual learn more about SQL Server. That is why I first went to the Summit.

After 2 years of local user group and SQLSaturday talks, I got selected for a PASS Summit and the first SQLRally. The other thing I learned to have a better chance at getting picked is to find topics that are not a lot of submissions for. The second part of my process is to go watch successful sessions at the PASS Summit and find out how they present (style), abstract writing (catchy descriptions) and what the person does before and after the sessions. Blogging is also helpful for ideas and practice.

This may sound mean, but I also stop going to sessions by Microsoft speakers even though the subject was something I needed to learn. This is not a knock to the speaker or session or Microsoft, but I found it better to watch presenters with industry experience. The Microsoft sessions can be learn/watched later online or the information is in White Papers. This was just a personal opinion.

New Features is another topic I avoid right now because so many people want to talk about that new feature. Without some experience, I am not the right speaker (at the present moment) to do those talks. But, it is not a bad idea to talk about something you do not have a lot of experience with. This determination will get you to spend time (more than usually) learning about that topic or feature. The is what I have done to advance a feature at the companies I worked for.

I hope we all continue growing the community of speakers, bloggers and experts to keep the SQL Server community healthy and exciting.

Thursday, June 18, 2015

PASS Excel BI VC presents Ásgeir Gunnarsson: End to End Risk Assessment – Using PowerView

Join us today at noon central for Asgeir presenting for the Excel BI VC.

Thu, Jun 18 2015 12:00 Central Daylight Time


PASS Excel BI VC presents Ásgeir Gunnarsson: End to End Risk Assessment – Using PowerView

RSVP: https://attendee.gotowebinar.com/register/259088186466925058

END TO END RISK ASSESSMENT – AFFORDABLE SOLUTION USING POWER BI AND EXCEL

Risk assessment is becoming an integral part of many organizations. In order to do it successfully you need to do it regularly and consistently. You need to register the risk factors, the risks them self, evaluate them and then plan the actions required to mitigate them. Besides the registration you need to have compelling and easy reading reports that help managers quickly find how the assessment is going. The familiar Excel interface helps assessors register the risk factors and risks and then plan the actions. The solutions then uses Power Query to load data into PowerPivot without overwriting and the Power View to report the results. The results can then be monitored in Power BI. This method can easily transfer to any other data collection solution such as budgeting or incident registration Decent knowledge of Excel and a familiarity with Power Query, PowerPivot, Power View and Power BI sites


Ásgeir is a Senior Consultant with Capacent Iceland working with Business Intelligence and planning solutions using different software vendors. Ásgeir has been working in BI since 2007 both as a consultant and internal employee. Before turning to BI Ásgeir worked as a technical trainer and currently teaches BI courses at the Continuing Education Department of the University of Iceland. Ásgeir is passionate about data and loves solving problem

Thursday, June 4, 2015

SQLSaturday #408 Houston

I have been selected again to speak in Houston (Saturday, June 13th) for a SQLSaturday event and look forward to connecting with some Texas PASS members like Nancy, Alan, Jen, Sean and many others. The facilities at San Jacinto College in the Southwest part of the Houston area were great last year. These free events (yes, I said free) have wonder sponsors that help cover cost especially Lunch!!!

http://www.sqlsaturday.com/408/Sponsors.aspx

image 

The presentations for this event for me are BI related: Getting Started with Tabular and Excel 2013 Tips and Tricks. These are session I have done a couple of times and get great responses. I have a couple of speakers I would like to see and hope to peak inside their sessions.

Hopefully I will see some of you there and we can talk. Come find me.

Getting started with Tabular Analysis Services [Room 1.117]

Speaker(s)Thomas LeBlanc

Duration: 60 minutes

Track: Business Intelligence

 

Excel 2013 Tips and Tricks for Displaying a Multidimensional Cube [Room 1.147]

Speaker(s)Thomas LeBlanc

Duration: 60 minutes

Track: Business Intelligence

 

Thursday, May 7, 2015

PASS Elections and Verifying Account

It is that time of the year when PASS starts a process to help update memberships and clean up duplicate account. I just Deactivated an old account setup in 2006 I never used.

Here is some more info and links. This material is copied from PASS website and emails.

Announcing 2015 PASS Elections Season

Are you ready to participate in the 2015 PASS Nomination Committee (NomCom) and Board of Directors elections? PASS is your community--don't miss this opportunity to shape its future by casting your ballot!

Who can vote?

Any PASS member who has a complete myPASS profile by 11:59 PDT on June 1, 2015, is eligible to vote in this year's elections. 

How do I vote?

The first step is to make sure that you are eligible to vote:

1. Log into your myPASS account
2. Click myProfile
3. Review and udpate all fields
4. On the myPASS section of your profile, you should see a green check mark in the Voting Eligibility section. This will confirm your status.

 

PASS Voting Eligibility and Upcoming Elections

Posted in [PASS General], [Virtual Chapters], [PASS Chapters], [Elections] By Bill Graziano

May 7, 2015 – During the 2014 election cycle, the PASS Board established specific eligibility requirements for voting in the PASS elections. These requirements are designed to help de-duplicate member data for eligible voters before ballot notifications are sent. Specific mandatory fields have been added to the myProfile section of sqlpass.org to help us better serve the community.

To cast a ballot, members must complete all mandatory fields in their myPASS profile. PASS members who have not completed their profile will receive a reminder to update their myPASS profile to be eligible to vote. Your profile must be completed by 11:59 pm PDT June 1, 2015 to guarantee eligibility to cast ballots in the 2015 PASS elections.   

Don’t miss your chance to vote in the PASS elections! To confirm your eligibility, please log into your myPASS account to look for the follow eligibility stamp:

PASS is your organization. Thank you for helping to shape its future by participating in the elections process. 

–Bill Graziano
Immediate Past President