SQL SERVER – Three Questions – Do You Know Your Servers? – Book Gift

It has been almost 2 years since we had a poll on this blog so here a poll which ask you three simple questions. Trust me these questions, I have carefully picked after doing a beta testing on a small group of people. It was very intriguing to see that not everyone knows the answer to these simple questions. When I asked the users to answer these questions and later on asked to find out the real number they were extremely surprised to see that their estimate and answer were way off to the reality. Let us do this exercise together.

The contest has two parts. You need to take part in the both the contest.

Part 1:Answer following questions

Click here to take survey

Part 2: Subscribe to our infrequent newsletter

Click here to subscribe to the newsletter.

If you are already subscribed to the newsletter, you have already completed this second part.

The winner will be announced on Monday 21st April via Newsletter only.

The winner will get a very inspiring book which I have been reading recently – Drive: The Surprising Truth about What Motivates us by Daniel Pink (Amazon | Flipkart).

Reference: Pinal Dave (http://blog.SQLAuthority.com)

About these ads

SQLAuthority News – Microsoft Whitepaper – Idle Connection Resiliency

Developers can write data access application that enables ideal connection resiliency with the .NET framework. An idle connection is the one that is active but it’s not executing a command or waiting for data. It is very important to understand how idle connection is reconnecting back in the .NET framework with SQL Server. This white paper actually discusses the same in very simple works. The user has to connect either to a SQL Server 2014 or Microsoft Azure, SQL Database to enable idle connection resiliency.

Here is a very interesting example in the of the idle connection resiliency provided in the Overview section of the Whitepaper.

Let’s imagine that you are a roaming worker that needs to use an Access application to connect to SQL Server.  When you need to move from meeting to meeting, you normally close your notebook’s lid in order to move.  In working online, every time this happens, you may end up disconnected either because your notebooks sleep or due to blind wireless spots in your building.  To avoid the hassle of being disconnected, you may choose to avoid certain places (like elevators, for example) and walk with your notebook’s lid open. Now, imagine if you can close your lid and walk anywhere in your building (even take the elevator) and just arrive to your next meeting, open your lid and find your work there, waiting for you to continue.  To  address this and other scenarios when an idle connection drops, SQL Server introduced a new feature called Idle Connection Resiliency.

Well, that’s it. This white paper describes the internal working of the Idle Connection Resiliency. It further discusses about the Client’s idle connection, reconnect logic, Client session state handling and replay logic, Non-recoverable session states, and General Considerations.

Click here to read the white paper on Idle Connection Resiliency.

Reference: Pinal Dave (http://blog.SQLAuthority.com)

SQLAuthority News – Speaking at C-Sharp Corner Annual Conference 2014 – April 11-13 – Delhi

I will be speaking at C-Sharp Corner Annual Conference 2014 – April 11-13 – Delhi. I am extremely excited and fortunate with the opportunity to present a technical session at the North India’s largest conference. The wonderful people at the conference has been doing this annual event for quite a few years and every year there are over thousands of attendees from all over the India attending it. C# Corner ANNUAL CONFERENCE is a 3 day annual meeting where C# Corner mentors, authors, chapter leaders, moderators, editors and experts meet, demonstrate, plan and hang out. One day of the conference is open to C# Corner members (this is when I am going to present technical session). There are only five days left for this extremely popular conference of India.

Here are the details of the technical session I am going to present:

Secrets of SQL Server: Database Worst Practices
Date and Time: April 12, 2014 9:45-10:30 AM
Abstract: “Oh my God! What did I do?” Chances are you have heard, or even uttered, this expression. This demo-oriented session will show many examples where database professionals were dumbfounded by their own mistakes, and could even bring back memories of your own early DBA days. The goal of this session is to expose the small details that can be dangerous to the production environment and SQL Server as a whole, as well as talk about worst practices and how to avoid them. Shedding light on some of these perils and the tricks to avoid them may even save your current job. After attending this session, Developers will only need 60 seconds to improve performance of their database server in their SharePoint implementation. We will have a quiz during the session to keep the conversation alive. Developers will walk out with scripts and knowledge that can be applied to their servers, immediately post the session. Additionally, all attendees of the session will have access to learning material presented in the session.

Indexes – The Unsung Hero
Date and Time: April 12, 2014 1:30-2:15 AM
Abstract: Slow Running Queries  are the most common problem that developers face while working with SQL Server. While it is easy to blame the SQL Server for unsatisfactory performance, however the issue often persists with the way queries have been written, and how Indexes has been set up. The session will focus on the ways of identifying problems that slow down SQL Server, and Indexing tricks to fix them. Developers will walk out with scripts and knowledge that can be applied to their servers, immediately post the session.

The event venue is Radisson Blu Hotel Ghaziabad. H3, Sector 14. Kaushambi Ghaziabad 201010 Uttar Pradesh. You do not want to miss out on any of the sessions. I will have surprise gifts for selected attendees. I will ask some question during the session and if you get it right, trust me, you will be extremely happy with the gift.

Registration for this event has been closed and there are over 2100 registered attendees to this event. It is a FREE event so there is no cost to attend this event.

I am looking forward to catch up with you at the event. Special mention to the team who is making this event a huge success: Mahesh, Dhananjay, Praveen, Dinesh! 

Reference: Pinal Dave (http://blog.SQLAuthority.com)

SQLAuthority News – 4 Whitepapers on Windows Azure

Windows Azure is getting quite a lot of traction in the industry and I often get questions about if there is authentic learning on this subject. Microsoft has published following 4 white paper which covers many interesting topics related to SQL Server and Windows Azure.

Application Patterns and Development Strategies for SQL Server in Windows Azure Virtual Machines
You can develop many types of n-tier applications by separating the components of the different application tiers on different machines as well as in separate components. This article explains different application patterns to use for your SQL Server based applications in Windows Azure environment. In addition, the article discusses Windows Azure specific development strategies so that you can design your applications correctly.

Deploy SQL Server Business Intelligence in Windows Azure Virtual Machines
This article describes and walks you through the creation of a multi-server deployment of SQL Server Business Intelligence features, in a Windows Azure Virtual Machines environment. The document focuses on the use of Windows PowerShell scripts for each step of the configuration and deployment process.

How to backup and restore Windows system disk in a Windows Azure IaaS
A comparison of different methods of backup and restore in an IaaS environment.

Performance Guidance for SQL Server in Windows Azure Virtual Machines
This article discusses the key factors to consider when evaluating performance and planning a migration to SQL Server in Windows Azure Virtual Machines. It also provides certain best practices and techniques for performance tuning and troubleshooting when using SQL Server in Windows Azure Infrastructure Services.

All the taxt is from MSDN.

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

MySQL – MySQL Query Optimization and Performance Tuning – Online Video Courses

In year 2013, I had focused on MySQL along with SQL Server in database products. As I learn more and more MySQL, I quickly realized that there is no proper course or structured information for MySQL Performance Tuning.  I had decided to build a course around common MySQL Performance Problems. I have decided to build the performance tuning course in two parts. 1) MySQL Indexing for Performance and 2) MySQL Query Optimization and Performance Tuning. I had released MySQL Indexing for Performance course earlier this year and right before the end of the year 2013 the second course MySQL Query Optimization and Performance Tuning has released as well.

MySQL Query Optimization and Performance Tuning

Performance is one of the most essential aspects of any application. Everyone wants their server to perform optimally and at the best efficiency. In this course we will understand the basics of query optimization and look at practical tips and tricks for performance tuning.

Here is the broad outline of the course MySQL Query Optimization and Performance Tuning.

Introduction

In this module we go over why MySQL Performance Tuning is different from other database products. We also explained with the help of few interesting analogies where exactly we should look into when there is a problem with MySQL Performance.

Optimizing Data Access

We cannot directly jump into performance tuning before taking care of a few of the best practices around MySQL. In this module we discuss few of the best practices which one must implement various techniques explained in this course.

In this module we will see the following topics in depth:

  • Understanding Data Needs
  • Demo: Setup
  • Demo: Best Practices for Data Access
  • Demo: Why SELECT Star (*) is a Bad Idea

Understanding MySQL Query Optimization

It is very important to understand the internals of the car if we are going to participate in a car race. Similarly it is important to understand what is under MySQL Query Engine if we are going to do query optimization with MySQL.

In this module we will see the following topics in depth:

  • Execution Path of a Query
  • Client Protocols
  • Query Cache
  • Parser
  • Preprocessor
  • Query Optimizer
  • Query Optimizer Responsibilities
  • Query Optimizer Limitations
  • Query Execution Engine and Storage
  • Returning Result to Client
  • Additional Notes on Query Optimizer
  • Maximizing Query Optimizer Performance
  • Understanding Query States
  • Demo: Show Full Processlist
  • Understanding Explain Command
  • Demo: Explain Command
  • Demo: Explain Extended Command

Performance Optimization by Practical Query Tuning

In the real world we get thousands of the different scenario where the performance of our query is not upto the mark. In this module we will discuss the most common query patterns which reduces the performance of any query. In this demo oriented session we will also understand how we can tune the performance of bad query with the help of query rewrite and by implementing performance best practices.

In this module we will see the following topics in depth:

  • Demo: Index Used for SELECT clause
  • Demo: One Complex Query vs Multiple Simple Queries
  • Demo: One Complex Query vs Multiple Simple Queries – Part 2
  • Demo: One Complex Query vs Multiple Simple Queries with Index
  • Demo: Table Order in Join Clause – INNER JOIN
  • Demo: Table Order in Join Clause – OUTER JOIN
  • Demo: Most Optimal Choice – Subquery vs Exists vs Joins
  • Demo: Most Optimal Choice – Subquery vs Exists vs Joins – Part 2
  • Demo: Tuning Aggregate Function
  • Demo: Optimizing Group By Clause
  • Demo: Optimizing Paging with LIMIT Clause
  • Demo: Impact on Performance of UNION and UNION ALL
  • Demo: Index and Not Equal to Operator

Best Practices

In this final module we sum up the course in the format of Best Practices. Though the length of this module is short, it contains some really good gem inside it.

You need a valid Pluralsight subscription to watch the courses. You can sign up for free trial as well.

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

SQLAuthority News – Notes from SQLLive 360 – Orlando, Nov 2013 – A Great Experience

Earlier I wrote about my 3 technical session at SQL Live in the event at Orlando, Florida in Nov19-20, 2013. I had a great time presenting at the SQL Live event. I presented following three sessions at the event Presenting 3 Session at SQL Server Live, Orlando, Florida.

  • SQT10 “What Did I Do?” T-SQL Worst Practices
  • SQW12 Ancient Problems and Modern Solutions – Troubleshooting CPU
  • SQW04 Database Performance Tricks Every SharePoint Admin Must Know

I have been to Florida before but it was my first time visiting Orlando and I enjoyed every bit of it. The event was very well organized and attendees were extremely energetic. Every session was very well received. The best part was every session was about 1 hour & 15 minutes and there was enough time between two of the sessions. The break between session provided ample time for attendees and speaker to network among themselves.

Here are the few photos from the event.

Pinal at SQLLive

Great Audience at SQLLive

Pinal at SQLLive

Round Table of Performance Tuning

I had a great time with Aaron Blackner at Pluralsight booth

Pinal presenting at SQLLive

Pinal presenting at SQLLive sporting Pluralsight Vision

Audience gathered for Pluralsight Giveaway

Hard Rock Cafe at Orlando, Florida

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

SQL – Everything about Data Magazine – FREE to Subscribe

Print media is gradually fading out as we are moving to the new exciting world of digital gadgets. I have seen quite a lot of friends who used to tell me that they will never buy kindle or ebook reader as they do not like reading electronically. However, the same set of people I have seen now a days sporting kindle or flipping electronics magazine in their smart phones.

I have been blogging for almost 7 years and I have been enjoying every bit of the blogging. I have written so far 10 books and I am quite happy with the amount of the writing I have done in the recent times. One of the very popular request, I often encounter why not build a magazine from all the writing I have been doing. I have been avoiding this idea for a quite a long time as I wanted to focus on blogging and quality writing. I also believed that users want to read quality fun articles from every good resource and not only from me. I really wanted to make sure that I get the best articles out there in the world and include in my magazine as well. Now due to copyright issues, it is not possible at all. This was the major issue, why I stayed away from magazines.

I wanted following qualities in my magazine:

  • FREE
  • Responsive web design
  • Easy to read on any device (Mobile, Web, eReader, older browsers)
  • Flexibility to change cover page and content any time
  • Support for any kind of web element (video, blog, articles, images, sound or anything you can think of)
  • Easy to include a antibodies article without violating their copy-writes
  • Social media enabled

Finally, I have found the solution and I am incredibly proud to present you the SQL Authority magazine.

The link to the magazine is http://mag.SQLAuthority.com (please bookmark it). You can also download the clipboard app and read this on your mobile devices. I am eagerly waiting for your experience with the magazine. Please leave a comment with your suggestions and feedback.

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