Blog

Sep 15
12-11-14: PowerShell Cmdlets for the DBA

December 11, 2014 Meeting

 

We'll be meeting at the Network Business Systems office in their conference room at their new Midtown location:

3000 C Street, Suite 210

Anchorage, Alaska  99503 

Click here for directions.

 

PowerShell Cmdlets fot the DBA

You've been hearing about this newfangled craze, and it's time to learn exactly why it's called POWERshell. You'll want to take notes, or better yet, bring your laptop and start using Powershell immediately. We will get Posh running and then I'll introduce you to the basic concepts, with examples to make things happen right away. We'll work on SQL Server with Powershell, and learn some cool techniques. Come see this all-demo, hands-on session!

Speaker: Jen McCown (Midnight DBA) 
Jen McCown is a Microsoft Certified Master in SQL Server, and co-owner of MidnightSQL Consulting, LLC. Jen is Senior Editor at MidnightDBA.com, where she creates training videos, the DBAs@Midnight webshow, blogs, reviews, and podcasts. Jen is a member, volunteer, and speaker in NTSSUG, PASS, and the PASS Women in Technology virtual chapter. She has presented at multiple technology conferences, including SQL Saturday, SQL Bits, and the PASS Summit.

More here: http://midnightdba.itbookworm.com/

 

Door Prize

We'll be giving away:

  • A voucher for a free book of your choice from O'Reilly Publishing
  • Other items TBD

WebEx Meeting Details:

Topic: Alaska SQL User Group
Date: The 2nd Thursday of every 1 months, no end date
Time: 12:00 pm, Alaska Daylight Time (Anchorage, GMT-08:00)
Meeting Number: 925 568 259
Meeting Password: alaskasql

-------------------------------------------------------
To join the online meeting (Now from mobile devices!)
-------------------------------------------------------
1. Go to https://nbsys.webex.com/nbsys/j.php?MTID=m567111cfef4c60b9bcc1ac1b6b89f80d
2. If requested, enter your name and email address.
3. If a password is required, enter the meeting password: alaskasql
4. Click "Join".
5. Follow the instructions that appear on your screen.

To view in other time zones or languages, please click the link:
https://nbsys.webex.com/nbsys/j.php?MTID=mfb74adb5a0fd5d1967f7655254b79cdf 

Sep 15
11-13-14: SQL Server Optimization for SharePoint

November 13, 2014 Meeting

 

We'll be meeting at the Network Business Systems office in their conference room at their new Midtown location:

3000 C Street, Suite 210

Anchorage, Alaska  99503 

Click here for directions.

 

SQL Server Optimization for SharePoint

DBAs know that SharePoint just doesn't play nice with SQL Server. SharePoint administrators know that DBAs just don't understand SharePoint. This session will show hands-on how to get a SQL Server instance set up more effectively for SharePoint 2013. It's not black magic and it doesn't involve undocumented trace flags. Maybe DBAs and SharePoint admins can't get along, but at least you'll be able to cooperate after this session.

Speaker: Sven Aelterman 
I am a Lecturer in Information Systems at Troy University's Sorrell College of Business in Troy, Alabama, USA. I am also the Director of IT for the College of Business, which means I am principally responsible for all technology in the College.  When possible, I also continue to be involved in consulting for the Microsoft platform, which includes .NET, SQL Server, Windows Server, and COM technologies. Most recently, I've worked on SQL Server high-availability and disaster recovery projects.

http://svenaelterman.wordpress.com/

 

Door Prize

We'll be giving away:

  • A voucher for a free book of your choice from O'Reilly Publishing
  • Other items TBD

WebEx Meeting Details:

Topic: Alaska SQL User Group
Date: The 2nd Thursday of every 1 months, no end date
Time: 12:00 pm, Alaska Daylight Time (Anchorage, GMT-08:00)
Meeting Number: 925 568 259
Meeting Password: alaskasql

-------------------------------------------------------
To join the online meeting (Now from mobile devices!)
-------------------------------------------------------
1. Go to https://nbsys.webex.com/nbsys/j.php?MTID=m567111cfef4c60b9bcc1ac1b6b89f80d
2. If requested, enter your name and email address.
3. If a password is required, enter the meeting password: alaskasql
4. Click "Join".
5. Follow the instructions that appear on your screen.

To view in other time zones or languages, please click the link:
https://nbsys.webex.com/nbsys/j.php?MTID=mfb74adb5a0fd5d1967f7655254b79cdf 

Sep 14
10-9-14: How Active Directory Affects SQL Server

October User Group Meeting is at 12pm October 9, 2014

 

We'll be meeting at the Network Business Systems office in their conference room at their new Midtown location:

3000 C Street, Suite 210

Anchorage, Alaska  99503 

Click here for directions.

How Active Directory Affects SQL Server

If you have ever had a Kerberos or SSPI context error, then you won't want to miss this session.  SQL Server has a large surface area and Active Directory can influence a big part of it.  I will discuss AD DNS configuration, Group Policy Objects, Kerberos (of course), and how all of them affect your SQL Server.  By the end of the session you'll have a check list of things to discuss with your domain administrator when you return to work.

Speaker: Ryan Adams 
Ryan has worked for a Fortune 100 company for 15 years. He is the sole SQL Server DBA for his group. His primary focus is the SQL Server Engine and performance, but also works with SSRS and SSIS. Prior to becoming a SQL DBA, he was a Senior Active Directory Architect and Identity Management Consultant where he architected the company's worldwide Active Directory infrastructure supporting over 250k users.  He enjoys being involved in the SQL community and serves on the Board of Directors for the North Texas SQL Server User Group and is President of the PASS Performance Virtual Chapter. He also serves as a Regional Mentor for PASS.

More Information: http://www.ryanjadams.com/

 

Door Prize

We'll be giving away:

  • A voucher for a free book of your choice from O'Reilly Publishing
  • Other items TBD

WebEx Meeting Details:

Topic: Alaska SQL User Group
Date: The 2nd Thursday of every 1 months, no end date
Time: 12:00 pm, Alaska Daylight Time (Anchorage, GMT-08:00)
Meeting Number: 925 568 259
Meeting Password: alaskasql

-------------------------------------------------------
To join the online meeting (Now from mobile devices!)
-------------------------------------------------------
1. Go to
https://nbsys.webex.com/nbsys/j.php?MTID=m567111cfef4c60b9bcc1ac1b6b89f80d
2. If requested, enter your name and email address.
3. If a password is required, enter the meeting password: alaskasql
4. Click "Join".
5. Follow the instructions that appear on your screen.

To view in other time zones or languages, please click the link:
https://nbsys.webex.com/nbsys/j.php?MTID=mfb74adb5a0fd5d1967f7655254b79cdf

Aug 22
9-11-14: Secrets of Enterprise Data Mining

September User Group Meeting

 

Secrets of Enterprise Data Mining

If you have a SQL Server license (Standard or higher) then you already have the ability to start data mining. In this new presentation, you will see how to scale up data mining from the free Excel 2013 add-in to production use. Aimed at beginning to intermediate data miners, this presentation will show how mining models move from development to production. We will use SQL Server 2014 tools including SSMS, SSIS, and SSDT.


 
Speaker: Mark Tabladillo, SQL MVP

Mark is a consultant who provides enterprise data science analytics advice and solutions. He uses Microsoft Azure Machine Learning, Microsoft SQL Server Data Mining, SAS, SPSS, R, and Hadoop (among other tools). He works with Microsoft Business Intelligence (SSAS, SSIS, SSRS, SharePoint, Power BI, .NET). He is a SQL Server MVP and has a research doctorate (PhD) from Georgia Tech.

Watch video now:

https://www.youtube.com/watch?v=Ggpw5zhsbok

 

 

View / /Download slides here:

http://www.slideshare.net/marktab/mark-tab-secretsenterprise201408

Aug 01
8-14-14: Manage SQL Server Using Built-In Tools

 

Thinking Out of the Box: Manage SQL Server Using Built-In Tools

 

 

It’s often the case that your budget doesn’t stretch far enough for all the great third party tools that help manage your SQL Servers. So, how can the in-built components of SQL Server help you with your daily tasks? 

Policy Management, Data Collector and Extended Events, all included in both Enterprise and Standard Editions, provide a framework to keep your configurations consistent and give you some insights into the performance of your SQL Server instances. In this session, we will see how to make use of these components to formalize your configuration and track some performance attributes.After this session you’ll be able to build out an effective management and monitoring toolkit using only “out-of-the-box” features..
 
Speaker: Martin Cairney
Martin Cairney is a highly experienced Database Administrator for LobsterPot Solutions in Melbourne, Australia. He has worked across many industry sectors including London’s global financial institutions and both State and Federal Government Departments. He has presented a number of times at SQLBits, SQL Saturdays and User Groups in Australia and the UK. Martin is a MCT, has MCSE, MCITP and MCDBA certifications and runs the SQLSocial and SQL Saturday events in Melbourne.

 

Door Prize

We'll be giving away:

  • A voucher for a free book of your choice from O'Reilly Publishing
  • Other items TBD


In Person: We'll be meeting at the Network Business Systems office in their conference room at their new Midtown location:
3000 C Street, Suite 210
Anchorage, Alaska 99503

Click Here for Directions

WebEx Meeting Details:

Topic: Alaska SQL User Group - August 2014
Date: Thursday, August 14, 2014
Time: 12:00 pm, Alaska Daylight Time (Anchorage, GMT-08:00)
Meeting Number: 924 767 307
Meeting Password: alaskasql

-------------------------------------------------------
To join the online meeting (Now from mobile devices!)
-------------------------------------------------------
1. Go to https://nbsys.webex.com/nbsys/j.php?MTID=md20c9de8883281c38d1a89640b58ce25
2. If requested, enter your name and email address.
3. If a password is required, enter the meeting password: alaskasql
4. Click "Join".
5. Follow the instructions that appear on your screen.

To view in other time zones or languages, please click the link:
https://nbsys.webex.com/nbsys/j.php?MTID=m9482f5a0e7a98207fd35f3ae17da1c6c 

Jul 12
7-10-14: Manage Your Shop with CMS and Policy Based Management

The session recording for our JUly 10th meeting is now on YouTube.  In this 90 minute session, Ryan spoke about how to set up a Central Management Server for SQL Server, and how to implement policies.

"​In this SQLRally #3 rated session I will talk about Central Management Server and how it can help you manage a disperse environment.  I will also cover what Policy Based Management is and how you can leverage its power to better manage your environment.  With PBM we'll see what it can and cannot do to help you enforce standards in your enterprise.  I will demonstrate PBM from creating and evaluating policies to receiving alerts on policy violations."

 


Slides are available here: 

http://www.ryanjadams.com/wp-content/uploads/2011/01/PBM-Preso1.pdf​

Jun 23
6-12-14: What's New in SQL Server 2014

Hi All,

Unfortunately, the session recording for "What's New in SQL 2014" ​did not turn out.  Guy Glantser did share his slides, however.  Click the link below to download.

Download

May 13
5-8-14: Windows 2012 R2 Clustering for SQL Server

​Sven Aelterman delivered this great presentation on Windows 2012 R2 Clustering for SQL Server: "With the increasing adoption rate of virtualization, creating SQL Server clusters is now within reach of many more DBAs. What do you need to know about Windows Server 2012 (R2) virtualization and high availability to set up your first cluster? What's needed for geo-clustering? Come learn from a Windows Server admin and (accidental) DBA who's been building SQL Server clusters since 2000 (the year and the version!). We'll discuss initial planning, the process and the maintenance best practices. There will be demos too, so if you want to see a multi-node SQL cluster run on a Lenovo X230 tablet, come see (it's pretty cool!)"

 

 

Slides are available here.

Apr 21
4-17-14: Designing Stored Procedure Solutions

Guest speaker Jen McCown (Midnight DBA) delivered this excellent presentation on Stored Procedures: "In this session, you'll learn about SQL Server stored procedures (SPs): what they are, when and why you'd use them, and how you'd go about developing a solution with one. We will address common SP myths and learn about planning for performance. Most of all, we'll walk through examples to explore the process of solution building in SQL Server. "

 

​Downloads: Designing Stored Procedure Solutions – Demo Code

Mar 03
Test

When I create a blog post, it should be posted on Twitter and Facebook.

1 - 10Next