Hampton Roads Sql Server User Group (HRSSUG)

Justin Randall

Session: Putting the “Squeeze” on Large Tables: Improve Performance and Save Space with Data Compression

Abstract: Your databases are growing faster than your servers. Large tables consume ever-increasing amounts of storage while putting a drag on query response time. What’s a DBA to do? The data compression feature of SQL Server is one tool DBAs can use to save storage space and improve performance. In this presentation you will learn about the types of data compression, how to determine when compression is the right option, and how to make the magic happen.

Our May meeting will feature a SQL DBA for 25+ yrs from the Richmond, VA USA area. Business Owner, Software Developer, with broad background in IT disciplines. SQL Server user since 6.0.

George Walkey

Session: Scripting out SQL Server for Documentation and Disaster Recovery

Abstract:  Most DBAs need to use multiple native and third party tools to fully document SQL Server instances yet still dont get all the objects. Even using Visual Studio and Database Projects, not all objects are exportable and live at the server level, above the database. Using Powershell, we will script out an organized set of files that can be checked into any Source Control system and or used for moving or recovering a SQL server instance for Disaster Recovery purposes. Objects exported include: SQL Agent Jobs/Alerts/Schedules, NT Service Credentials, SSIS-MSDB, SSIS-Catalog, SSAS Cubes, SSRS Reports, Logins, Server Configs, Linked Servers, DB Mail Operators/Accounts, and Server Triggers

Remember to sign up with Eventbrite by clicking the button on the side-bar. This will guarantee your entry into the various raffles and give-aways available.

Our April meeting will feature a well known author and Microsoft Certified Master, Wayne Sheffield.

SSMS Tips and Tricks

Almost everyone uses SSMS to write queries and to browse around on the server – but do you use all of the features that SSMS offers to increase your productivity? Come to this session, consisting mostly of demos, to see features built-in to SSMS that will improve your experience and productivity. Time permitting, we’ll also go into some 3rd party products that also increase your productivity in SSMS.

Remember to sign up with Eventbrite by clicking the button on the side-bar. This will guarantee your entry into the various raffles and give-aways available.

Our next meeting will be on March 18th. Jessica Moss, a local SQL Server MVP will be presenting on Business Intelligence features, new with SQL Server 2014.

Session: What’s New in the SQL Server 2014 Business Intelligence Suite?
Speaker: Jessica Moss
Abstract:
The Microsoft SQL Server business intelligence suite contains many new tools to help in your data warehousing. Deciding which on to use can be confusing if you’re first learning the toolset. This session will provide an overview of each new tool (Power Query, PowerPivot, Power View, Power Map, and Power BI Q&A) and explain when you would use each one. Soon, you too can answer the question of what is new in the SQL Server 2014 Business Intelligence Suite!

Remember to sign up with Eventbrite by clicking the button on the side-bar. This will guarantee your entry into the various raffles and give-aways available.

We’re excited for our next meeting, on February 18th. Remember to sign up with Eventbrite by clicking the button on the side-bar. This will guarantee your entry into the various raffles and give-aways available.

Speaker: Jamie Wick

Session: Automated SQL Server installation and configuration using PowerShell

Abstract: Using the SQL setup wizard and management studio (SSMS) to install and configure a new SQL server is a time-intensive process.  PowerShell scripts can greatly reduce the time required to complete the process.  They can also ensure build standardization throughout your SQL environment.  In this session we will look at PowerShell scripting, including the basic syntax and cmdlets needed to automate the installation and post-install configuration of a SQL Server.