North Texas SQL Servers Users Group

Next Meeting

Thursday,

March

15

NTSSUG - 15 March 2018 Meeting & Newsletter

  • In-Person @ 7000 North Highway 161 Irving, Texas, United States (map)
  • 18:00 - 20:00 Central Daylight Time
  • Language: English

RSVP Here: https://www.meetup.com/North-Texas-SQL-Server-User-Group/events/248353078/

SQL Server Administration - Tips from the Trenches 

The Ides of SQL Edition!!!!!

Abstract:

Join us for a SQL Administrator's goodie bag of tips and queries to use to make SQL unlikely to plot your overthrow. Et tu, SQL?!

Topics will cover a range of subjects such as:

  • Setting up Change Alerts with DDL Triggers (Be the soothsayer warning of bad things to come!)
  • SQL Instance Restart Notification or Cluster Failover Alert (Are the whispers of SQL demise true?!)
  • Find Who Changed Permissions in the Default Trace (Watch out for those hidden daggers!)
  • Find Currently Executing Queries (See and tame the chaos!)
  • TDE Encryption Implications and Query Performance (Put the back stabbers in jail!!)
  • Check the plan cache for Missing Indexes (Gather your friends close to you.)
  • And more......

Presenter:


Lori Brown

Lori Brown is the SQLRx Practice Manager (sqlrx.com) and a Senior Consultant for Integrated Services, Inc. (isi85.com). Lori has more than 20 years of IT experience with proven expertise in performance tuning, bottleneck identification, disaster recovery/high availability, data migration, SQL upgrades and training. She has worked with relational databases since 1998 and SQL Server since version 7.0. She has taught courses on SQL Server administration and performance tuning, and has spoken at several SQL Saturday events. Lori has conducted numerous performance studies and has developed the methods and code used in SQLRx’s RemoteDBA offering. She has also published articles in SQL Server Magazine, contributed to SQLServerCentral.com and is a regular blogger on the SQLRx blog (blog.sqlrx.com).

  • Meeting starts: 6:00 pm with food and mingling
  • Announcements & Ask the Experts: 6:30 pm to 7:00 pm
  • Presentation: 7:00 pm to 8:00 pm
  • When: Thursday, March 15, 2018

    Address:
    Microsoft Las Colinas Offices
    7000 North Highway 161 , Building LC-1
    Irving Texas 75039
    Map: https://goo.gl/maps/h9aWDZ6Z3wK2

​RSVP at Meetup Please: https://www.meetup.com/North-Texas-SQL-Server-User-Group/events/248353078/


SQL Saturday Pre-Cons Announced!

SQL Saturday Dallas is coming up on Saturday May 19th. The day before (Friday the 18th) we will be having some full day training on special subjects. We are thrilled to welcome five (5) distinguished industry experts  delivering four (4)Pre-Cons this year!! All Pre-cons will take place at UTD in Richardson, TX. Seating is first come, first served. The price is also discounted if you sign up earlier, rather than later, so get a move on!

Thomas LeBlanc and Kevin Hill, who will each be hosting FULL DAY pre-cons this year

AND

Sean & Jennifer McCown and Rick Lowe, who will each be presenting HALF DAY pre-cons.

  • If you register for a pre-con: you must still register to attend SQL Saturday.
  • If you register for a pre-con and are on the SQL Saturday wait-list: please e-mail a copy of your pre-con registration receipt to sqlsaturday734@sqlsaturday.com.

Thomas LeBlanc presents: Power BI On-Premise in a Day

This day long session will concentrate on what currently can be done On-Premise with Power BI. Time will be spent on connecting to various data sources. Data modeling will include inside on Power BI and using a Tabular Model for enterprise modeling. Measures will be created to show the power of the DAX language/functions and expanded with Time Intelligence for impressing data consumers in an organization. Data modeling will show attendees why a majority of time is spent on data structure, importing and cleansing data. The visuals are the cool stuff, but not a lot of time has to be spent here if the data is well structured. But, we will still show canned visuals, filters, custom visuals in addition to R Scripts. The formatting and interaction between visuals and filters will complete the dashboard look to the Power BI report. The last function is to show how to use in the new Power BI Report Server. We might even see a dashboard with the Mobile Report tool (DataZen).

Register For Thomas' Precon Here (Full Day)

 


 

Kevin Hill Presents: DBA Fundamentals - give yourself a solid SQL Foundation!

This class is designed for New or Non-DBAs struggling with SQL admin tasks, and having to Google things daily. I will teach you SQL Server fundamentals so that you will have confidence in:

  • What makes up a SQL Server
  • How a database is structured
  • How to install and what to look out for
  • Finding what you need in Management Studio
  • SQL Security Basics
  • How to create and manage backups
  • How to create a database
  • Basic performance troubleshooting
  • Picking a Disaster Recovery option for your environment

These are taught from a foundational standpoint, in simple to understand terms so that you can build on them with confidence. My teaching is heavy on interaction, with examples from years of experience/mistakes. There will be a mix of slides and demos. I'll skip many advanced features that are out of scope of a beginner class, as I don't want your head to explode! Join me for the day and you will walk out with a strong grasp of SQL Admin basics!

https://youtu.be/t4LLzEcRIOs

Register for Kevin's Pre-Con here (Full Day)

 


Sean & Jennifer McCown Present: Beginning Programming with Powershell (Half-Day)

Have you ever wanted to learn how to code, but you don’t think you have enough knowledge to jump into a class? In this half-day class we’re going to start from scratch and teach you the basics you need to know to begin your coding career. By the time we’re finished, you’ll be able to understand the basic concepts, and do a lot more in code than you would expect.

This course is for those who are completely new to coding and want to get started. It is not necessarily for those with coding experience, and just want to learn PowerShell. If you have experience, you’re welcome to come because you will learn the basics of PowerShell, but some of the beginning concepts may leave you answering work email. So whether you’re strictly an admin, or a business person, manager, or any other field, if you’ve got no experience coding, then this course is for you. Your coding career starts today.


Register for Sean & Jennifer's Pre-Con Here (Half-Day)

 

 


 

Rick Lowe presents: What to Do Instead of ... Query Hints and Entity Framework (Half-Day)

Most database developers have been told at some point that using the NOLOCK hint is dangerous ... and yet many source control repositories are stuffed to the gills with NOLOCK. Why? Most likely because blocking is a real problem and NOLOCK does often help reduce blocking. If we accept that NOLOCK is bad then what strategies should be used instead to reduce blocking? It can be extremely difficult (impossible?) to find a DBA that is excited about supporting LINQ to Entities (or other object relational mapper) workloads. And yet LINQ is still pretty frequently used. Why? Most likely because non-ORM alternatives such as ADO.Net are a lot more work for the developers. Is this a hopeless conflict, or can deloper teams do things to make DBA lives less painful when using LINQ? If you’ve ever been frustrated by the feeling you’re told what not to do, without positive guidance on alternatives, this half day session may be for you.

Register for Rick's Pre-Con Here (Half-Day)

 

Featured Presentation:

SQL Server Administration - Tips from the Trenches – The Ides of SQL Edition!!!!!

Lori Brown, SQLRx Practice Manager SQLRX

Join us for a SQL Administrator's goodie bag of tips and queries to use to make SQL unlikely to plot your overthrow. Et tu, SQL?! Topics will cover a range of subjects such as: > Setting up Change Alerts with DDL Triggers (Be the soothsayer warning of bad things to come!) > SQL Instance Restart Notification or Cluster Failover Alert (Are the whispers of SQL demise true?!) > Find Who Changed Permissions in the Default Trace (Watch out for those hidden daggers!) > Find Currently Executing Queries (See and tame the chaos!) > TDE Encryption Implications and Query Performance (Put the back stabbers in jail!!) > Check the plan cache for Missing Indexes (Gather your friends close to you.) > And more......

About Lori:
Lori is the SQLRx Practice Manager (sqlrx.com) and a Senior Consultant for Integrated Services, Inc., located in Dallas Texas(isi85.com). Lori has more than 18 years of experience with SQL. At ISI, she provides SQL Server expertise in performance tuning, disaster recovery/high availability, SQL upgrades and installation and DBA services. She has taught courses on SQL Server administration and performance tuning for many different companies. Lori has conducted numerous performance studies and has developed the methods and code used in SQLRx’s RemoteDBA offering. Ms. Brown has also published articles in SQL Server Magazine, contributed to SQLServerCentral.com and is a regular blogger on the SQLRx blog (blog.sqlrx.com)


Thank You to the 

PLATINUM

SPONSORS 

of our May 2018 

SQL Saturday!











Back to Top
cage-aids
cage-aids
cage-aids
cage-aids