Upgrade Roadmap: Taking you to R2
A Review of the upgrade process to SQL Server 2008 R2. A checklist of considerations for things a company would likely encounter coming from SQL Server 2000 or 2005. The Pros and Cons of in-place upgrades vs. the Build-out-new approach. There will also be some lessons learned sprinkled in as the presenter has personally led many upgrades and migrations of SQL Server. Key takeaways include: when to upgrade in place compared to build new, usage of and how to gauge the usefulness of Upgrade Advisor. Enterprise interfaces and stuff you will see in the real world, deprecated features and how to test for them
Networking for IT Pros 101: Let’s get it done!
Want to invest in your long term career success? You need to network. C’mon give it a try! It’s not that bad! This presentation will explain some in-person networking tips and some do’s and don’ts for networking on LinkedIn. Takeaways include:
– How to find events
– Tips on getting to most out of attending events
– How to develop and maintain your network of contacts
– A Review of Linkedin networking best practices and profile optimization strategies.
Upgrade Roadmap: Let’s delve into SQL Server 2012
We will review the upgrade process to SQL Server 2012. An upgrade is 75% project planning and 25% execution. Everyone knows that, right? Actually, no. A checklist of considerations a company would likely encounter coming from SQL Server 2005/2008 or R2. The pros and cons of in place upgrade vs. the build out new approach. There will be many real world lessons learned sprinkled in as the presenter has led many upgrades and migrations of SQL Server. Key takeaways include: when to upgrade in place compared to build new, usage of and how to gauge the usefulness of Upgrade Advisor, deprecated features and how to test for them
Technical Presentations: A soup to nuts guide
You CAN do it! Everyone has something to share. A how to guide to getting started developing technical presentations. We will cover how to pick an appropriate topic, building an outline, PowerPoint tips, and demo hazards. There will be many real life lessons learned as the presenter shares some of his story getting started and growing professionally. Finally, some ideas on how to find events willing to let you speak for the 1st time.
Database Mirroring in the Real World
Review of Database Mirroring in the context of operations in the real world. A high level look at the key modes of mirroring; specific analysis of setup and configuration problems; various real time monitoring techniques of the mirrored databases; discussion of the pros and cons of WAN hardware acceleration devices to improve performance; using mirroring to perform a rolling upgrades or to move large databases to a different location.
NoSQL- What is it and why do I care?
NoSQL (or, more correctly NoRel) is a moniker applied to a family of non-relational software systems for storing data that powers some of the largest sites on the Internet. Amazingly enough, non-relational database technology has been around a very long time. This session will include a high level discussion of some of the pros and cons of this technology compared to traditional systems like Oracle and SQL Server; as well as a survey of the most popular “NoSQL” platforms and who uses them. We will also cover a brief history of relational and non-relational databases as it is germane to the topic.
Making SQL Server and Active Directory Hold Hands
A discussion involving the various touch points between SQL Server and AD. ADSI and how you can run LDAP queries from within SQL Server to aid in user provisioning. A demonstration of how to write CLR stored procedures in C# to query and update (yes, that’s right) AD from within SQL Server.