SQL SERVER – Contest Post – Notes from the Field – Learning Performance Tuning and Database Health

One of the most appreciated and loved the series on SQLAuthority.com is Notes from the Field. I often received how did I come up with the idea behind it. Here is the story for the same.

Inceptions of Notes from the Field

SQL SERVER - Contest Post - Notes from the Field - Learning Performance Tuning and Database Health notesfromfield

There are two aspects of any technology 1) Theoretical Knowledge and 2) Practical Knowledge. I have been blogging over 7 years over here and over the years, I have shared my theoretical and practical knowledge over here on this blog. However, I am primarily contributor to my blog and hence there was a monotonous tone to this blog. I always wanted to bring the perspective of other Database Experts to the blog readers. In the real world, we have thousands of the servers deployed, and each server has its own stories to tell. When I have worked on performance tuning projects, I have realized that it is not possible to figure out everything by a single expert. When we have more than one opinion for any server, it helps us to figure out what is the best possible solution for that server. Following the same logic, I have decided to reach out to few of my fellow industry experts to help me write a series Notes from the Field.

Contest

Here are details of quick contest. We have so far published 16 different episodes of Notes from the Field. We believe each of them are extremely valuable and have lots of interesting information from the real world. We personally cannot decide which one is better than another, as they all are exceptional posts. With said that when we check the statistics of each of the blog post, we see different interest level for each of them. We decided to have a quick contest for all of you, which will help us to come up with better notes from the field.

Answer following question in the comments – What would you like to learn next in the Notes from the Field series?

One lucky winner will get USD 50 Amazon gift card. We will select lucky winner based on the random algorithm.

Roundup from Notes from the Field

My friends at Linchpin People are expert at Anything and Everything about SQL. You can reach out to them when you need an urgent care specialist for your database. If you believe your servers are healthy, that is a great thing, but it does not hurt to read the advice of the experts in their own words.

Here is the roundup from Notes from the Field. Each of the note is shared by experts at Linchpin People.

If you are busy with Christmas, I suggest you bookmark this post and read it later on in the new year.

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

Notes from the Field
Previous Post
SQLAuthority News – Two Whitepapers from AzureCAT Team on SQL Database
Next Post
MySQL – Profiler : A Simple and Convenient Tool for Profiling SQL Queries

Related Posts

7 Comments. Leave new

  • Thank you dear Pinal for this very informative Notes from the Field series.

    What I would like to learn next in the Notes from the Field series is around SQL Replication… (1- Database Replication from Site A to Site B through VPN) (2- Virtual Machine Replication specific in Hyper-V Replica).
    I often heard that when SQL replication is established (#1), the users in Site A experience slow performance and they cannot work, how to determine which Table is locked during SQL replication or which process is taking all the resources.

    Keep up this Notes series.

    Kind regards,
    Sharbel,

    Reply
  • Service Broker Troubleshooting

    Reply
  • Thanks for the Notes from the Field series. Its really interesting and informative. I would like to have notes on performance tool SQL Server Profiler.

    Reply
  • Thank you for this very useful blog, it has saved me more than once.

    For one of the next notes from the field, i’d like to see more on the Management Data Warehouse. You have talked about it in t-sql tuesday #5, but the problem remaining is the fast growth of the database due to the query stats collection.
    Is there a way to control the growth without having to turn off these statistics?

    Thanks again,
    Simon.

    Reply
  • I would like to get the expertise on AlwaysOn feature of SQL Server 2012. How it will work on failover scenarios and any performance-wise improvements?

    Reply
  • Thanks Pinal,

    I would like to learn from the field
    – Alwayson Feature
    – In Memory OLTP
    – SSAS and PowerPivot
    – High Availabilty Feature

    Regards,
    Pravin Patel.

    Reply

Leave a Reply