SQLAuthority News – Presented 3 Technical Session at Great Indian Developer Summit 2015

GIDS Website Logo SQLAuthority News   Presented 3 Technical Session at Great Indian Developer Summit 2015Great Indian Developer Summit is my favorite technology event and I have been extremely happy to present technology sessions here for over 5 years. Just like every year, this year, I presented three technology session on SQL Server 2014. This time the event was at two locations. First one is Bangalore and the second one is in Hyderabad.

If you did not attend the event, I suggest you sign up for my newsletter as I will be sending all the scripts, demos for this event in email over here. The event organizer is not planning to record the sessions.

GIDS%20(1) SQLAuthority News   Presented 3 Technical Session at Great Indian Developer Summit 2015

Performance in 60 Seconds – SQL Tricks Everybody MUST Know

Date and Time: APRIL 21, 2015 14:00-15:00
Location: J. N. Tata Auditorium, National Science Symposium Complex (NSSC), Sir C.V.Raman Avenue, Bangalore, India

Data and Database is a very important aspect of application development for businesses. Developers often come across situations where they face a slow server response, even though their hardware specifications are above par. This session is for all the Developers 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 require 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 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.

GIDS%20(2) SQLAuthority News   Presented 3 Technical Session at Great Indian Developer Summit 2015

Troubleshooting CPU Performance Issue for SQL Developers

Date and Time: APRIL 21, 2015 17:30-18:30
Location: J. N. Tata Auditorium, National Science Symposium Complex (NSSC), Sir C.V.Raman Avenue, Bangalore, India

Developers are in the most challenging situations when they see CPU running 100%. There are many solutions of this situation, but there is very little time to implement those solutions. In this critical situation developers need a sure solution which gives stability to their system and buys more time to troubleshoot the problem. Many believe Performance Tuning and Troubleshooting is an art which has been lost in time. The truth is that art has evolved with the time and there are more tools and techniques to overcome ancient troublesome scenarios. There three major resource when bottlenecked creates performance problem: CPU, IO, and Memory. In this session we will focus on some of the common performance issues and their resolution. If time permits we will cover other performance related tips and tricks. At the end of the session attendee will have clear ideas and action items regarding what to do in when facing any of the above resource intensive scenarios.

GIDS%20(3) SQLAuthority News   Presented 3 Technical Session at Great Indian Developer Summit 2015

SQL Server 2014 – A 60 Minutes Crash Course

Date and Time: APRIL 25, 2015 09:55-10:55
Hyderabad Marriott Hotel & Convention Centre, Tank Bund Road, Opposite Hussain Sagar Lake, Hyderabad, India

Every new release of SQL Server brings a whole load of new features that an administrator can add to their arsenal of efficiency. SQL Server 2014 has introduced many new features. In this 60 minute session we will be learning quite a few of the new features of SQL Server 2014. Here is the glimpse of the features we will cover in this 60 minute session.

GIDS%20(4) SQLAuthority News   Presented 3 Technical Session at Great Indian Developer Summit 2015

  • Live plans for long running queries
  • Transaction durability and its impact on queries
  • New cardinality estimate for optimal performance
  • In-memory OLTP optimization for superior query performance
  • Resource governor and IO enhancements
  • Columnstore indexes and performance tuning
  • And many more tricks and tips

GIDS%20(5) SQLAuthority News   Presented 3 Technical Session at Great Indian Developer Summit 2015

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. This one hour will be the most productive one hour for any developer who wants to quickly jump start with SQL Server 2014 and its new features.

GIDS%20(6) SQLAuthority News   Presented 3 Technical Session at Great Indian Developer Summit 2015

Remember – do not worry if you can’t attend the event. Just subscribe to newsletter and I will share all scripts and slides in the email right after the event.

GIDS%20(7) SQLAuthority News   Presented 3 Technical Session at Great Indian Developer Summit 2015

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

SQLAuthority News – Presenting 3 Technology Session at GIDS 2015

GIDS Website Logo SQLAuthority News   Presenting 3 Technology Session at GIDS 2015Great Indian Developer Summit is my favorite technology event and I have been extremely happy to present technology sessions here for over 5 years. Just like every year, this year, I will be presenting three technology session on SQL Server 2014. This time the event is at two locations. First one is Bangalore and the second one is in Hyderabad.

If you are able to attend this event in person – do show up in my session as I will have some goodies to share. Here is the link to the website of the event. If you are not going to be in an event, I suggest you sign up for my newsletter as I will be sending all the scripts, demos for this event in email over here. The event organizer is not planning to record the sessions.

Performance in 60 Seconds – SQL Tricks Everybody MUST Know

Date and Time: APRIL 21, 2015 14:00-15:00
Location: J. N. Tata Auditorium, National Science Symposium Complex (NSSC), Sir C.V.Raman Avenue, Bangalore, India

Data and Database is a very important aspect of application development for businesses. Developers often come across situations where they face a slow server response, even though their hardware specifications are above par. This session is for all the Developers 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 require 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 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.

Troubleshooting CPU Performance Issue for SQL Developers

Date and Time: APRIL 21, 2015 17:30-18:30
Location: J. N. Tata Auditorium, National Science Symposium Complex (NSSC), Sir C.V.Raman Avenue, Bangalore, India

Developers are in the most challenging situations when they see CPU running 100%. There are many solutions of this situation, but there is very little time to implement those solutions. In this critical situation developers need a sure solution which gives stability to their system and buys more time to troubleshoot the problem. Many believe Performance Tuning and Troubleshooting is an art which has been lost in time. The truth is that art has evolved with the time and there are more tools and techniques to overcome ancient troublesome scenarios. There three major resource when bottlenecked creates performance problem: CPU, IO, and Memory. In this session we will focus on some of the common performance issues and their resolution. If time permits we will cover other performance related tips and tricks. At the end of the session attendee will have clear ideas and action items regarding what to do in when facing any of the above resource intensive scenarios.

SQL Server 2014 – A 60 Minutes Crash Course

Date and Time: APRIL 25, 2015 09:55-10:55
Hyderabad Marriott Hotel & Convention Centre, Tank Bund Road, Opposite Hussain Sagar Lake, Hyderabad, India

Every new release of SQL Server brings a whole load of new features that an administrator can add to their arsenal of efficiency. SQL Server 2014 has introduced many new features. In this 60 minute session we will be learning quite a few of the new features of SQL Server 2014. Here is the glimpse of the features we will cover in this 60 minute session.

Live plans for long running queries
Transaction durability and its impact on queries
New cardinality estimate for optimal performance
In-memory OLTP optimization for superior query performance
Resource governor and IO enhancements
Columnstore indexes and performance tuning
And many more tricks and tips
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. This one hour will be the most productive one hour for any developer who wants to quickly jump start with SQL Server 2014 and its new features.

Remember – do not worry if you can’t attend the event. Just subscribe to newsletter and I will share all scripts and slides in the email right after the event.

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

SQLAuthority News – Presented on Database Worst Practices at SQL Live, Orlando – November 29, 2014

Earlier last month, I had the opportunity to present at SQL Live 2014. The event was held in Orlando in November 2014. I had a great time attending this event and I presented on the topic Database Worst Practices on November 21, 2014.

sqllive SQLAuthority News   Presented on Database Worst Practices at SQL Live, Orlando   November 29, 2014

Here is the title and abstract of the session, which I had presented at SQL Live.

sqllive1 SQLAuthority News   Presented on Database Worst Practices at SQL Live, Orlando   November 29, 2014

Secrets of SQL Server: Database Worst Practices

Abstract: 

sqllive2 SQLAuthority News   Presented on Database Worst Practices at SQL Live, Orlando   November 29, 2014

“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.

sqllive3 SQLAuthority News   Presented on Database Worst Practices at SQL Live, Orlando   November 29, 2014

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 after the session.

sqllive4 SQLAuthority News   Presented on Database Worst Practices at SQL Live, Orlando   November 29, 2014

The session was extremely well received as I had received wonderful feedback. I am honored that it was so well attended and the audience learned it. Here are a few photographs from the event.

sqllive5 SQLAuthority News   Presented on Database Worst Practices at SQL Live, Orlando   November 29, 2014

If you have not attended my previous session, you can subscribe to my newsletter over here, I will be sending various resources used in this session in emails.

sqllive6 SQLAuthority News   Presented on Database Worst Practices at SQL Live, Orlando   November 29, 2014

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

SQL Authority News – I am Participating in Winter Discounts and Christmas Photo Fest

I often get asked which is my favorite tool from DevArt. They have many great tools, but I am really fan of the development productive tool – dbForget Studio for SQL Server. Devart’s dbForge Studio for SQL Server is a fantastic tool for SQL Server development, as soon as I installed it I found so many things to learn. First off, it will increase SQL coding almost instantly. There is very little to learn, you are not just memorizing codes to “cheat” off of. DbForge Studio provides code completion options and automatic SQL formatting, so that you know your code will work. One of my favorite feature is “snippets,” which stores parts of code that you use over and over to cut down on typing and searching – because you know they’re always a few commands you use again and again! Here is another blog post I wrote about Query Plan Analysis of Pivot and Unpivot with Profiler of dbForge Studio for SQL Server.

Every year in December the team at DevArt announces discounts and some fun contest. This year they have also announced similar fun contests as well as a Christmas photo fest.  The Christmas season is a great time to get 20% off on all Devart licenses until January 15th, 2015. If you want to get more discounts, take part in the Devart Christmas Photo Fest!

Share your Christmas desktop, workspace, office, laptop, tablet, etc. You can make a selfie, take a photo of your pets or any other kind of photo you wish. Share your Christmas mood and you will get a chance to win! The key condition is that any installed Devart product must get into the shot. Be creative and funny.

Please go to this blog post where it has given conditions and an example shot. I am going to take part in the contest and I encourage you to take part as well.

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

SQLAuthority News – Presented on Database Worst Practices at SQLPASS 2014 in Seattle – November 5, 2014

Earlier last month, I had the opportunity to present at SQLPASS 2014. The event was held in Seattle in November 2014. I had a great time attending this event and I presented on the topic Database Worst Practices on November 5, 2014.

sqlpass2014 SQLAuthority News   Presented on Database Worst Practices at SQLPASS 2014 in Seattle   November 5, 2014

Here is the title and abstract of the session, which I had presented at SQLPASS.

sqlpass2014 1 SQLAuthority News   Presented on Database Worst Practices at SQLPASS 2014 in Seattle   November 5, 2014

Secrets of SQL Server: Database Worst Practices

Abstract: 

sqlpass2014 2 SQLAuthority News   Presented on Database Worst Practices at SQLPASS 2014 in Seattle   November 5, 2014

“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.

sqlpass2014 3 SQLAuthority News   Presented on Database Worst Practices at SQLPASS 2014 in Seattle   November 5, 2014

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 after the session.

sqlpass2014 4 SQLAuthority News   Presented on Database Worst Practices at SQLPASS 2014 in Seattle   November 5, 2014

The session was extremely well received as I had received wonderful feedback. I am honored that it was so well attended and the audience learned it. Here are a few photographs from the event. The session is recorded and available to SQLPASS subscribers who have paid for the event.

sqlpass2014 5 SQLAuthority News   Presented on Database Worst Practices at SQLPASS 2014 in Seattle   November 5, 2014

If you have not attended my previous session, you can subscribe to my newsletter over here, I will be sending various resources used in this sessions in emails.

sqlpass2014 7 SQLAuthority News   Presented on Database Worst Practices at SQLPASS 2014 in Seattle   November 5, 2014

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

SQLAuthority News – Get My Two Books FREE at #SQLPASS

Every year when I visit SQLPASS, I do book signing where I give away my books for free. This year there are two opportunities when I am going to give away my books for free.

Though the books are in great numbers they always run away early. I strongly suggest that you arrive early and secure your copy. I will be extremely delighted to shake your hands and talk SQL.

Book Signing will be at the booth of Embarcadero and here are the timings for the same.

Book: SQL Wait Stats – Thursday, November  6th from 1 PM to 2PM.

waitstats pass SQLAuthority News   Get My Two Books FREE at #SQLPASS

Book Secret Tool Box of Successful Bloggers – Friday, November 7th from 11 AM to 12 PM.

blogging pass SQLAuthority News   Get My Two Books FREE at #SQLPASS

Do not miss this opportunity.

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

SQL Authority News – 8th Year Anniversary – Thank You!

8thann SQL Authority News   8th Year Anniversary   Thank You!Today is very special day in my life. Exactly 8 years ago today, I had started writing this blog.

When I started writing a blog post, I really had no idea what exactly I am starting and where exactly I was going to end. Today, after 8 years, I am still here and talking about SQL Server. Well, today I asked my two of my friends that what should I write on this milestone blog post where I complete my 8 years of blogging. They suggested I have learned in last 8 years and what I want to learn in next 1 year. Very good suggestion. Feel free to guess my friends in the comments area, let us see if you can name them correctly.

Things I have learned in last 8 years

Let me summarize my learning in 5 words – Be Humble and Keep Changing

I truly learned how to be humble in last 8 years. SQL Authority is not my own blog, but it is our blog. You all who are reading this blog right now, it is YOUR blog. There were moments when I was carried away in different directions or there were moments when I was at the same points for quite a while. Every single time I got inspirations from all of you to either get back on the track or move on from one subject. I can’t truly thank you enough. It is your encouragement who got me started writing on Big Data and MySQL. There were times when I had made mistakes and I have received emails correcting me – thank you to everyone who has helped making this blog a better place. I have learned a lot and I will keep on learning in the future.

Things I am planning to learn in next 1 year

This is difficult to answer at this point of time. However, I will say I want to learn more about Hybrid solutions. Everytime I go out in the real world, I often see Oracle, SQL Server, MySQL and many other solutions used all together in a single application. Those applications are really so big that it justifies the needs of various database platforms as they each offer something new. I believe this is where I want to grow more. I want to know where and when each of the data platform is helpful. I will need your help and I will blog my experience on this blog.

Once again – thank you so much. Here are FREE downloads which I have prepared earlier in my career. Please feel free to download them and use them to your advantage.

If you want to stay connected, sign up for our low frequency newsletter.

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

SQL Authority News – Embarcadero DB PowerStudio Promotion & Savings

If you are regular readers of this blog, you may be aware of that I use many different tools in my daily routine. One of them is DB PowerStudio for Embarcadero. The team has recently announced special saving for up to  51% when you buy the DB PowerStudio bundle. With DB PowerStudio, you get a database administration and development tool suite that enables you to work seamlessly across database platforms. DBAs and Developers need easy-to-implement and easy-to-use tools that enable them to create and maintain mission-critical databases, expedite code development, streamline database change management processes, and quickly optimize performance bottlenecks.

Here are some details about DB PowerStudio’s Bundle. It contains four products.

DBArtisan DBArtisan

  • Database administration and management
  • Space, data, security and performance management and insight
  • Schema and data migrations

Rapid SQL

  • The Intelligent IDE for SQL development
  • Query building
  • Debugging SQL code, function and stored procedures

DB Optimizer

  • Automated SQL profiling, tuning, optimization
  • Proactive identification of performance issues and bottlenecks
  • Maintain database uptime and availability

DB Change Manager

  • Essential schema and data synchronization
  • Quickly roll-out database changes
  • Visibility and reporting on DB changes
  • Compliance with database audit and reporting requirements

You can click here to avail a 51 % discount.

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

SQL Authority News – FalafelCON 2014: 2 days with the Best Developers in the World

It is only two weeks away. On September 20-21, 2014 I will be in San Francisco presenting at an amazing conference of Falafel Conference 2014.  I love presenting at various forums on various technologies. I am extremely excited that I got invited to speak at Falafel Conference 2014 in San Francisco. I will present two technology sessions on SQL Server. If you are into web development or if you just want to attend a conference with the best of the industry speakers, this may be the right conference for you. What set apart this conference from other conference is technology presented as well as speakers. Usually one has to attend very expensive and high scale event when they have to hear good speakers. At this conference, you will find quite a many industry legends are available to present on the bleeding edge technology.

Click to Register Here!

The Unsung Hero
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.

effectivepres3 SQL Authority News   FalafelCON 2014: 2 days with the Best Developers in the World

Secrets of SQL Server: Database Worst Practices
Abstract: 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.

happennext SQL Authority News   FalafelCON 2014: 2 days with the Best Developers in the World

Here are few of the reasons why I believe you should attend this conference:

  • Choose from four tracks covering Web, Mobile development and testing, Sitefinity, and Automated Testing, or attend sessions from all four!
  • Learn from the best developers and testers in the business in an intimate setting.
  • Surround yourself with your peers and the opportunity to network
  • Learn about the latest platforms and technologies, including Kendo UI, AngularJS, ASP.NET MVC, WebAPI, and more!

Here are the details for the sessions which I am going to present at Falafel Conference.

Register Now!

I have learned from the Falafel Team that they are running out of tickets and soon they will close the registration.  For next 10 days the price for the registration is only USD 199. Trust me, you can’t get such a world class training and networking opportunity at such a low price. Click to Register Here!

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

SQL SERVER – Learn SQL Server 2014 Online in a Day – My Latest Pluralsight Course

Click here watch SQL Server 2014 Administration New Features

SQL Server 2014 was released earlier this year and it has been extremely popular in Microsoft world. Here is the announcement for everyone, who have been asking me to build a tutorial around SQL Server 2014. I have authored latest Pluralsight courses on the subject of SQL Server 2014. This course is 4 hours and 17 minutes long, but the best part is that this course contains all the latest features of SQL Server 2014. I have build this course with the assumption that DBA is familiar with earlier versions of SQL Server and wants to explore and learn new features of SQL Server 2014.

The Challenge I Faced

The biggest challenge I faced was how to come up with the outline for the course. The reason is that there are so many different features introduced in SQL Server 2014 that is will be difficult to cover each of the features in a single course. I wanted to cover the topics which are the most relevant and useful to developers, but in addition I also wanted to cover the topics which may be useful to develop if they know that they exists in the product. I finally decided to depend on blog readers and few of the SQL Experts. I reached out to selected 20 people via email and gave them a list of the topics which I should be covering in this course. They all work in different organizations and have a good understanding about the need of the DBA and Developers.

Based on their feedback, I was able to come up with a very good outline which is currently very popular with Pluralsight library. Lots of people have asked me how was I able to come up with a course content outline so accurately. The credit for the same goes to the developers and DBA, who have voted in the topics and have helped me to build a very solid outline for the course.

Outline of the Course

Here is a quick outline for the course:

  • Introduction
  • Backup Enhancements
  • Security Enhancements
  • Columnstore Enhancements
  • Online Data Operations Enhancements
  • Enhancements with Microsoft Azure
  • SSD Buffer Pool Extensions
  • Resource Governor IO
  • Miscellaneous Features
    • Online Index Rebuilding
    • Live Plans for Long Running Queries
    • Transaction Durability
    • Cardinality Estimation
    • In Memory OLTP Optimization

Well, I had a great fun working on the topics which I have mentioned in the outline. I am very confident that once you start with the course, you will indeed understand how each of the topics builds and presented. I have made sure that each of the topic has a vivid and clear story to begin with. I first explain the story and right after that I explain the concept.

Who Should Attend This Course

Everyone who has basic knowledge of SQL Server and wants to update themselves with SQL Server 2014. They should attend this course. One thing I have made sure that this course is easy to understand and I have decided complex subject into multiple parts. This way the learning is progressive and anyone with a poor knowledge of the subject can have enough time to understand the presented concept.

Screenshot of the Course

Here are few of the screenshot of the courses.

sqlserver2014 SQL SERVER   Learn SQL Server 2014 Online in a Day   My Latest Pluralsight Course

How to Watch Video Course

This course is available at Pluralsight, and you will need a valid login to Pluralsight. If you do not have Pluralsight login, you can quickly sign up for the FREE Trial.

Click here watch SQL Server 2014 Administration New Features

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