SQL SERVER – Looking Forward to Meeting you at SQLPASS 2015

SQL SERVER - Looking Forward to Meeting you at SQLPASS 2015 sqlpass If you are going to at SQLPASS 2015, Seattle, I am looking forward to meet you. I will be there and presenting two technology sessions.

Here are the details of my sessions. I will be very happy if you are at SQLPASS and attend my session. If you see me at SQLPASS, just do not hesitate to stop me as I would for sure like to talk to you and shake your hands.

During this event, I will be actively tweeting about where exactly I am and how can you reach me. Do not forget to follow me on twitter.

42 Tips to Performance Tuning, Optimization, and Everything

Monday, Oct 26, 2015 08:30 AM- 04:30 PM
This demo-oriented, full-day pre-conference session answers the questions that database administrators (DBAs) and developers often have about performance tuning and query optimization. Some problems have straightforward answers, but others are often invisible or need attention without even a problem statement. This session is divided into these three major components:
– Identify common patterns and antipatterns for database performance tuning; for example, slow-running queries, I/O-intensive operations, CPU bottlenecks, memory optimizations, tempdb contention, and more
– Resolve optimization hindrances and issues proactively; for example, indexing strategies, file growths, server deployment best practices, statistics, wait stats and queues, and more
– Avoid query performance surprises when upgraded to the most recent version of SQL Server 2014; for example, new cardinality engine, ColumnStore indexes best practices, live plans, Azure enhancements, in-memory online transaction processing (OLTP) optimizations, and more

We discuss 42 tips, tricks, and scripts in this session. Every attendee will have those scripts handy upon completion of the session.

Secrets of SQL Server: Database Worst Practices

Wednesday, Oct 28, 2015 10:15 AM – 11:30 AM
“Oh no–what have I done?” Chances are you have heard, or even uttered, these words. This demo-oriented session shows many examples in which database pros have been dumbfounded by their own mistakes. It might even bring back memories of your own early DBA days. This session exposes the small details that can be dangerous to the production environment and SQL Server as a whole and talks about worst practices and how to avoid them. The session focuses on common errors and their resolution. Developers will walk out with scripts and knowledge that they can immediately apply to their own servers.

SQL SERVER - Looking Forward to Meeting you at SQLPASS 2015 space

Reference: Pinal Dave (https://blog.sqlauthority.com)

Previous Post
SQL SERVER – Strange SQL Transaction called UpdateLoginStats
Next Post
SQL SERVER – Script Upgrade Mode on Failover – Why?

Related Posts

3 Comments. Leave new

  • Imran Mohammed
    October 15, 2015 7:35 am

    I would love to come just to spend some casual time, but its way too costly.

    All these speakers have blogs, and they discuss pretty much all topics on their blogs. Why do people spend $2500 on these summits. Just to see speakers F2F? Whats the advantage of attending these summit’s? I really cant laugh at those silly jokes, I have tried many times and I failed horribly.

    Registration Fees + Hotel expenses + Food expenses for 5 days+ Travelling cost + 5 days Loss of pay, that is your 1 month salary.

    Doesn’t make much sense to me at-least. Others might disagree. I don’t see any value attending these except for fun and if someone wants to pay this much just for fun? In a (SQL) community exceeding 1 Million individuals, I see only 5000 + smart people chose to attend this event last year.

    Reply
  • Can’t wait!

    I’m going to be there from Italy!

    See you soon!

    Reply

Leave a Reply

Menu