Blog

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

September User Group Meeting is at 12pm September 11th, 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.

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.

 

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, from Thursday, September 11, 2014 to 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 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.

Feb 14
SQL 2014 and Backing Up to Azure

SQL 2014 Backup to Azure.JPG

I have been watching some of the SQL 2014 courses over at Microsoft Virtual Academy.  The first video of the "Platform for Hybrid Cloud with SQL Server 2014 Jump Start" series talks about "Backup to Cloud".  Now, if you're like me, you treat "The Cloud" with suspicion, especially when it comes to SQL Server.  How can you guarantee performance?  How do you keep your data safe?  Doesn't it cost an arm and a leg?

But the idea of backing up your databases to an offsite location is still a compelling case, because you have to plan for the worst case.  If a fire could destroy your company's office, your data will go up in smoke too, and there goes your livelihood.  Many companies use the very manual method of a staged backup (backup to share, then back up the share to a tape) which you then take offsite.   But tapes wear out, people forget to do it, or someone stores the tapes next to a magnet... then you're back in the same boat. 

A better, automated way, would be to use a service that will consistently back up your databases in a way that makes it easy to retreive the data if needed.

Full disclosure, I work for a tech company that offers this kind of service.  We call it "Cloud DataSafe", which backs up entire servers, files and databases. Click here if you want to know more.

In SQL Server 2012, as of Cumulative Update 4 (for Service Pack 1), you can now "Back up to URL" in addition to specifying a tape drive and a file share location.  The URL is, of course, an HTTPS endpoint for the Azure Blob Storage cloud.  Currently, you have to use TSQL or PowerShell to provision the storage, set credentials, specify a container in the cloud, and then trigger the backup.  All scriptable, of course.

The Azure Blob Storage subscription seems pretty reasonable: you get 5GB free per month, with $.050 per each additional gigabyte.  For a small business this might be just about right. 

When SQL 2014 is released, this Backup to URL capability will be available in the GUI. 

But what if you aren't using SQL 2012 or 2014?  Well, Microsoft has a free tool called "SQL Server Backup to Azure Tool", which installs itself as a service.  The way it works is, you back up your databases to a file path, and the tool will automatically grab the backups, compress them, encrypt them, and stream them up to Azure. 

If you wanted, you could just compress/encrypt and then save them back to your file system. 

Another interesting feature is the Managed Backup capability: this is where you set up a plan to back up to URL.  The job only runs when data has actually changed, thus simplifying backups and restores.  This is essential for a cloud backup, where you might otherwise be streaming gigabytes every day.  So rather than having these regimented backups (e.g. Daily full + Houly transaction logs), the backup only runs if transactions have occurred.  Similarly the restore process simply selects the backup set, and gives you a timeline view to choose your restore point. 

If you'd like to learn more (and why wouldn't you?) then you should check out these free SQL 2014 courses at MVA:

 

Jan 11
1-9-14: Intro to SQL Server High Availability

I've posted the recording for the January 2014 user group meeting (embedded below).  ​The topic was Introduction to High Availability in SQL Server, which ties in to the blog post I wrote earlier.  After the presentation, there was a Q&A, but the audio didn't turn out very well (it just sounded like I was talking to myself).  I've edited that part out. 

 


 

Jan 01
Optimizing SQL Server in a VM

While I was on vacation, I did some training on SQL Server (doesn't everyone spend their vacation that way?) -- In my experience, virtual SQL can run very well (and very reliabily) but there is an extra layer of complexity involved.  But I find it fascinating.

SQL MVP Denny Cherry tells you what you need to know about virtualizing SQL Server.   

The video below is from TechEd 2012 but it's more or less the same lecture:

 

Click here if the video doesn't embed properly for you.

Want more? SQL MVP Brent Ozar, who also covers best practices for virtualizing SQL Server, here:

http://www.brentozar.com/sql/virtualization-best-practices/

Here's a Q&A he did in May 2013 on the subject:

 


You might also be interested in shelling out a little money for this course on SQL virtualization, over at PluralSight:

SQL Server Virtualization - Jonathan Kehayias
Learn how to properly configure, control, and monitor virtual machines, and troubleshoot problems when running SQL Server in a virtualized environment using VMware or Hyper-V, applicable for DBAs, VM admins, and any other IT admins responsible for SQL Server and/or virtualization

PluralSight is high-quality training, and it starts at $29/month, which grants you access to their entire library. 
1 - 10Next