Another great SQL Saturday event in Columbus, OH. These events are well worth the time and there are always people to meet and new things to learn. Anybody you meet at SQL Saturday is passionate enough about what they do to spend a Saturday improving their skills. If you aren’t learning something new, you are falling behind.
Once again this year I planned my day then changed my schedule at the last minute after a conversation with a co-worker on Friday.
There were two great sessions on using service broker. This feature can be used for all sorts of tasks that need asynchronous data transfer. Want to move some data around in near real time but CDC or transactional replication seem to heavy? Service Broker to the rescue. Daily updates to your data warehouse are not frequent enough to meet the business need? Service Broker to the rescue.
Policy Based Management
I think database sprawl is an issue for a lot of companies. Providing documentation for audits is also an issue for many companies as well. If the instances are 2008 or newer Policy Based Management can help solve those problems. The documentation on this feature is a little thin but the presenter provided some good resources that fill the gap.
ApexSQL – I will have to admit, I didn’t know what ApexSQL was but I do now. It has a set of tools for developers and DBAs. Features such as schema compare, data compare, and the ability to mount a transaction log and view/modify transactions.
Confio Ignite – I was aware of Ignite but I did not know it could monitor SQL Server and Oracle from the same dashboard. I also learned it could detect VMWare Vmotion events and provide visibility into host and the other guests that are on it. Confio was purchased by Solarwinds and the Ingnite product will change names in the future.
Not up to speed with always on? There is a session for that.
Don’t know anything about on Hadoop? There is a session for that.
What are the pros and cons of SQL 2014 in-memory tables? There is a session for that.