Seacoast SQL Server Users Group

RSVP An introduction to AlwaysOn Availability Groups Rahul Deshmukh will discuss SQL Server 2012/2014 AlwaysOn Availability Groups, the flagship High Availability and Disaster Recovery (HADR) solution that Microsoft SQL Server offers. He will demonstrate how you can create a SQL Server 2014 AlwaysOn Availability Group. He will also provide insights into how the data synchronization [...]

RSVP I Hired the Devil and Lived: Getting Things Done with .NET CLR in SQL Server Microsoft introduced .NET Common Language Runtime (CLR) in SQL Server 2005. Since that time, there is still a great deal of misinformation, confusion, and head-scratching about it: • What does it do that T-SQL either can’t do or does [...]

RSVP Writing Faster T-SQL Stored Procedures and Functions Stored procedures and functions are the mainstay of SQL Server coding. In this session you will learn techniques to locate problematic code and to improve the performance of procedures and functions. Step one is to discover where the time is going using standard, DMVs, server traces, code [...]

Treating Tables Like Legos, Partitioning Basics Partitioning allows us to isolate parts of our table as small chunks called partitions. In turn, these partitions allow us to do some really cool tricks for manageability and performance. In this session we’ll look at the concepts surrounding partitioning and how we can apply them. We’ll reinforce what [...]

T4 templating support was added in the March 2014 release of SSDT. This means we can now create a T4 template to automatically create CRUD procedures for all the tables in our database project. Sure ORM tools like EF and nHibernate can handle CRUD operations in code, but if you want to provide an API [...]

How are your servers running? What is going on in your SQL Server? How are you trending? When will you need the next server? Do you need to throw more hardware at SQL or more query tuning? (Or both?) In this session – SQL Server Consultant, Mike Walsh from Linchpin People will share some free [...]

Join us at the Roundabout Diner at 6:30 for networking and then our featured presentation by Friend of Red Gate, Mike Taber Get your Database Development under Control with SQL Source Control Chances are, you and your team use version control for your applications. Wouldn’t it help to have a change management process for your [...]

Join us at the Roundabout Diner at 6:30 for networking and then our featured presentation by group member, Chris Seferlis Scratching the surface: An overview of SSRS and building your first BI Report Every business needs to turn their data into actionable information. Microsoft provides SSRS as one of the tools to provide that functionality. [...]

Join us at the Roundabout Diner at 6:30 for networking and then our featured presentation by group member, Gary Mazzone Backup and Recovery Explained We all know that we need to backup data but do we understand what that means? What are the proper backups that need to be performed? What are you expectations or [...]

Join us at the Roundabout Diner at 6:30 for networking and then our featured presentation by group member, Jack Corbett Introduction to Extended Events XEvents were introduced with SQL Server 2008 and enhanced in SQL Server 2012 and with the announcement that SQL Trace/Profiler is being deprecated now is the time to begin learningXEvents. We [...]