Seacoast SQL Server Users Group

We are moving to Meetup.  Please go join the SeacoastSQL User Group meetup to stay up to date with the group.  Making the move to Meetup makes all the administrative tasks simpler as the meeting pages, member management, communication, and RSVP handling will all be in one place.  We currently have 3 places where we do […]

Join us at the Roundabout Diner in Portsmouth (RSVP) for: Destination Azure… building ETL workloads in the cloud! More and more of our data is originating from or being moved to the cloud, but many of us are doing the same old ETL process with SSIS and other tools. In this session, we will compare […]

Join use at 5 Bedford Farms Drive, Suite 103, Bedford, NH for: Modern Security Attack Vectors Against SQL Server Environments Today’s attacks are getting smarter, sneakier, and more dangerous than ever. In this session, we are going to discuss the different vectors the bad guys are using today to gain access to SQL Server environments. Credential theft […]

Join us at the Roundabout Diner in Portsmouth (RSVP) for: It’s All about the Rules: A Dynamic ETL Architecture You are provided with requirements for an ETL Process that has hundreds of rules that need to be applied and you code them all and during testing some rules change and more are added requiring you […]

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