Omaha SSUG – February 2015 – Performing a SQL Server Health Check

Our next Omaha SQL/BI User Group meeting will be Wednesday, February 4th, 2015 at 6PM. We will be sponsored by Modis and hosted by Farm Credit Services of America, 5015 South 118th ST, Omaha, NE 68137, in their North building.

Speaker – Andy Galbraith
Andy Galbraith is Microsoft SQL Server DBA of 13+ years, a devoted husband, and a father of three young boys (all aged four and under!) He has been a DBA at a public university, at a major bank, at a healthcare system, and he now works as a consultant and managed services DBA with customers across the United States. He writes and speaks primarily about the tips and tricks that he discovers along his SQL Server journey.

Abstract
How often do you review your SQL Servers for basic security, maintenance, and performance issues? If you say never, I’m not surprised – many of the servers I “inherit” as a managed services provider have many gaping holes. It is not unusual to find databases that are never backed up, constant login failures (is it an attack or a bad connection string?), and servers that need more RAM/CPU/etc. (or sometimes that have too much!) Come learn how to use freely available tools to check your servers for basic issues like backups and CheckDB as well as for more advanced issues like page life expectancy and indexing. If you are responsible in any way for a Microsoft SQL Server (DBA, Windows Admin, even a Developer) you will see value in this session!

RSVP Todayhttp://omahamtg.com/Events.aspx?ID=266

Omaha SSUG – November 2014 – SQL Server and X-IO Storage

Our next Omaha SQL/BI User Group meeting will be Wednesday, November 12th, 2014 at 6PM. We will be sponsored by X-IO and hosted by Blue Cross and Blue Shield of Nebraska, 1919 Aksarben Drive.

Speaker – Roger Kelley
Roger Kelley is Principle Architect for Xiotech Corporation. A 25-year industry veteran with 14-years at X-IO. He has extensive experience in architecture, design, and implementation of storage area networks and replication technologies. He is responsible for assisting customers in strategic storage planning and disaster avoidance and preparedness. He also has responsibilities in assisting the driving of company direction as it relates to technology offerings and positioning, as well as evangelizing new technologies. He has presented at many storage and networking–related seminars throughout the United States.

Abstract
SQL needs a fast infrastructure to perform optimally. A significant part of that infrastructure is the data storage SQL resides on. X-IO ISE technology has been utilized by Microsoft to set SQL 2012 “high-water” benchmarks for performance. This presentation will focus on the storage technology that Microsoft used, why it was chosen, and what makes it an excellent choice in SQL environments today.

RSVP Today: http://omahamtg.com/Events.aspx?ID=259

Omaha SSUG – October 2014 – Building An Automated Database Deployment Pipeline

Our next Omaha SQL/BI User Group meeting will be Wednesday, October 8th, 2014 at 6PM. We will be sponsored and hosted by Farm Credit Services of America, 5015 South 118th ST, Omaha, NE 68137, in their North building.

Our April 2014 speaker will be Alex Yates from Red-Gate Software.  He joins us all of the way from the United Kingdom to give a dazzling presentation on automated database deployments!  This is an event you will not want to miss.

Speaker
Alex Yates has worked with database change management tools for four years, collaborating closely with users and dev teams along the way. As a pre-sales engineer, he gets to see a huge variety of server and dev environments, and helps folks solve their database development and delivery problems in whatever way works well for them. Ever the sharer, he also blogs about the lessons he learns: http://www.workingwithdevs.com

Abstract
The pace of business accelerates fairly continuously and application development moves right with it. But we’re still trying to deploy databases the same way we did 10 years ago. This session addresses the need for changes in organizational structure, process and technology necessary to arrive at a nimble, fast, automatable and continuous database deployment process. We’ll use actual customer case studies to illustrate both the common methods and the unique context that led to a continuous delivery process that is best described as a pipeline. You will learn how to customize common practices and tool sets to build a database deployment pipeline unique to your environment in order to speed your own database delivery while still protecting your organization’s most valuable asset, its data.

RSVP Todayhttp://omahamtg.com/Events.aspx?ID=256

Omaha SSUG – April 2014 – BYOSP! (Bring Your Own SQL Problem!)

Our next Omaha SQL/BI User Group meeting will be Wednesday, April 2nd, 2014 at 6PM. We will be sponsored and hosted by First National Bank, 7th Floor, 1601 Dodge ST, Omaha NE 68102.

Our April 2014 speaker will be you, the members of the Omaha SSUG!

The Topic:

BYOSP! (Bring Your Own SQL Problem!)

Synopsis:

Having problems with SQL Server? Bring the issue to the meeting!
Can get that report just right? Bring the issue to the meeting!
Your cube not slicing & dicing the way that you want? Bring the issue to the meeting!
Need clarification on a SQL Server feature? Bring it to the meeting!
Don’t have anything but want to help out your fellow IT person? Bring yourself to the meeting!

Nothing is out of bounds for this meeting. We’ll take a list of topics from the members and we’ll use the collective brain power of those present to try to get you pointed in the right direction and/or even present a solution to you!

We’ll have a facilitator and access to a test SQL Server so that we can test some of the questions out on.

So bring your laptops, your questions, and your willingness to speak up and help another!

Food will be provided about 15-25 minutes prior to the start of the meeting. Register today to let us know you’re coming and to be eligible for a chance to win some great SWAG!

Registration Link: http://omahamtg.com/Events.aspx?ID=237

Omaha SSUG – March 2014 – Squeezing Top Performance From Your Virtualized SQL Server

Our next Omaha SQL/BI User Group meeting will be Wednesday, March 5th, 2014 at 6PM.  We will be sponsored and hosted by Aureus Group, 13609 California ST, Suite 100, Omaha NE 68154.

Our March 2014 speaker will be David Klee.  David, VMware vExpert 2013, is a SQL Server performance and virtualization expert. With over sixteen years of IT experience, David spends his days handling performance and HA/DR architecture of physical and virtualized mission critical SQL Servers as the Founder and Chief Architect for Heraflux Technologies. His areas of expertise are virtualization and performance, datacenter architecture, software engineering, security, and business process analysis. You can read his blogs at davidklee.net and linchpinpeople.com, and reach him on Twitter at @kleegeek.

David speaks at a number of national and regional technology related events, including the SQL PASS Summit, VMware Partner Exchange, numerous SQL Saturday events, SQL PASS virtual chapter webinars, and many SQL Server User Groups.

The Topic:

Squeezing Top Performance from Your Virtualized SQL Server

Synopsis:

Just about anyone can click through a SQL Server installation and get it working, but more than a little  tuning is required to get the most performance out of your servers. Once virtualized, additional tuning can help get even more performance out of that virtual machine. David Klee (@kleegeek) will discuss valuable details for both VMware vSphere and Microsoft Hyper-V on how to tweak and tune your virtual infrastructure for business-critical virtualized SQL Servers. Tips on configuring your SQL Server installations for maximum performance when virtualized will be covered. We will also present tips on monitoring and capacity management so you know when you need to add more hardware to keep your database servers running at their peak performance.

Food will be provided about 15-25 minutes prior to the start of the meeting.  Register today to let us know you’re coming and to be eligible for a chance to win some great SWAG!

Registration Link: http://omahamtg.com/Events.aspx?ID=233

 

SQL Saturday #197 – Three Pre-Cons Announced!

We are excited to announce that we will be offering three pre-con events in coordination with our SQL Saturday event!

Please join us on Friday, April 5th, 2013, to learn about SQL Server 2012, Powershell, and Self-Service BI from three great speakers!  Here are the three sessions:

  • Scaling SQL Server 2012 – Glenn Berry

    How can you scale SQL Server 2012? Scaling up is relatively easy (but can be expensive), while scaling out requires significant engineering time and effort. If you suggest hardware upgrades you may be accused of simply “throwing hardware at the problem”, and if you try to scale out, you may be thwarted by a lack of development resources or 3rd party software restrictions. As your database server nears its load capacity, what can you do? This session gives you concrete, practical advice on how to deal with this situation. Starting with your present workload, configuration and hardware, we will explore how to find and alleviate bottlenecks, whether they are workload related, configuration related, or hardware related. Next, we will cover how you can decide whether you should scale up or scale out your data tier. Once that decision is made, you will learn how to scale up properly, with nearly zero down-time. If you decide to scale out, you will learn about practical, production-ready techniques such as vertical partitioning, horizontal partitioning, and data dependent routing. We will also cover how to use middle-tier caching and other application techniques to increase your overall scalability.

  • Practical Self-Service BI with PowerPivot 2012 for Excel – Bill Pearson

    SQL Server MVP and Business Intelligence Architect Bill Pearson leads this full-day, hands-on introduction to using PowerPivot 2012 for Excel to deliver self-service business intelligence.  The focus of the course is to help those new to PowerPivot to become familiar with the assembly of data from diverse sources into models that deliver business intelligence upon demand.  Participants will gain exposure to accessing and relating data, and to employing the Data Analysis Expressions (DAX) language, to construct and share PowerPivot applications that support analysis and reporting throughout the enterprise.  The intended audience is information workers (business- or IT-based) involved in analysis and reporting of data,  intermediate – to – advanced Excel users,  practitioners that want to gain familiarity with PowerPivot to build compelling analysis and reporting applications to deliver self-service BI.

  • Prof. PowerShell Or How I Learned to Stop Worrying and Love PowerShell – Jeff Hicks

    Windows PowerShell has a special talent for simultaneously exciting and terrifying IT Pros. Many see it as just another scripting language or passing fad. Other’s see it as an essential technology for managing today’s Windows-based environments. Some IT Pros feel overwhelmed and don’t know where to start and others dive right into the deep end, sometimes with mixed results. In this one day session, PowerShell MVP, author and Prof. PowerShell will dispel fears, myths and misconceptions surrounding this must-know management tool. If you’ve been dabbling in PowerShell, wondering what all the fuss is about, or simply want to get a jump start, this is the session for you. After this crash course on PowerShell 3.0 you’ll realize you had nothing to worry about begin to feel the PowerShell love.

    This isn’t a formal training course, but bring your laptop with PowerShell 3.0 and feel free to follow along.

The pre-con event will be held at Blue Cross and Blue Shield of Nebraska building (1919 Aksarben Drive, Omaha, NE) and will run 8AM – 5PM.  Registration required.  For more details on pricing and registration, please visit http://sqlsaturdayomahaprecon.eventbrite.com/