Seacoast SQL Server Users Group

Join use somewhere in or near Manchester (location TBD because we have lost our Manchester Location) 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 […]

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?  […]

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 […]

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 […]

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 […]

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 […]

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 […]

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 […]

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

Join us at AlphaLoft, 844 Elm Street, Manchester, on Monday, February 27 6:30 for: Using Biml as an SSIS Design Patterns Engine Perhaps you’ve heard the buzz about Business Intelligence Markup Language (Biml) and wondered, “Why is everyone so excited about Biml?” Occasionally, a new technology emerges that changes everything. For SSIS developers, Biml is […]