Time: 4:30 PM
Location: Microsoft Office in Waukesha, WI
Does anyone know how many days it is ‘til spring? Did you notice how fast SQL Server is moving along now? Microsoft announced it will be bringing out a new version of SQL Server every twelve to eighteen months now rather than every three years.
Here are some discussion questions for our meeting this month?
1. Have you implemented SQL Server 2012 in production yet?
2. What are you using for userid for services in 2012?
3. Have you deployed always on clusters yet?
4. Have you begun studying SQL Server 2014 yet?
5. Did you implement Columnstore Indexes in SQL Server 2012?
I just completed a Pluralsight course called Optimizing OLTP and Data Warehousing with SQL Server 2014. It’s very interesting course dealing with Memory Optimized Tables and Clustered Columnstore Indexes. It’s a great way to gain an understanding of those two topics,
This month Steven Murawski is back with us again and of course going to broaden our horizons on the topics of PowerShell and how to use it with SQL Server. If you haven’t guessed by now, you will be using PowerShell if you haven’t already begun.
I know this presentation is going to be both interesting and valuable so be sure not to miss it, and bring your PowerShell questions with you. Steven has always been nice enough to answer mineJ.
I hope to see you all on Tuesday afternoon.
* Networking with your peers: Networking is the answer.
* WiSSUG Business: Is there anything you want to talk to your SQL Server peers about?
* Presentation by Steven Murawski
Getting to work with PowerShell and SQL Server PowerShell and SQL Server have an interesting history. SQL Server's native support for PowerShell is a bit lackluster (though it is improving). PowerShell's ability to work with SQL Server though is not the least bit hampered by this lack of official support. Thanks to PowerShell's reach into .NET, there are a number of ways that PowerShell can interact with SQL Server.
In this session, we'll dive into how we can connect into SQL Server, to query and to access management features. We'll look at some of the community tooling that can help with building, maintaining, and working with our SQL Server environment - SQLPSX (the SQL Server PowerShell Extensions), SPADE (Scripted PowerShell Automated Deployment Engine), SQL Power Doc (tooling to document and diagnose SQL Server instances and issues).
Steven also leads two local user groups, the Greater Milwaukee IT Pro User Community and the Greater Milwaukee Script Club. He speaks regularly to local user groups and can be found at various conferences.
Live Meeting information
Join the meeting.
To use computer audio, you need speakers and microphone, or a headset.
First Time Users:
To save time before the meeting, check your system to make sure it is ready to use Microsoft Office Live Meeting.
Unable to join the meeting? Follow these steps:
Microsoft Office Live Meeting can be used to record meetings. By participating in this meeting, you agree that your communications may be monitored or recorded at any time during the meeting.
Special thanks to our sponsors:
WiSSUG Sponsors Are the Best
Please support our sponsors with your patronage