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.

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

Secrets of SQL Server: Database Worst Practices

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

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.

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.

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.

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

Secrets of SQL Server: Database Worst Practices

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

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.

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.

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.

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

Do not miss this opportunity.

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

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.

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.

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)