Seacoast SQL Server Users Group

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

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

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