Archive | Next Meeting RSS feed for this section

November 27 – Andy Mallon – Demystifying Data Compression

Join us at the Roundabout Diner in Portsmouth for (RSVP): Demystifying Data Compression: SQL Server 2016 SP1 and newer makes data compression available in all editions. Data compression can reduce storage costs, and provide a performance boost—and now compression is available without the added cost of Enterprise Edition. Whether you are a developer or a […]

October 23 – Taiob Ali – Think Like the Cardinality Estimator

Join use at 5 Bedford Farms Drive, Suite 103, Bedford, NH for: Think like the Cardinality Estimator SQL Server uses a phase during query optimization, called cardinality estimation (CE). This process makes estimates bases on the statistics as to how many rows flow from one query plan iterator to the next.  Knowing how CE generates […]

September 25 – Gary Mazzone – Performing a Security Audit on SQL Server

Join us at the Roundabout Diner in Portsmouth for: Performing a Security Audit on SQL Server Why would you need to do a security audit?  Where do you find you find out what is expected?  Does your company have procedures and guidelines for access, removal of access?  What should you look at during an audit?  […]

August 28 – Mike Hillwig – Rewriting Your Checklist for SQL 2016 and Beyond

Join us at the Alpha Loft in Manchester, NH for (RSVP): Rewriting Your Checklist for SQL 2016 and Beyond How big should the page file be for Windows Server 2016? How many data files should have? What trace flags should we use by default now? These are questions you addressed long ago in your setup checklist. You’ve spent […]

July 24 – David Klee – Linux for the SQL Server DBA

Join us at the Roundabout Diner in Portsmouth for (RSVP): Linux for the SQL Server DBA Times are certainly changing with Microsoft’s recent announcement to adopt the Linux operating system with the SQL Server 2017 release, and you should be prepared to support it. But, what is Linux? Why run your critical databases on an […]

June 26 – Warren Estes – Powershell, it’s not just for sysadmins anymore!

Join us at the Alpha Loft in Manchester, NH for (RSVP): Powershell, it’s not just for sysadmins anymore!  Abstract: Are you tired of doing things the hard way? Are you still using sp_help_revlogin to migrate those pesky logins? In this session I will cover the basics of the IDE, cmdlets, syntax, piping, SMO and installing modules. Using real […]

May 22 – Grant Fritchey – Exploring the Azure SQL Data Warehouse

Please RSVP Join us at the Roundabout Diner in Portsmouth for: Exploring the Azure SQL Data Warehouse Managing and processing large amounts of data requires major investments in hardware and time, or, you can look to an appliance-style solution like Analytics Platform System (APS). However, APS requires a massive outlay of cash just to get started […]

April 24 – Mike Walsh – Migrating from On-Premise to Azure SQL DB

Join us at the Alpha Loft in Manchester, NH for: This is not a mistake, Mike did such a great job in Portsmouth we wanted to make sure the Manchester group got to hear this one too! Migrating from On-Premise to Azure SQL DB  Target Audience: Cloud curious DBAs and Developers who want to see an […]

March 27 – Mike Walsh – Migrating from On-Premise to Azure SQL DB

Join us at the Roundabout Diner in Portsmouth for: Migrating from On-Premise to Azure SQL DB  Target Audience: Cloud curious DBAs and Developers who want to see an example of building out a database environment. Abstract: You know about the cloud but you’re not there yet. Is it hard? Is it easy? How do you […]

March 27 – Gary Mazzone – Performing a Security Audit on SQL Server

Gary has to go out of town for work so his talk has been pushed back to a later date.  Instead we will have Mike Walsh taking about doing a Migration to Azure. You can see details here and RSVP here