Showing posts with label SQL PASS. Show all posts
Showing posts with label SQL PASS. Show all posts

Friday, July 21, 2017

SQLSaturday Baton Rouge #628 2017

Come join around 500+ attendees and speakers learning and networking at the LSU College of Business – Business Education Complex on Nicholson Drive Extension in Baton Rouge on Saturday July 29th 2017 8AM till 5PM. There will be plenty of MVPs and other experts in the areas of SQL Server, Business Intelligence, Microsoft Data Platform, .Net, SharePoint, System Administration and more. The schedule is located here.

My session is on What is new in Analysis Services? I will try to cover some of the neat things I see that are helpful as well as try to encourage you to watch blogs because SQL Server is starting to be released more frequently, like every year.

Steve Jones from SQLServerCentral.Com and RedGate will be there with sessions Branding Yourself for a Dream Job and Bringing DevOps to the Database.

Stay till the end and see if you can win a prize from all the wonderful Sponsors and please Thank them.

Remember this event is FREE!!!


image

Monday, June 19, 2017

PASS Board Elections

Well, it is almost that time of the year again. Elections for the PASS Board.

image

This is a great way to show your passion for this wonderful community of SQL Server or now, Microsoft Data Professionals. It looks like it is getting harder and harder for someone to come up with a general description of the members in this Global User Group. I see we are now going back to our roots with investing in the Developer side of the industry.

The upcoming dates and other election information you need to keep in mind are available from these links:

Upcoming Dates

Election Process

NomCom Changes from last year

I hope ya’ll all participate in this process that elects leaders with a desire to move PASS forward while maintaining over education and networking opportunities for SQL Server professionals.

Thursday, June 1, 2017

SQLSaturday Pensacola and Houston

I have the honor of being selected to speak in Pensacola and Houston this month. Pensacola has been a great place for SQLSaturday and it is no different than Houston. Both have active PASS community volunteers that love to host a learning event for free.

Both events have conference level 60 minute sessions by MVPs, MCMs and other prefessionals. AND IT IS FREE!!! Well, sometimes they charge for lunch.

 

Here is the schedule for Pensacola this weekend Jun 3rd, 2017 - http://www.sqlsaturday.com/617/Sessions/Schedule.aspx

What is Power BI?

Do you want to know what all the fuss (or excitement) is about concerning PowerBI? Then, this session is for you. We will walk through the process and marketing of what now is Power BI. Reports will be developed and displayed as well as the history of development of Power BI and what to look out for in this ever changing application. You will also learn that this tool is not replacing the Data Warehouse and Architect positions. Actually, it will produce more work for us (DBAs, Architects, etc.) It is another reporting option Microsoft that is positioning itself in the changing world of Business Intelligence

And here is Houston’s on Jun 17th - http://www.sqlsaturday.com/651/Sessions/Schedule.aspx

Business Analytics in SQL Server 2016

Ever wonder what’s going on with Microsoft Business Intelligence features? Is everything going to the Cloud, or can I still rely on my own servers to design systems? Well, this session is for you. We are going to spend hours on looking at the new features of SQL Server 2016 that will help you create on premise solutions for you company or clients that complement the solutions you have already built. SQL Server 2016 not only gives you new tools like R integration and Mobile Reporting, but enhances Analysis Services and Reporting Services you have been using for years

You will leave with a comforting feeling that Microsoft is not leaving you behind if you do not or cannot go to the Cloud. Perhaps we shall see the thunder of BI love to what we know best and to succeed in the future

See ya soon!!!

Thursday, May 11, 2017

PASS Summit Call for Speakers

Yesterday was the first day to submit sessions for the PASS Summit 2017 in Seattle on Oct 30th thru Nov 3rd. Oct 30th and 31st are for pre-conference sessions (all day workshops) and this year there is no open call for these sessions. Not sure the selection process because it seems to be behind the scenes, but apparently feedback from attendees is driving a change in quality and content.

PASS Summit 2017

Here is a link to the Call For Speakers. It has been a blessing to have spoken at the last 6 Summits and attending 9 out of the last 10. There is so much to take in at a PASS Summit, and it took me about 3-4 years to learn how to make the most out of this conference.

The Summit tracks have changes, so go here to get the list. The open call for speaker closes on May 24th, so get busy with your submissions. There is also a limit of 3 session submissions and only for the 75 minute and 10 minute Lighting Round.

The Speaker Resource page is a great area of information about speaking at the Summit. There is even a Submitted Sessions page, once you login in, to see what has already been submitted.

You can also go to the Blog page of the PASS.org site to see board members explain the new speaker selection process.

Saturday, April 22, 2017

Excel BI VC presents Prathy Kamasani–Power BI Dashboards for Excel Users

 

Thu, Apr 27 2017 20:00 GMT Daylight Time


Power BI Dashboard within an hour for Excel users

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

Power BI Dashboard within an hour for Excel users

If you are an experienced Excel user or Someone in your organisation mentioned about Power BI and you want to understand what you can do with it, then this session is for you. In this demo-focused session, Prathy will show how one can extract, transform, analyse and visualise the data using Microsoft Power BI. She will give a quick introduction to different features of Power BI, some of them are similar to Excel, and some are pretty new relate to Excel. Prathy will also talk about resources More...


Prathy Kamasani is a Microsoft Valuable Professional working as an independent MSBI contractor based in London. She specialises in Power BI, SSIS, SSAS and SSRS. Prathy organisers London Power BI user group and co-organises London PASS Chapter. She is a regular speaker at events like SQL Saturdays and local user groups.

Friday, March 17, 2017

PASS Excel BI VC: Improvements to Excel Pivot Table

Please join the PASS Excel Business Intelligence Virtual Group onn March 22nd 11AM Eastern for Microsoft’s Program manager Alexander Lahuerta. The presentation will be shorted than typical meetings, lasting 20-30 minutes.

But, the session will provide great insights into changes in Excel Pivot tables. You can register for the session at http://excelbivc.sqlpass.org or https://attendee.gotowebinar.com/register/3161827486429234947

Featured Presentation:  Improvements to Excel Pivot Tables
Alexander Lahuerta, Program Manager Microsoft

The Excel team is working on several interesting new features to Excel. Join us to take a look at some really interesting improvements to Excel that are soon to be released.

About Alexander:
I’m a Program Manager on the Excel Team at Microsoft. I’ve been here for three and a half years. For the past two years, I’ve been diving deep into Business Intelligence and making it easier for people to dig into their data. I want you to love PivotTables as much as I do.

Wed, Mar 22 2017 15:00 (UTC+00:00) Dublin, Edinburgh, Lisbon, London


Improvements to Excel Pivot Tables

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

Thursday, February 23, 2017

Upcoming PASS Events

There is a new website from PASS. Go to Pass.org instead of SQLPass.org. The change does not really concern me but marketing is something I am not into…yet!!!

The one thing I do like is the formatting when viewing on a mobile device. That is very nice. Here is what I found coming up in the PASS community.

 

BA Marathon – Business Analytics

There will be six back-to-back live webinars and the next BA Marathon will be spring 2017.

While you wait, why not access recordings from previous Marathons?

 

Here are some Virtual Chapter Recordings

SQL Server DBA Tips That Can Save Your A$$ -- Part 2 - Guy Glantser

Implementing New Security Features in SQL Server 2016, Part 2 – sponsored by Hewlett Packard Enterprise - Ronen Ariely

Why Your Data Type Choices Matter - Andy Yun

Implementing (and cracking) new Security Features in SQL Server 2016, Part 1 – sponsored by Hewlett Packard Enterprise - Ronen Ariely

Take Power BI Visualizations to the Next Level - Reza Rad

Azure SQL Database Elastic Pool – introduction and usage scenarios – sponsored by Hewlett Packard Enterprise - Kun Cheng

How SQL Server 2016 SP1 Changes the Game - Parikshit Savjani

Advanced Power BI: Solving the Hard Problems - Devin Knight

An (Advanced) Introduction to DAX - Eugene Meidinger

 

Here are some upcoming SQLSaturdays

25 FEBRUARY - SQLSaturday #585 - Boston 2017

MORE DETAILS

25 FEBRUARY - SQLSaturday #589 - Pordenone 2017

MORE DETAILS

25 FEBRUARY - SQLSaturday #596 - Denver - BI Edition 2017

MORE DETAILS

04 MARCH - SQLSaturday #603 - Dallas - BI Edition 2017

MORE DETAILS

11 MARCHSQLSaturday #583 - Lisbon 2017

MORE DETAILS

11 MARCH - SQLSaturday #592 - Raleigh 2017

MORE DETAILS

11 MARCH - SQLSaturday #600 - Chicago 2017

MORE DETAILS

Friday, January 27, 2017

Upcoming PASS Free Training

Here is a list of the upcoming PASS Virtual Groups and SQLSautrday Events.

January, 2017

Tuesday,January,31

Introduction to Oracle SQL and PL SQL

More Details

February, 2017

Wednesday,February,01

Linux OS Fundamentals for the SQL Admin

More Details

Tuesday,February,07

"ANSWERING THE QUESTION, “WHAT HAPPENED?” WITH QUERY STORE"

More Details

Thursday,February,09

Why Physical Database Design Matters By Kimberly L. Tripp

More Details

Tuesday,February,14

Partitioning Basics: Treating your tables like Lego

More Details

Tuesday,February,14

Detecting and Preparing for Corruption

More Details

Wednesday,February,15

Converting Unreliable Deployments Into Consistent Releases

More Details

Saturday,February,18

Why Your Data Type Choices Matter

More Details

 

Feb 04, 2017    SQLSaturday #595 - Cleveland 2017

Feb 11, 2017    SQLSaturday #582 - Melbourne 2017

Feb 18, 2017    SQLSaturday #587 - Sydney 2017

Feb 18, 2017    SQLSaturday #586 - Guatemala 2017

Feb 25, 2017    SQLSaturday #589 - Pordenone 2017

Feb 25, 2017    SQLSaturday #596 - Denver - BI Edition 2017

Feb 25, 2017    SQLSaturday #585 - Boston 2017

Mar 04, 2017    SQLSaturday #603 - Dallas - BI Edition 2017

 

Saturday, January 14, 2017

Upcoming SQL Server Events from PASS

There are many ways to reap benefits from being a member of the PASS Global Community. Today, as I write this blog, I glance over at twitter for hash tag #SQLSatNash and see all the speakers, volunteers and attendees express their love of this free event. You really never see “bad” tweets about one of these events.

image    image

SQLSaturday is just one of the many ways to earn about Microsoft Data Technologies. Click this link to see if an event is coming close to your town or city.

24 Hours of PASS happens a couple of times a year when there 24 hours of consecutive sessions. This is a Free event online.

Another way is to watch a virtual user group online for free. Click this link for a list of Virtual User Groups. Below is a list of upcoming events. This list can be viewed on the main page of SQLPass.org for your profile after you login.

Upcoming Events of Interest

There is a View All link to see a drill down of all the events.

Paid events include Pre-conference sessions at SQL Saturday, a week of sessions at the SQL PASS Summit and the Business Analytics area just had their first Day of Business Analytics in Chicago.

An individual can create many ways to take advantage of these resources to advance in his or her career. I have seen many people get involved with PASS and totally change the direction of there career. Some in consulting, some with a new company or some even get to work for some of the great software companies that are sponsors of PASS events. Start at SQLPass.org to find out what you can do to help in your current career or trying something new.

Monday, January 18, 2016

SQLSaturday Austin – Jan 30th

I will be speaking with other SQL Server experts for SQLSaturday #461 in Austin on Jan 30th, 2016. This is a FREE day of training. FREE!!!
There are also a couple of great Pre-Cons on Friday Jan 29th, 2016 that are very cheap compared to similar training at big conferences.
 
SQLSaturday #461 -- the precons will be held on Friday, January 29th, 2015 at the Microsoft office, 10900 Stonelake Blvd., Suite 225  Austin, TX  78759.  
Registration for SQLSaturday #447 Precon:
Creating a High Availability and Disaster Recovery Plan BY Ryan Adams -- http://sqlsat461-ha.eventbrite.com
Performance Tuning Like a Boss BY Robert Davis --http://sqlsat461-perf.eventbrite.com

Here is a list of the sessions for Saturday (FREE!!!):

Session Time Session Title Track Speaker(s)
09:00 AM - 10:00 AM Branding Yourself for a Dream Job Professional Development Steve Jones
09:00 AM - 10:00 AM Designing Stored Procedure Solutions Application & Database Development Jennifer McCown
09:00 AM - 10:00 AM Enforce Best Practices with CMS and Policy Based Management Enterprise Database Administration & Deployment Ryan Adams
09:00 AM - 10:00 AM From Here to Azure Enterprise Database Administration & Deployment Thomas LaRock
09:00 AM - 10:00 AM Know what your machines are doing besides SQL Server - WMI, WQL, and PoSH Enterprise Database Administration & Deployment Michael Bourgon
09:00 AM - 10:00 AM Using Power BI when Implementing Data Analytics Management Practices BI Information Delivery Ginger Grant
10:10 AM - 11:10 AM Continuous Deployments using SSDT Application & Database Development Christopher Wolff
10:10 AM - 11:10 AM Fun Facts about Availability Groups Enterprise Database Administration & Deployment Joe Hellsten, Joe Hellsten
10:10 AM - 11:10 AM Introducing Azure Data Factory Enterprise Database Administration & Deployment Kevin Hazzard
10:10 AM - 11:10 AM Introduction to Time Series Forecasting Advanced Analysis Techniques Peter Myers
10:10 AM - 11:10 AM SQL Server Deprecated and Discontinued Features Enterprise Database Administration & Deployment Nancy Hidy Wilson
11:20 AM - 12:20 PM Database Virtualization (Monster VM) – Vsphere 6 Enterprise Database Administration & Deployment Michael Corey
11:20 AM - 12:20 PM Dimensional Modeling 101 BI Platform Architecture, Development & Administration Thomas LeBlanc
11:20 AM - 12:20 PM Making the Leap from Developer to DBA Professional Development Amy Herold
11:20 AM - 12:20 PM Monster Text Manipulation: Regular Expressions for the DBA Enterprise Database Administration & Deployment Sean McCown
11:20 AM - 12:20 PM Parameter Sniffing the Good, the Bad and the Ugly Application & Database Development Lance Tidwell
02:00 PM - 03:00 PM Azure Machine Learning: From Design to Integration Advanced Analysis Techniques Peter Myers
02:00 PM - 03:00 PM Backup and Restore Tips and Tricks Enterprise Database Administration & Deployment Ryan Adams
02:00 PM - 03:00 PM ColumnStore Index:
Microsoft SQL Server 2014 and Beyond
BI Platform Architecture, Development & Administration Jayaprakash Jothiraman
02:00 PM - 03:00 PM Database Design Throwdown Application & Database Development Karen Lopez, Thomas LaRock
02:00 PM - 03:00 PM SQL Server 2014/2016 In Memory Technologies - OLTP (aka Hekaton) & ColumnSt Application & Database Development Reinaldo Kibel
02:00 PM - 03:00 PM The Data Warehouse of the Future BI Platform Architecture, Development & Administration Stan Geiger
03:10 PM - 04:10 PM "Can I Get A Report of This?": Introduction to SSRS BI Platform Architecture, Development & Administration Jeremy Frye
03:10 PM - 04:10 PM Changing Your Habits to Improve the Performance of Your T-SQL Application & Database Development Mickey Stuewe
03:10 PM - 04:10 PM Configuring SQL Server for Mission Critical and Scalable Deployments Enterprise Database Administration & Deployment Suresh Kandoth
03:10 PM - 04:10 PM Make Your SQL Server Queries Go Faster Enterprise Database Administration & Deployment John Sterrett
03:10 PM - 04:10 PM Mission Possible: Interactive Performance Troubleshooting - Index Enterprise Database Administration & Deployment Jim Murphy
03:10 PM - 04:10 PM Overview of Security Investments in SQL Server 2016 and Azure SQL Database Enterprise Database Administration & Deployment Jamey Johnston
04:20 PM - 05:20 PM Analyze your query plan like a Microsoft Engineer! Advanced Analysis Techniques Daniel Janik
04:20 PM - 05:20 PM Introduction to Biml BI Platform Architecture, Development & Administration Tim Mitchell
04:20 PM - 05:20 PM Service Broker: Coach your processes asynchronously Application & Database Development William Wolf
04:20 PM - 05:20 PM SQL Server Database Encryption (TDE) Enterprise Database Administration & Deployment Ben Miller
04:20 PM - 05:20 PM SS2014 In-Memory Tables: Formula 1 Performance Unleashed! Application & Database Development Mike Byrd
04:20 PM - 05:20 PM Strategies for Working with Texas-sized Databases Enterprise Database Administration & Deployment Robert Davis

Thursday, September 17, 2015

#ITDevCon15 Conner Cunningham Keynote

On Wednesday morning, Conner Cunningham from Microsoft was the keynote speaker for IT/DevConnections in Las Vegas. His talk focused on SQL Server 2016. To summarize the things he said that got my attention were a Live Query Plan, the Query Store to retrieve a previous query plan and Azure Dev First – then on-premise. Continue reading if you want more information.

The talk concentrated on SQL Server 2016. His favorite parts are making queries run faster because this is the area he helped in planning and development years ago. Now, he encourages the developers and architects to make queries run faster. DBAs love this stuff.

The talked started with an overview of the new features in releases 7.0 to 2014. It was good to see the progress in SQL Server from the early days to today.

Conner said SQL Server 2016 is a very, very big release – more announcements will come at PASS Summit 2015 at the end of October in Seattle.

The data engine is now 3 to 4 different actual engines in different development streams but using the same skill set for the DBA. The rise of cloud computing has shifted to development in Azure first, then using the same code base to release on-premise.

The development can be done faster now due to changes in the process at Microsoft and release and testing is easier because of the cloud. This gets feedback to the development team faster and updates to problems released sooner. What used to take 3-5 years, now is done in months.

Microsoft only vendor where on premise and cloud are fully supported on same code base!!!

Here is a list of new 2016 features

Security

  1. Row level permissions to limit rows returned (select statement returns only the rows the user has permission to see.)
  2. TQE – Transparent Queryable Encrypt (better protection)
  3. Data Mask columns (x’s in a SSN)

AlwaysOn Improvements

  1. Log transport improvements
  2. DB level failover rather than instance
  3. Load balance readable secondary
  4. ActiveDirectory integration
  5. DTC transaction support  (this was a big one)
  6. 2 failover targets

Language enhancements

  1. JSON support 
  2. Temporal table support – Historical tracking of changes automatically, Think Audit Tables

In-Memory Engine – OLTP (2014)

  1. 5-20 times faster
  2. Collation support, JOINs, Large DBs, MARS support, Initial UDF/TDF support and row level security

Column store enhancements

  1. Updateable non-cluster column store indexes
  2. Non-clustered B-tree indexes
  3. Always On support – readable secondary support

Polybase

  1. Query relational and non-relational data with T-SQL
  2. Hadoop support

Column store scales better with Degrees of Parallelism

  1. Batch mode scales far better

Stretch SQL Server in Azure

  1. For data you do not want to delete but need at some point
  2. Increases backup time where the warm data is backed up and cold data is in cloud (which has HA and backups/restores)
  3. For historical data

Upgrade

  1. Rewriting upgrade guide (was 429 pages)

Improved Upgrade advisor

  1. Try the tool

Eliminate Trace flags for High-End Scaling

  1. Most have been integrated in 2016

Optimizer Changes Now Tied to DB Compatibility Level

  1. Less risk for upgrades
  2. Trace Flag 4199 folded in new DB compatibility Level

Query Store

  1. Force prior plan
  2. Deep insight into workload performance
  3. Simplifies upgrades by reducing change risk

Conner says he has been working on Query Store for a long time and is extremely happy about this has finally been done

Monday, September 7, 2015

Dustin Ryan: Power Pivot 101: An Introduction

The PASS Excel Business Intelligence virtual chapter presents Dustin Ryan introducing everybody to Power Pivot in Excel. This chapter has gotten a lot of questions during some of the last couple of sessions that can be directly done in Power Pivot through Excel.

Please join us this Thursday September 10th at Noon Central time for our monthly Excel BI VC meeting. Below is more information:

Thu, Sep 10 2015 12:00 Central Daylight Time


Excel BI VC presents Dustin Ryan - Power Pivot 101: An Introduction

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

POWER PIVOT 101: AN INTRODUCTION

Power Pivot is a powerful yet flexible analytics tool built into a familiar environment yet many users remain unsure of how to take advantage of this dynamic tool. In this session, learn the purpose of Power Pivot, where Power Pivot fits within your organization and the basics of designing a Power Pivot model that integrates disparate data sources with the goal of gaining previously unrecognized insight into key business metrics.


Dustin Ryan is a senior BI consultant and trainer with Pragmatic Works in Jacksonville, FL. Dustin specializes in delivering quality enterprise-level business intelligence solutions to clients using SSRS, SSIS, SSAS, SharePoint, and Power BI. Dustin has authored and contributed to SQL Server books. You can find Dustin speaking at events such as SQLSaturday, Code Camp, and online webinars.

Tuesday, August 11, 2015

DevConnections Sept 14-17th 2015 – Las Vegas

DevConnections is a new conference for me and I am excited about the opportunity to present 2 different sessions. The conference is at ARIA Resort in Las Vegas, NV. There are many great speakers at this event including Grant Fritchey, Itzik Ben-Gan, Denny Cherry and many more. The conference includes more than one technology.

Here is a Promo Code LSPK49 for a savings of $600 off the standard price of $2,250 for the 5-day all-access package!

SessionTracks

The cost of the event includes access to all sessions from all tracks. I would really like to spend some time in the Cloud & Data Center as well as Enterprise Collaboration. The first day (Monday) is for full day workshops in all tracks.

Registration

I will be speaking on Tuesday at 11AM and Wednesday at 1:15PM. The sessions are Attributes and Hierarchies in SSAS 2014 and Excel 2013 Tips and Ticks for Displaying a Multidimensional Cube. These are topics that I really have a passion to work on. Analysis Services is a great tool for aggregating data and being able to get Dimension columns into Hierarchies and Members. With Excel, you can directly report against a cube and get lots of insights.

ThomasSessions

There is also a SQLSaturday on the weekend before this conference, so if you are in Las Vegas, you will probably get to see some if these same speakers on Saturday (for free).

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, 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, 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

Sunday, March 29, 2015

PASS Excel BI VC presents Devin Knight on Getting Started on PowerQuery

Come join us Thursday April 2nd for an Excel BI virtual chapter session at noon central with Pragmatic Work’s Devin Knight who will help us get started with PowerQuery.

Thu, Apr 02 2015 12:00 Central Daylight Time


Getting Started with Power Query by Devin Knight

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

GETTING STARTED WITH POWER QUERY

Power Query is a free add-in for Excel 2010 or 2013 that provides users an easy way to discover, combine and refine data all within the familiar Excel interface. With Power Query you can now combine and transform data from a variety of data sources all within Excel, which would have previously required a complex ETL tool. Join Devin and learn how you can use Power Query to take your Self-Service BI solutions to the next level. You will also see quick ways to visualize this new data appropriately. BIO Devin a Microsoft SQL Server MVP and the Training Director at Pragmatic Works Consulting. He is an author of six SQL Server books and speaks at conferences like PASS Summit, PASS Business Analytics Conference, SQL Saturdays and Code Camps. He is also a contributing member to the PASS Business Intelligence Virtual Chapter. Making his home in Jacksonville, FL, Devin is the President of the local users’ group (JSSUG).


Devin Knight a Microsoft MVP and the Training Director at Pragmatic Works Consulting. He is an author of six SQL Server books and speaks at conferences like PASS Summit, PASS Business Analytics Conference, SQL Saturdays and Code Camps. He is also a contributing member to the PASS Business Intelligence Virtual Chapter. Making his home in Jacksonville, FL, Devin is the Vice President of the local users group (JSSUG).

Tuesday, January 20, 2015

SQLSaturday #362 – Austin, TX – Let’s Get Weird

I used to spend the 4th of July weekend (or week) in Austin with some buddy’s when we were in our 20s. There was so much to do and enjoy while there it is exciting to go back to this great city. Not only that, but there are some really good SQL Server experts and community organizers in that city – John Sterrett, Jim Murphy, SQLServerIO (Wes Brown – hope he is there), AJ Mendo and more. Catching up with these people will be refreshing.

The event is on Jan31st at Wingate by Wyndham Round Rock Hotel and Conference Center 1209 N IH 35, Round Rock, TX 78664

 

THIS YEAR THERE ARE 2 OFFICIAL SQL SATURDAY PRECON'S ON FRIDAY JANUARY 30th, 2015. TICKETS WILL SELL OUT QUICKLY SO MAKE SURE YOU REGISTER TO SPEND THE DAY WITH SOME OF SQL SERVER'S GREATS!

BECOME AN ENTERPRISE DBA WITH SEAN AND JEN MCCOWN     Eventbrite - Become an Enterprise DBA with Sean and Jen McCown

MURDER THEY WROTE WITH JASON BRIMHALL AND WAYNE SHEFFIELD   Eventbrite - Murder They Wrote

Register

 

Here is the emailed schedule:

Track

Starts

Session Title

Speaker

Business Intelligence

08:30 AM

Registrations

SQLSaturday 362

Business Intelligence

09:00 AM

Capture Change and Apply it with CDC & SSIS

Steve Wake

Business Intelligence

10:15 AM

Getting started with Tabular Analysis Services

Thomas LeBlanc

Business Intelligence

11:30 AM

15 Quick Tips for SSIS Performance

Tim Mitchell

Business Intelligence

12:30 PM

Learn How To Build A Golden Record for Any Subject Over Lunch!

Gene Webb

Business Intelligence

02:15 PM

Writing Your First BimlScript

David Stein

Business Intelligence

03:30 PM

Change Data Capture & Change Tracking Deep Dive

Kevin Hazzard

Business Intelligence

04:00 PM

XML & SQL: Best Frenemies Forever

Richard Heim

Business Intelligence

05:15 PM

Raffle

SQLSaturday 362

DBA, Automation

09:00 AM

DBA Toolbox: Surviving A Disaster

AJ Mendo

DBA, Automation

10:15 AM

SQL Server: Monitoring disk usage

Daniel Janik

DBA, Automation

11:30 AM

Beginning Automation with Powershell

Amy Herold

DBA, Automation

12:30 PM

Embarcadero - Lunch Sponsorship Session

John Sterrett

DBA, Automation

02:15 PM

Database Release Management: Tips to help organize it

TJay Belt

DBA, Automation

03:30 PM

SQL Server Internals

Naomi Williams

DBA, Automation

04:00 PM

SQL Server Bingo – Install, Migration & Config

Mindy Curnutt

DBA, Automation

05:15 PM

Raffle

SQLSaturday 362

DBA, Cloud

09:00 AM

SQL Server Foreign Keys – De-mystifying the Rest of the Story

Mike Byrd

DBA, Cloud

10:15 AM

Getting Started with SQL Server in the Cloud with Microsoft Azure

Anil Mahadev

DBA, Cloud

11:30 AM

SQL 2012 Extended Events

Jason Brimhall

DBA, Cloud

12:30 PM

Amazon Web Service - Lunch Sponsorship Session

John Sterrett

DBA, Cloud

02:15 PM

No DR Site?! No problem!! Enhance your SQL Server HA/DR capabilities using Windows Azure

Kal Yella

DBA, Cloud

03:30 PM

SQL Server Statistics – What Are The Chances?

Lori Edwards

DBA, Cloud

04:00 PM

Introduction to Wait Types and Response Time Analysis

Janis Griffin

DBA, Cloud

05:15 PM

Raffle

SQLSaturday 362

DBA, Security

09:00 AM

Turbocharge Your Career With a Learning Plan

Andy W

DBA, Security

10:15 AM

CIS Benchmarks – A Guide to SQL Server Security

Nancy Hidy Wilson

DBA, Security

11:30 AM

SQL Watchdog - find out instantly when SQL change

Michael Bourgon

DBA, Security

12:30 PM

Cisco - Lunch Sponsorship Session

John Sterrett

DBA, Security

02:15 PM

SQL Security Best Practices & Shrinking Your Attack Surface

Matthew Brimer

DBA, Security

03:30 PM

SQL Injection

Kevin Boles

DBA, Security

04:00 PM

Securing Your SQL Environment

Tim Radney

DBA, Security

05:15 PM

Raffle

SQLSaturday 362

Development

08:30 AM

Registrations

SQLSaturday 362

Development

09:00 AM

Parameter Sniffing the Good and the Bad

Lance Tidwell

Development

10:15 AM

5 TSQL Commands I've Been Missing

Jason Carter

Development

11:30 AM

The Real Value of Name-Value Pairs: Using PIVOT and UNPIVOT

Kevin Wilkie

Development

12:30 PM

Women in Technology Round Table Discussion

Rie Irish

Development

02:15 PM

Windowing Functions

Timothy Costello

Development

03:30 PM

Turbo Boost Performance: In Memory Tables index optimizations

Konstantin Melamud

Development

04:00 PM

T-SQL Throwdown

Hakim Ali

Development

05:15 PM

Raffle

SQLSaturday 362

Thunderdome

09:00 AM

Introduction to Powershell cmdlets for DBAs

Jennifer McCown

Thunderdome

10:15 AM

Query Store - A New SQL Query Tuning Feature

Conor Cunningham

Thunderdome

11:30 AM

Increase your SSIS productivity with Biml

Reeves Smith

Thunderdome

12:30 PM

Microsoft - Sponsor Lunch Session

John Sterrett

Thunderdome

02:15 PM

SQL Server 2014 In Memory technologies - In Memory OLTP (aka Hekaton) & ColumnStore

Reinaldo Kibel

Thunderdome

03:30 PM

Table Vars & Temp Tables - What you NEED to Know!

Wayne Sheffield

Thunderdome

04:00 PM

AlwaysOn Live Deployment

Ryan Adams

Thunderdome

05:15 PM

Raffle

SQLSaturday 362

Thursday, December 18, 2014

PASS – Connect, Share and Learn

The Professional Association of SQL Server (PASS) has a slogan for what they do – CONNECT, SHARE and LEARN. So, what does this mean to me and the SQL Server professionals I have meet in this community (#SQLFamily)?

 

image

First, I connected. Where did that start? SQLServerCentral.Com (SSC). I started reading articles on this site over a decade ago, and made it the main SQL Server resource for me beginning a DBA career. Back then a DBA was someone who either did one of 3 task types (or any combination).

  • DBA Administrator – worked to keep a system up and running including Windows Admin(Clustering), SAN usage, Security and Permissions (ActiveDirectory) and Performance Tuning (Monitor System resources).
  • DBA Developer – wrote T-SQL for stored procedures, triggers and jobs as well as create databases, tables and indexes usually because you were also a developer of software
  • DBA Business Intelligence – ETL with DTS (now SSIS), cubes in SSAS (multidimensional) and reports in SSRS (it was Crystal Report writer for me because SSRS was not released and packaged with Visual Basic) in addition to creating databases, tables and indexes.

Reading articles helped me develop a talent in the administrator position I was in along with getting a MCDBA in SQL Server 2000 (now I have MCITP in 2005 & 2008). The CONNECT part came when I ask my boss if I could go to the PASS Summit in Denver (2007). He had the funds in our department’s budget and included himself in the trip. There, I watched sessions based on the titles and abstracts. I did not know many speaker names except those I saw write articles on SSC. Those main ones I recognized were the ones who answered lots of questions posted on SSC forums as well as Microsoft message boards.

The next year, I was able to attend the Summit in Seattle and this is where I really started to CONNECT. Before that year’s Summit, I watched Patrick LeBlanc start the Baton Rouge SQL Server User Group. Patrick was able to use the resources from PASS to get it started and the networking with local IT professionals started this CONNECT for me. The group was created after the .Net User Group was started in Baton Rouge.

The second Summit I attended got me started wondering about the SHARE aspect. 2 or 3 sessions I attended got me thinking “I can do that”. Now, it was not magic and I was presenting. The first presentations I start doing were every other week Lunch and Learns at work regarding upgrading SQL Server from 2000 to 2005. The first presentation outside of work was for the local SQL Server User Group about SQL Server monitoring with Performance Dashboards. It went well, and I received very candid feedback from employees I worked with. I have learned today that feedback (good and bad) helps me improve the presentations over time.

Getting involved with PASS, I have helped the local user group with presentations, volunteering for 4 SQLSaturday events and promoting SQLPass.org locally. The Data Architecture Virtual Chapter needed help and I became the Chairperson for 2 years and have been able to encourage another DBA to assume the role after I retired which led into a VC mentor role.

The last item is LEARN. Well, if you have read this far, you should already know that all of the things above have helped me LEARN SQL Server - connecting to get the right people to go to with questions and sharing which enhances my skills. They are all learning opportunities which help advance my career and skill set.