Group Announcements


October '17 BRSSUG Meeting

posted Oct 4, 2017, 4:06 PM by william assaf   [ updated Oct 9, 2017, 9:38 AM ]

IMPORTANT ANNOUNCEMENT!  Thinking of registering for the PASS Summit in October? Use this code for a $150 discount!  LC15BGL5


NEXT MEETING Date: Wednesday, October 11, 2017

Location: The Louisiana Technology Park - http://www.brssug.org/where

 

Sponsor: TBA

All of our meetings are open to the public, open to students, folks looking to get into the field and those looking to move up! Please spread the word and come prepared to learn and share your knowledge and experience!

Agenda:

5:45 - 6:15 pm: Networking and Dinner with the other user groups

6:15 - 6:30 pm: Announcements, Sponsor Message, and Lightning Talks

6:30 - 7:00 pm: User Group business/Lightning Rounds

7:00 - 8:00 pm: Speakers

8:00 - 8:30 pm: Raffle and Giveaways

This will be a joint meeting with the Baton Rouge Power BI User Group (BRPBIUG)


 Please also visit our Meetup.com site and RSVP!


Lightning Round Presenter: John Wells, Lamar Advertising 
Topic: Implicit Conversions "Performance Killer"
Summary: Implicit conversions are a performance killer that you may not 
even realize you have. The good news is they are easily corrected.
In this quick presentation, we will go over why they happen and 
and how to prevent them.
Bio: Originally from Southern California, I relocated to the state I grew up visiting and enjoy the easier life here.I'm a DBA at Lamar Advertising for the last 10 months after 2 years with an advertising company in Shreveport.Relocating to Louisiana 3 years ago was for a new beginning and something different. I enjoy everything database and some call me "Mr. SQL Saturday".


Main Presenters: Chrissy LeMaire, NATO and Constantine Kokkinos, Consultant
Topic: "Introduction to DBATools, from the original author of the dbatools module"
Detail: TBA

Bio:
Chrissy LeMaire is a Windows PowerShell MVP and PASS PowerShell Virtual Group co-lead who has worked in IT for over 20 years. Originally from Kaplan, LA [or Lafayette if nobody will know Kaplan], she now works for General Dynamics and serves as the SQL Server DBA at NATO Special Ops HQ in Belgium.

Bio:
Constantine Kokkinos is a technophile, DBA, and all around nice guy. He spends the bulk of his time either performance tuning databases or using PowerShell to automate anything he can. A lifelong love of tech led him to creating a short lived social network startup which kicked off his software career. He moved on to become a Certified Apple Trainer, and is now a self-employed SQL Server consultant.

September '17 BRSSUG Meeting

posted Sep 6, 2017, 11:47 AM by Adrian Aucoin Jr   [ updated Sep 14, 2017, 11:27 AM by william assaf ]

Our next meeting will be September 13 2017 at the Louisiana Technology Park.

 

IMPORTANT ANNOUNCEMENT!  Thinking of registering for the PASS Summit in October? Use this code for a $150 discount!  LC15BGL5

Date: Wednesday, September 13, 2017

Location: The Louisiana Technology Park - http://www.brssug.org/where

 

Sponsor: TBA

 

Agenda:

5:45 - 6:15 pm: Networking and Dinner with the other user groups

6:15 - 6:30 pm: Announcements, Sponsor Message, and Lightning Talks

6:30 - 7:00 pm: User Group business/Lightning Rounds

7:00 - 8:00 pm: Speakers

8:00 - 8:30 pm: Raffle and Giveaways

This will be a joint meeting with the Baton Rouge Power BI User Group (BRPBIUG)


 Please also visit our Meetup.com site and RSVP!

 

Topic: Twilight TimeZone: Handling Time in Your App Architecture

Detail: Join two experts in their fields of SQL and .NET architecture for an informative and thought-provoking talk about handling timezones in your 
application architecture. You might walk away unsettled by your past date/time storage choices, but you'll be more confident than ever that dealing with
Time Zones is disconcerting, rarely straightforward, and often complicated! We'll deep dive into the storage and serialization of date/time information from
the worlds of both SQL Server and web/mobile application development, in a joint presentation by Sparkhound principal consultants William Assaf and Steve Schaneville.

Bios:  William Assaf of Sparkhound

William Assaf, MCSE, is a principal consultant and DBA Manager at Sparkhound in Baton Rouge, LA. He started off as a .NET developer out of college and
moved into database administration and architecture, and has been lead db designer on major application and data warehousing projects for private and
public clients. A SQL Server consultant since 2007, he blogs about SQL at sqltact.com. William is a past president of the Baton Rouge SQL UG and head of the
annual SQLSaturday Baton Rouge Planning Committee.


Bios:  Steve Schaneville of Sparkhound

Steve has 17 years of experience delivering enterprise grade solutions using Microsoft technologies.  He served as lead architect at Amedisys for nearly 8 years, 
and has recently transitioned into consulting at Sparkhound (and I'm really liking it! :-). In recent years he's become a strong advocate for unit testing and
he *actually believes* that writing unit tests saves time rather than consumes it.

All of our meetings are open to the public, open to students, folks looking to get into the field and those looking to move up! Please spread the word and come prepared to learn and share your knowledge and experience!

SQLSaturday Baton Rouge 2017 was a Success!

posted Jul 31, 2017, 6:08 PM by william assaf   [ updated Aug 16, 2017, 6:10 PM ]

Thanks to everyone who attended, donated, spoke, volunteered, cleaned up and helped out in any way!

If you attended, please take our post-event survey here:


View our photo album here! https://goo.gl/photos/cTnsBxA5jHWvPrCAA 
Big thanks to our photographer, Ronald Msiska!


SQLSaturday Baton Rouge 2017!

posted Jul 24, 2017, 5:48 PM by william assaf   [ updated Jul 25, 2017, 9:37 AM ]

Free training day for SQL Server, PowerBI, .NET and more 

SQLSaturday is a global event to bring Information Technology speakers and professionals together for a community-driven, community-attended free day of technical training. The Baton Rouge SQLSaturday event is sponsored by the Baton Rouge SQL Server and .NET User Groups, and will be our annual event on campus at LSU. We expect 600+ regional IT professionals and national speakers to join us. This free conference is open to the public and is perfect for students, CIO's, database administrators, developers, IT managers, server admins and job-seekers. 


Then...


What

An all day FREE training event with SQL Server, Development and SharePoint related sessions spread out over multiple tracks of Business Intelligence, Database Administration, SQL Development, SharePoint, IT Pro and .NET development. 

When:

Saturday, July 29 2017. Online registration is now open, but it is filling up fast so reserve your spot now. Attendee check-in will begin at 8:00 AM first sessions beginning at 9:15 AM. 

You MUST print your SpeedPASS and bring it with you! We will NOT be providing blank raffle tickets this year. If you do not print and bring your SpeedPASS, you will not be able to register for the Raffle!

You can login and download your SpeedPASS PDF here at the mySQLSaturday page without waiting for an email: https://www.pass.org/MYPASS/tabid/9795/ctl/MySQLSaturday/mid/14602/Default.aspx


Registering for the PASS Summit in October? Use our user group code for a $150 discount!  LC15BGL5

Baton Rouge User Groups Networking Night 2017

posted Jun 19, 2017, 7:53 AM by william assaf   [ updated Jun 19, 2017, 6:44 PM ]

What is Networking Night?

Many professional organizations have an annual meeting dedicated to career development and professional networking. 
Networking Night is a special User Group format where we will have several short-format talks, networking and career development, and an opportunity for Baton Rouge SQL Saturday sponsors to have an official presence to do recruiting, evangelism, etc.  

Sign up to speak at the event here!  

Who should attend? Everyone should attend free Networking Night! In 2014 and 2015 and 2016, 80+ IT professionals including many newcomers attended this fun event! 
  • Looking for a job? Meet and greet, bring your resume
  • Hiring? Introduce yourself to folks in your needed the field 
  • Current Student? Talk to your future colleagues and managers
  • Happy at your job? Share your experience and contribute to discussion
Instead of a regular user group meeting, Networking Night is open to everyone in the Baton Rouge IT community, for free! 

Date: Wednesday, July 12, 2017
Location: The Louisiana Technology Park - http://www.brssug.org/where

Agenda:
5:45 - 6:15 pm: Networking and Dinner
6:15 - 6:30 pm: Announcements
6:45 - 8:00 pm: Networking Nights Speakers
8:00 - 8:30 pm: Raffle and Giveaways

Please register for SQLSaturday Baton Rouge today! http://sqlsaturday.com/628/EventHome.aspx


June '17 BRSSUG Meeting

posted Jun 12, 2017, 3:33 PM by william assaf   [ updated Jun 12, 2017, 3:39 PM ]

Our next meeting will be June 14 2017 at the Louisiana Technology Park.

 

IMPORTANT ANNOUNCEMENT!  Thinking of registering for the PASS Summit in October? Use this code for a $150 discount!  LC15BGL5

Date: Wednesday, June 14, 2017

Location: The Louisiana Technology Park - http://www.brssug.org/where

 

SponsorREDGATE - we will giveaway a prize license for SQL Toolbelt

Redgate is excited to have just launched v1 of SQL Clone, our database provisioning tool that removes much of the time and disk space needed to create multiple database copies. Here’s the link to the video..

 

Agenda:

5:45 - 6:15 pm: Networking and Dinner with the other user groups

6:15 - 6:30 pm: Announcements, Sponsor Message, and Lightning Talks

6:30 - 7:00 pm: User Group business/Lightning Rounds

7:00 - 8:00 pm: Speakers

8:00 - 8:30 pm: Raffle and Giveaways

This will be a joint meeting with the Baton Rouge Power BI User Group (BRPBIUG)


 Please also visit our Meetup.com site and RSVP!

 

Extending DevOps to SQL Server 

Most organizations are under pressure to speed up the software delivery cycle, whether that’s to respond more quickly to the needs of the business, the needs of your customers or just to keep up with the competition.  Unfortunately the database is commonly considered a bottleneck.  Without the right processes in place, database change management can slow things down, adding risk, uncertainty, and getting in the way of development and operations working together to deliver.  Any organization that wants to fully benefit from a DevOps approach is going to have to overcome some specific challenges presented by the database. This session will teach you how to take DevOps principles and practices and apply them to SQL Server so that you can speed up the database delivery cycle at the same time you protect the information contained within. 

Speaker: Grant Fritchey

Grant Fritchey is a Data Platform MVP with over 20 years’ experience in IT, including time spent in support and development. He has worked with SQL Server since 6.0 back in 1995. He has also developed in VB, VB.NET, C#, and Java. Grant has written books for Apress and Simple-Talk. Grant presents at conferences and user groups, large and small, all over the world. He joined Redgate Software as a product evangelist in January 2011. 

Lightning Round

dbatools - The PowerShell module that will make your life easier! 

The dbatools project is becoming more popular by the day and everyone in the industry is talking about it.This free PowerShell tool can be downloaded in less than 30 seconds and immediately gives you the power tosimplify some of your daily tasks. Don't have any PowerShell experience? Don't worry because you don't need it!I will be showing some simple demonstrations on how easy your daily routine can be. 

Speaker: John Wells

Originally from Southern California, I relocated to the state I grew up visiting and enjoy the easier life here.I'm a DBA at Lamar Advertising for the last 10 months after 2 years with an advertising company in Shreveport.Relocating to Louisiana 3 years ago was for a new beginning and something different. I enjoy everything database and some call me "Mr. SQL Saturday".


All of our meetings are open to the public, open to students, folks looking to get into the field and those looking to move up! Please spread the word and come prepared to learn and share your knowledge and experience!

May '17 BRSSUG Meeting

posted May 3, 2017, 8:58 AM by BRSSUG SQLPass BatonRouge   [ updated Jun 12, 2017, 3:33 PM by william assaf ]

Our next meeting will be May 10, 2017 at the Louisiana Technology Park.

 

IMPORTANT ANNOUNCEMENT!  Thinking of registering for the PASS Summit in October? Use this code for a $150 discount!  LC15BGL5

Date: Wednesday, May 10, 2017

Location: The Louisiana Technology Park - http://www.brssug.org/where

 

Sponsor: TBA

 

Agenda:

5:45 - 6:15 pm: Networking and Dinner with the other user groups

6:15 - 6:30 pm: Announcements, Sponsor Message, and Lightning Talks

6:30 - 7:00 pm: User Group business/Lightning Rounds

7:00 - 8:00 pm: Speakers

8:00 - 8:30 pm: Raffle and Giveaways

This will be a joint meeting with the Baton Rouge Power BI User Group (BRPBIUG)


 Please also visit our Meetup.com site and RSVP!

 

Main Topic: Introduction to Microsoft Analytics – Turning Data into Intelligent Action

Abstract: Data Science, Azure Machine Learning, and Analytics are all becoming core pieces to the success of every business.  As data professionals we need to know how these will affect what we do, and how we can use it to help our business and clients.  In this session we will take a look at these hot topics and learn how it helps us turn data into intelligence that will lead to actions that drive profits.  We will take a look at how Microsoft’s Cortana suite is the central hub for learning and implementing each of these core pieces.  An easy to follow example showing the flow from Data to Data Intelligence and thru to Action will be presented using Cortana Intelligence Suite.

 

Speaker: Melody Zacharias, Clearsight Solutions

Bio: Melody Zacharias is a Partner at ClearSight Solutions in British Columbia Canada. She is the leader of the Southern Interior Pass (SIP) chapter for the Professional Association of SQL Server (PASS), Regional Mentor for Pass Canada and a Microsoft MVP for the data platform.   Melody has been passionate about SQL Server since version 7.  You can find her on her blog at sqlmelody.blogspot.ca or on Twitter @SQLMelody.


All of our meetings are open to the public, open to students, folks looking to get into the field and those looking to move up! Please spread the word and come prepared to learn and share your knowledge and experience!


April '17 Baton Rouge SQL Server User Group

posted Mar 29, 2017, 7:14 AM by william assaf   [ updated Mar 31, 2017, 7:51 AM by BRSSUG SQLPass BatonRouge ]

Our next meeting will be April 12, 2017 at the Louisiana Technology Park.


The meeting will begin around 6pm, sponsored by Idera


Please also visit our Meetup.com site and RSVP!


Lightning Round Topic: TRY…CATCH Error Handling in SQL Server 

Abstract: : TRY…CATCH was introduced in SQL 2005 as the standard for error handling in SQL Server. This presentation will review the benefits of using proactive error handling to address both anticipated and unanticipated errors during code execution, along with the ways to utilize TRY…CATCH in standard queries and stored procedures.  

Speaker: Colby Loupe, Sparkhound

Bio: Colby is a Junior Consultant for Sparkhound’s SQL Server division with experience with administration, data integration, and report development. After working as a report writer for her local government, Colby moved to Baton Rouge to pursue a career in Database Administration at Sparkhound. 



Main Topic: You Want Me to Isolate What?

 

Abstract: Isolation Levels in SQL Server can benefit your application and help control data integrity by managing concurrency effects but can also hurt your application if you are unaware of what they are and how they are used. A review of SQL Concurrency issues and how SQL Isolation Levels can help eliminate them and keep the integrity of your data. This presentation will demonstrate with queries what causes concurrency issues and what isolation levels will prevent them.


Speaker: Robert Bishop, Sparkhound


Bio: Robert has been working with databases since SQL Server 2005.  After 4 years as a .NET developer using SQL Server, Robert became a DBA out of necessity, a true "Accidental" DBA!  After 5 years as a DBA for a local hospital, Robert decided to expand his career by becoming a Senior SQL Server Consultant for Sparkhound. Robert has presented at his local SQL Server User group, SQL Saturdays and PASS Virtual Chapters.  As a Microsoft MSCA and an Idera ACE, Robert enjoys administrative tasks, configuring SQL Server for optimal performance, troubleshooting problematic SQL queries and making those query run faster than the speed of light.  In the event of "free time", Robert enjoys camping, playing his guitars and spending time with his family.

 


All of our meetings are open to the public, open to students, folks looking to get into the field and those looking to move up! Please spread the word and come prepared to learn and share your knowledge and experience!




March '17 Baton Rouge SQL Server User Group

posted Mar 1, 2017, 7:11 PM by BRSSUG SQLPass BatonRouge

Our next meeting will be March 8, 2017 at the Louisiana Technology Park.


The meeting will begin around 6pm, sponsor TBD!

Main Topic: Azure SQL Database for the Production DBA 

Summary: Have you been wondering what Azure SQL Database is and what it means for you as a production DBA? Azure SQL Database has become an Enterprise-worthy database platform that provides relational database-as-a-service. In this session you’ll get a grounding in the fundamentals of Azure SQL Database from a DBA perspective. First we’ll cover how to create an Azure SQL Database using the Azure Portal and an approach for sizing a new Azure SQL Database. Then we’ll cover some of the similarities and differences between on premises SQL Server and Azure SQL Database. Finally, we will cover how monitoring and performance tuning Azure SQL Database differs from on premises SQL Server. If you’ve been considering Azure SQL Database for your organization, this session is for you!

Speakers: Tim Radney

Bio: Tim works as a principal consultant at SQLskills.com.  Tim is a SQL Server MVP. and has presented at PASS, SQLintersection, SQL Saturdays, user groups and numerous webinars. In addition Tim runs the Columbus GA SQL Users Group, is a PASS Regional Mentor and was named a PASS Outstanding Volunteer in 2012. He’s married with three children and has a passion for electronics. He also farms chickens (for eggs), dwarf Nigerian goats, and tilapias in his spare time.


All of our meetings are open to the public, open to students, folks looking to get into the field and those looking to move up! Please spread the word and come prepared to learn and share your knowledge and experience!

February '17 Baton Rouge SQL Server User Group

posted Feb 6, 2017, 6:00 PM by BRSSUG SQLPass BatonRouge   [ updated Feb 8, 2017, 1:17 PM by william assaf ]

Our next meeting will be February 8, 2017 at the Louisiana Technology Park.


The meeting will begin around 6pm, sponsored by Prime Occupational Medicine!

 Lightning Topic: Reporting Methods in PowerBI

Speakers: Andy Parkerson

Summary: Andy recently finished writing a comprehensive wiki explaining his business' reporting methods with PowerBI, in this lightning round he'll share some of that information and how they leverage the PowerBI cloud as a “Single Point of Truth”.

 

Main Topic: Fun with Dates and Time In SQL 

Speakers: William Assaf

Summary: William will be presenting some new material he's building a presentation around.  As always it'll  probably be amazing so come out, be surprised and enjoy his engaging presentation style.


All of our meetings are open to the public, open to students, folks looking to get into the field and those looking to move up! Please spread the word and come prepared to learn and share your knowledge and experience!

1-10 of 93