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)

About these ads

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)

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)

SQLAuthority News – Presenting 3 Session at SQL Server Live, Orlando, Florida

Performance tuning is my favorite subject and I totally enjoy presenting on this subject. I will be presenting 3 sessions at SQL Server Live at Orlando, Florida which are related to SQL Server Performance Tuning. Here is the abstract of the session.

SQT10 “What Did I Do?” T-SQL Worst Practices

11/19/2013 2:00pm – 3:15pm
Level: Introductory to Intermediate

“Oh My God! What did I do?” Chances are you have heard, or even uttered, this expression. This demo-oriented session will have many examples where developers were dumbfounded by their own mistakes. The goal of this session is to learn which small details can be dangerous to the production environment and SQL Server as a whole. We will talk about common bad habits and how to avoid them. There is good chance you will remember your early days during the session. Learning some of these tricks may save your current job.

SQW12 Ancient Problems and Modern Solutions – Troubleshooting CPU

11/20/2013 1:45pm – 3:00pm
Level: Introductory to Intermediate

This is the session for you to attend. Many believe Performance Tuning and Troubleshooting is an art which has been lost in time. The truth is that art has evolved with time and there are more tools and techniques to overcome ancient troublesome scenarios. In this session we will focus on High CPU scenarios detection and their resolutions. At the end of the session you will have clear ideas and action items regarding what to do when facing any of the above resource intensive scenarios.

SQW04 Database Performance Tricks Every SharePoint Admin Must Know

11/20/2013 9:15am – 10:30am
Level: Introductory to Intermediate

This session is for all the SharePoint Professionals who want their server to perform at blazing fast speed but want to invest very little time to make it happen. We will go over various database tricks which require absolutely no time to master and practically no SQL coding at all. After attending this session, Developers will only need 60 seconds to improve performance of their database server in their SharePoint implementation.

Looking forward to see you soon!

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

SQLAuthority News – 7th Anniversary of Blog – A Personal Note

Special Day

Today is a very special day – seven years ago I blogged for the very first time.  Seven years ago, I didn’t know what I was doing, I didn’t know how to blog, or even what a blog was or what to write.  I was working as a DBA, and I was trying to solve a problem – at my job, there were a few issues I had to fix again and again and again.  There were days when I was rewriting the same solution over and over, and there were times when I would get very frustrated because I could not write the same elegant solution that I had written before.  I came up with a solution to this problem – posting these solutions online, where I could access them whenever I needed them.  At that point, I had no idea what a blog was, or even how the internet worked, I had no idea that a blog would be visible to others.  Can you believe it?

Google it on Yahoo!

After a few posts on this “blog,” there was a surprise for me – an e-mail saying that someone had left me a comment.  I was surprised, because I didn’t even know you could comment on a blog!  I logged on and read my comment.  It said: “I like your script,but there is a small bug.  If you could fix it, it will run on multiple other versions of SQL Server.”  I was like, “wow, someone figured out how to find my blog, and they figured out how to fix my script!”  I found the bug, I fixed the script, and a wrote a thank you note to the guy.  My first question for him was: how did you figure it out – not the script, but how to find my blog?  He said he found it from Yahoo Search (this was in the time before Google, believe it or not).

From that day, my life changed.  I wrote a few more posts, I got a few more comments, and I started to watch my traffic.  People were reading, commenting, and giving feedback.  At the end of the day, people enjoyed what I was writing.  This was a fantastic feeling!  I never thought I would be writing for others.  Even today, I don’t feel like I am writing for others, but that I am simply posting what I am learning every day.  From that very first day, I decided that I would not change my intent or my blog’s purpose.

72 Million Views – 2600 Posts – 57000 comments – 10 books – 9 courses

Today, this blog is my habit, my addiction, my baby.  Every day I try to learn something new, and that lesson gets posted on the blog.  Lately there have been days where I am traveling for a full 24 hours, but even on those days I try to learn something new, and later when I have free time, I will still post it to the blog.  Because of this habit, this blog has over 72 millions views, I have written more than 2600 posts, and there are 57,000 comments and counting.  I have also written 10 books, 9 courses, and learned so many things.  This blog has given me back so much more than I ever put it into it.  It gave me an education, a reason to learn something new every day, and a way to connect to people.  I like to think of it as a learning chain, a relay where we all pass knowledge from one to another.

Never Ending Journey

When I started the blog, I thought I would write for a few days and stop, but now after seven years I haven’t stopped and I have no intention of stopping!  However, change happens, and for this blog it will start today.  This blog started as a single resource for SQL Server, but now it has grown beyond, to Sharepoint, Personal Development, Developer Training, MySQL, Big Data, and lots of other things.  Truly speaking, this blog is more than just SQL Server, and that was always my intention.  I named it “SQL Authority,” not “SQL Server Authority”!  Loudly and clearly, I would like to announce that I am going to go back to my roots and start writing more about SQL, more about big data, and more about the other technology like relational databases, MySQL, Oracle, and others.  My goal is not to become a comprehensive resource for every technology, my goal is to learn something new every day – and now it can be so much more than just SQL Server.  I will learn it, and post it here for you.

I have written a very long post on this anniversary, but here is the summary: Thank You.  You all have been wonderful.  Seven years is a long journey, and it makes me emotional.  I have been “with” this blog before I met my wife, before we had our daughter.  This blog is like a fourth member of the family.  Keep reading, keep commenting, keep supporting.  Thank you all.

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

SQL SERVER – Download SQL Server Developer Edition 2012 for USD 60

SQL Server professionals often send me email asking about where can they download the full version of SQL Server for their own development. Microsoft only provides evalution version of its enterprise software (full version). The evaluation version is bound by time and it expires when the time trial is over. This does not work out well when developers want to install the SQL Server into their local machine and try out various features of SQL Server. Additionally, many organizations when they are developing an application do not purchase a full version of the SQL Server. They often prefer to install a free version of the SQL Server and utilize that.

Microsoft does have Express Edition for free but there are many limitations to the product. Additionally, the Express Edition does not have all the features which any enterprise would love to have. Unfortunately Microsoft does not have a full version of SQL Server for developers. However, one can for sure purchase SQL Server Developer Edition for USD 59.95 from Microsoft store. It includes all the functionality of the Enterprise edition, but is licensed for use as a development and test system, not as a production server. SQL Server Developer is an ideal choice for people who build and test applications.

Remember you can’t use this version in your production server but it is a great product to test out various new SQL Server Features.

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