Blog

Mar 27
4-13-17: Azure SQL Database: 12 Things To Know, with Sven Aelterman

Topic for the April 2017 Meeting: 

Azure SQL Database: 12 Things To Know

Abstract:  Up and running with Azure SQL Database already? This session will provide a grab bag of 12 how-to items you'll need to know to successfully keep your database running. Among those, we'll cover PowerShell for Azure SQL DB, geo-replica and other disaster recovery features and monitoring. As Azure SQL DB rapidly gains capabilities, rest assured that this session covers the latest!.

 

Register Now (It's Free!)

 

Sven Aelterman is the Director of IT for the Sorrell College of Business at Troy University; a role with a global scope. He manages IT staff and all technology aspects of the College and ensures alignment with the College’s strategic initiatives. He is also a lecturer in Information Systems and has taught courses in data warehousing and information security.


In addition, he is founder and principal consultant at Adduxis, where he assists customers in areas of SQL Server/.NET, high availability/disaster recovery and Azure. Sven focuses on application design and architecture and secure coding practices. In 2012, he co-authored “The Art of SQL Server FILESTREAM,” published by Red Gate Books.

In 2015, he started work with customers of Sorrell Solutions, L.L.C. (a business services firm owned by the Troy University Foundation) as Cloud Software Architect. The current project is design and development of a specialized EHR for school-located vaccination clinic providers.

He received an MBA from Troy University and bachelor’s degree from the Hogeschool Gent (University College Ghent) in Belgium, his native country.

Sven is married to Ebony and they have a son, Edward, and a daughter, Sofia. They live in Troy, Alabama. .

Sven will be presenting remotely via WebEx; this session will also be recorded and posted to the AlaskaSQL YouTube Channel.

Register Now (It's Free!)

WebEx Info:

When
Where
       This meeting is online-only until we find a venue.
Mar 11
5-11-17: Unstructured Data Analysis Using Microsoft Cognitive Services

Topic for the May 2017 Meeting: 

Unstructured Data Analysis Using Microsoft Cognitive Services

Abstract:  The session covers how to use unstrucutred data, and cognitive services to drive insights and intelligence in your applications. The session covers how to work with unstructured text and turn unstructured text into meaningful insights into mobile, web and line of business applications.

The session will be showing how to use a few lines of code to easily analyze sentiment, extract key phrases, detect topics, and detect language for any kind of text.

The session will provide an overview on Microsoft Cognitive Services and all related text analysis services including:

  • Sentiment Analysis
  • Key Phrase extraction
  • Topic Detection
  • Language detection

The session is code driven & will provide samples on how to build smart apps with cognitive services from Microsoft.

Target Audience: Level 100 - Software Engineers and Data Enthusiasts 

 

Register Now (It's Free!)

About Adnan Masood, Ph.D.
Chief Architect of AI and Machine Learning, UST Global  

Adnan-Masood.jpgAdnan Masood, Ph.D. is a software architect, machine learning researcher, and Microsoft MVP for Data Platform. Before joining UST Global as Chief Architect of AI and Machine Learning, Dr. Masood worked at Green Dot Corporation, a leading prepaid financial technology institution as a Sr. Systems Architect. In the past life he has also served as principal engineer for an ecommerce start-up, and as a solutions architect for UK's leading nonprofit organization.

A strong believer in the development community, Adnan is an active member of the Open Web Application Security Project (OWASP), an organization dedicated to software security. In the .NET community, he is a cofounder and president of the Pasadena .NET Developers group, co-organizer of Tampa Bay Data Science Group, and Irvine Programmer meetup. A certified ScrumMaster, Dr. Masood also hold certifications in big data, machine learning, and systems architecture from Massachusetts Institute of Technology; Application Security certification from Stanford University, and SOA Smarts certification from Carnegie Mellon University. he is a Microsoft Certified Solutions Developer, and Sun Certified Java Developer.

Author of "Functional Programming with F#", Dr. Masood teaches Data Science course at Park University, and has taught Windows Communication Foundation (WCF) courses at the University of California, San Diego. He is a regular speaker to various academic and technology conferences (, IEEE-HST, IASA, and DevConnections), local code camps, and user groups. He is also a volunteer STEM FLL robotics coach for middle school students.

For more details, visit Adnan's blog (http://blog.adnanmasood.com), GitHub repository (http://github.com/adnanmasood), and Twitter (@adnanmasood). Adnan can be reached at adnan.masood@owasp.org.

Adnan will be presenting remotely via WebEx; this session will also be recorded and posted to the AlaskaSQL YouTube Channel.

Register Now (It's Free!)

WebEx Info:

When
Where
       This meeting is online-only until we find a venue.
Feb 09
3-9-17: Dr. DMV's Troubleshooting Toolkit

Topic for the March 2017 Meeting: 

Dr. DMV's Troubleshooting Toolkit, with Glenn Berry

Dynamic Management Views and functions allow you to easily see exactly what is happening inside your SQL Server instances and databases with a high level of detail. You can discover your top wait types, most CPU intensive stored procedures, find missing indexes, and identify unused indexes, to name just a few examples. This session presents, demonstrates and explains a complete set of diagnostic DMV queries that you can easily use to detect and diagnose configuration and performance issues in your SQL Server instances and databases.  This session goes into exhaustive detail on how to interpret the results of each of the diagnostic queries, including relevant background information on how to properly configure your hardware, storage subsystem, operating system, SQL Server instance and databases in order to avoid performance and scalability issues.  

This event has ended. Watch now on YouTube!

Glenn Berry, Microsoft SQL MVP

Principal Consultant, SQLSkills.com

GlennBerry2.jpgGlenn is a Microsoft SQL Server MVP. He has worked as a SQL Server professional for many years in a variety of roles, including stints with NewsGator and Avalara. His expertise includes DMVs, high availability, hardware selection and configuration, and performance tuning. He is also an Adjunct Faculty member at University College – University of Denver, where has been teaching since 2000. Glenn is heavily involved in the SQL Server community, and is a frequent speaker at user groups, SQL Saturdays, SQLintersection, and the PASS Community Summit. He is the author of the book SQL Server Hardware, and he wrote chapters for SQL Server MVP Deep Dives and SQL Server MVP Deep Dives Volume 2 books.

Email: Glenn@SQLskills.com 
Website: http://www.SQLskills.com

Full Bio: http://www.sqlskills.com/about/glenn-berry/
Blog: http://www.SQLskills.com/blogs/Glenn 
Twitter: http://twitter.com/GlennAlanBerry 
Microsoft MVP since 2007

.

Glenn will be presenting remotely via WebEx; this session will also be recorded and posted to the AlaskaSQL YouTube Channel.

This event has ended. Watch now on YouTube!

Glenn's scripts can be found on his blog, here: http://www.SQLskills.com/blogs/Glenn

 

Feb 09
2-9-17: Azure SQL Database for the Production DBA

Topic for the February 2017 Meeting: 

Azure SQL Database for the Production DBA, with Tim Radney

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!
  

This event has ended.  Check back soon for an on-demand video and

About Tim Radney, SQL Server MVP 

Tim is a SQL Server MVP. He 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.

Tim will be presenting remotely via WebEx; this session will also be recorded and posted to the AlaskaSQL YouTube Channel.

This event has ended.  Check back soon for an on-demand video!

Download Tim's slides 

Watch now on YouTube!

 
Jun 08
AlaskaSQL is going on Hiatus in July 2016

​Hi All, 

Greg Burns here.  After the meeting on 6/23/16, we are going to take a break for a while.  The reason is that I am moving to Washington state in July.  My mother is ill, and I'd like to be close to her.  My employer is being cool about it, so I will be relocating to the Seattle office near the beginning of July.

No, this doesn't mean the end of AlaskaSQL; I'm perfectly capable of running the group from there (and I'll hopefully be traveling back and forth to Alaska whenever needed).  I'll continue to help organize; I can record meetings and post to YouTube, write blog posts, give help to whoever asks, and help people get in touch with each other.  

But it does mean we might be transitioning to a virtual group, unless someone else is interested in hosting meetings.  We will get it figured out, one way or another, within a few months.  In the meantime, enjoy the summer!

Make no mistake, my passion is still with the Alaska SQL Server community.  There are over 75 AlaskaSQL members from all walks of life, from casual users to admins and developers.  And we will continue to bring you news, learning, support, and community events for as long as I have anything to say about it.  

Thanks, 

Greg Burns, alaskasql@gmail.com

Chapter Leader, Alaska SQL User Group

Jun 08
6-23-16: A Database Designer's Favorite Features in 2016, with Karen Lopez

Topic for the June 2016 Meeting: 

A Database Designer's Favorite Features in 2016, with Karen Lopez

The launch of SQL Server 2016 means will be a lot of blog posts and Webinars of people talking about all the great features that come with this new release. But in our webinar Karen Lopez will be sharing the best features from a database designers point of view -- from Always Encrypted to Zombie Datatypes.  

Register Now (It's Free!)

About Karen Lopez, SQL Server MVP
Sr. Project Manager / Architect, InfoAdvisors 

Karen LopezKaren has 20+ years of experience in project and data management on large, multi-project programs. Karen specializes in the practical application of data management principles. She is a frequent speaker, blogger and panelist on data quality, data governance, logical and physical modeling, data compliance, development methodologies and social issues in computing. Karen is an active user on social media and has been named one of the top 3 technology influencers by IBM Canada and one of the top 17 women in information management by Information Management Magazine. She is a Microsoft SQL Server MVP, specializing in data modeling and database design. She’s an advisor to the DAMA, International Board and a member of the Advisory Board of Zachman, International.

Karen will be presenting remotely via WebEx; this session will also be recorded and posted to the AlaskaSQL YouTube Channel.

Register Now (It's Free!)

WebEx Info:

When
Where
GCI / NBS Conference Room - 3000 A Street Suite 210, Anchorage, AK 99503 - View Map
Apr 11
4-26-16: Brent Ozar talks about Career Planning for DBAs

​Just passing this along.  If you're starting a career as a DBA (or want to get yours back on track) this free webinar might be worth your time:

https://www.brentozar.com/first-aid/events/#Register 

You’ve got a job working with databases, and you like it, but you’re not sure what to do next. How do you become a senior DBA, a consultant, or just be more technical? Brent Ozar grew his career from sysadmin to developer to DBA to self-employed consultant, and he’ll share tips on how to grow your career as quickly as possible.

You’ll learn how to:

    • Decide what to specialize in
    • Assess your current skills
    • Build a learning plan
    • Market yourself as a full time employee or a consultant​


Feb 17
3-10-16: Tuning Indexes with SQLDMO and System Views

Topic for the March 2016 Meeting:

 

Tuning Indexes using SQLDMO and System Views

Like Frankenstein's Monster (or our teenagers) things get released into the wild and behave differently than planned - database usage patterns are no different. Join Tim as he reviews what to look for when tweaking your index strategy using the SQL Server Dynamic Management Objects and system views as well. Tim will spend a fair amount of time initially reviewing these constructs so a very basic idea of what DMOs and system views is all you need to get you right into the conversation.  We will cover:

  • Analyzing Fragmentation
  • Identifying Index/Heap Use/Non-Use
  • Discovering Page Splits
  • Returning Information on What Indexes Exist on a Specific Table
  • Presenting Your Largest Indexes by Size and Rows

Audience: DBA / IT Pro, Level 200-300

GlennBerry.jpgAbout Tim Ford, SQLCruise.com
Tim Ford is an Author and Community Leader whose technical passions lie in creative solutions for managing and presenting data.  He spent 16 years in the healthcare sector as a Developer, Database Administrator, Team Leader and (hands-on) Manager where he created the entire SQL Server environment of eventually hundreds of instances and thousands of databases from the ground-up.  He recently traded all that in for a position at SurveyMonkey that adds the intricacies of administering an environment requiring single-digit-millisecond response times and also brings him into working in a developer-centric environment.  Tim also leads SQL Agent Man Consultancy and SQL Cruise Events where he takes 25-30 students and Technical Leaders in the SQL Community and places them on cruise ships for technical and professional development training without the distractions of the office and internet twice a year on SQL Cruises (www.sqlcruise.com).  2017 will bring SQL Cruise back to Alaska for the first time since 2013 (and to the Caribbean of course.)

Tim and Louis Davidson wrote the book on DMOs and loves to discuss them with anyone willing to listen. He's thrilled to be able to speak to the Alaska SQL Server Users Group this March.

Watch Now on YouTube!

 

 
Feb 16
4-14-16: Hardware 201 - Sizing Database Hardware with Glenn Berry

Topic for the April 2016 Meeting:

 

Hardware 201: Selecting and Sizing Database Hardware for OLTP Performance

The foundation of database performance is the underlying server hardware and storage subsystem. Even the best designed and optimized database application can be crippled by an inadequate hardware and storage infrastructure. Recent advances in new processors and chipsets, along with improvements in magnetic and SSD storage have dramatically changed the evaluation and selection process compared to the past. Many database professionals struggle to keep up with new technology and often simply let someone else make their hardware selection and sizing decisions. Unfortunately, the DBA usually gets the blame for any performance issues that crop up later. Don't let this happen to you! This session covers current and upcoming hardware from Intel and gives you the tools and resources to make better hardware selection decisions to support SQL Server OLTP workloads.

Audience: DBA / IT Pro, Level 100-200

Note: this is a 90-minute session, including Q&A, so be sure to make arrangements for a long lunch!

GlennBerry.jpgAbout Glenn Berry:
Principal Consultant, SQLSkills.com
Glenn is a Microsoft SQL Server MVP. He has worked as a SQL Server professional for many years in a variety of roles, including stints with NewsGator and Avalara. His expertise includes DMVs, high availability, hardware selection and configuration, and performance tuning. He is also an Adjunct Faculty member at University College – University of Denver, where has been teaching since 2000. Glenn is heavily involved in the SQL Server community, and is a frequent speaker at user groups, SQL Saturdays, SQLintersection, and the PASS Community Summit. He is the author of the book SQL Server Hardware, and he wrote chapters for SQL Server MVP Deep Dives and SQL Server MVP Deep Dives Volume 2 books.

Download Glenn's slides

Watch now on YouTube!

 
Feb 11
Attend a SQL Server 2016 webcast - Win a Lenovo Yoga 3 Pro

​Passing this on!  Microsoft is presenting a webcast to cover some cool new stuff in SQL Server 2016.  Even if you don't win a free computer, you still get to hear about SQL 2016, which doesn't suck.

In this webcast you will learn how:

  • SQL Server 2016's blazing fast performance is the biggest leap forward in Microsoft's data platform history with real-time operational analytics
  • Advanced Analytics provides deeper insights for better sales forecasting, fraud detection, and other data-driven business decisions
  • Enhanced AlwaysOn Availability makes lost data recovery a breeze
  • Always Encrypted technology protects your most valuable asset – your data – at rest or in motion.

SQL Server 2005 Support ends in just a few months, which means it's probably a good time to educate yourself on SQL Server 2016's exciting capabilities and get ready to migrate in order to protect your data.

Register: https://clicktoattend.microsoft.com/en-us/Pages/EventDetails.aspx?CR_CC=200759962&EventId=215879

 

1 - 10Next