SQL SERVER – How to Install SQL Server 2014 – A 99 Seconds Video

Last month I presented at 3 community and 5 corporate events. Every single time I have been asked by others what is my experience with SQL Server 2014. Every single time I have told the audience that they should try this out themselves, however, the response has been very lukewarm. Everybody wants to know how SQL Server 2014 works, but no one wants to try out themselves.

Upon asking why users are not installing SQL Server 2014, pretty much the same answer I received from everyone – “The Fear of Uknown”. Everybody who have not installed SQL Server 2014 are not sure how the installation process works and what if they face any issue while installing SQL Server 2014. If you have installed an earlier version of SQL Server, installing SQL Server 2014 is very easy process.

I have created a quick video of 99 seconds where I explain how we can easily install SQL Server 2014. This is a straight forward default installation of SQL Server.

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

About these ads

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)

SQL SERVER – 3 Quick Videos on Careers, Certifications and Information

SQL in Sixty Seconds has been a very popular channel on YouTube. Here are three of the videos which are based on the Careers, Certifications and Information. Let me know what you think of the same. Additionally, if you like the SQL in Sixty Channel, please subscribe over here. In year 2014 we are planning to bring new Sixty Seconds videos on various interesting tips and tricks for SQL Server.

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

SQLAuthority News – 10 SQL in Sixty Days Video in 10 Days – Contest to Win 10 Cool Gifts

SQL in Sixty Seconds series has received a very high appreciation in the community. I have been posting every month 3 or 4 new videos in this series but the popularity of the SQL in Sixty Seconds is such that I am constantly receiving emails requesting new videos in this series. Recently I had teamed up with Rick Morelan (Joes 2 Pros fame) to build 10 videos in this SQL in Sixty Seconds series. We had a fantastic response to this video and we have crossed over 3200 subscribers and over 300,000 views in our YouTube Channel. If you have not subscribed to YouTube Channel, please subscribe now as we will have many interesting videos coming up in near future.

Here is the list of all the 10 videos which we have posted earlier which are very well received in the community. Now to take this entire thing to the next level – here is a quick contest. Please tell us which is your favorite video out of the 10 videos and why? If your choice matches the choice of Rick and Myself (Pinal) – we will give you a free copy of our latest book SQL Basics. You can get that in Paperback (USA) and Kindle (Worldwide). Additionally, not only 1 copy but we will have 10 winners for the contest. In case of a tie we will select the winner based on the WHY? 

SQL Basics Video: SQL 2012 Certification Path – SQL in Sixty Seconds #065

SQL Basics Video: What Are Filegroups – SQL in Sixty Seconds #064

SQL Basics Video: Database Datafiles and Logfiles – SQL in Sixty Seconds #063

SQL Basics Video: Database Careers – SQL in Sixty Seconds #062

SQL Basics Video: SQL Code Generators – SQL in Sixty Seconds #061

SQL Basics Video: Using Management Studio – SQL in Sixty Seconds #060

SQL Basics Video: Code Comments – SQL in Sixty Seconds #059

SQL Basics Video: Joining Tables – SQL in Sixty Seconds #058

SQL Basics Video: Running SQL Code – SQL in Sixty Seconds #057

SQL Basics Video: Data and Information in Businesses – SQL in Sixty Seconds #056

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

SQL SERVER – SQL Basics Video: SQL 2012 Certification Path – SQL in Sixty Seconds #065

This is the 10th post out of my 10 post series of my videos on my 10th book – SQL Basics. Today will show the importance of data and information.

You can get that in Paperback (USA) and Kindle (Worldwide).

The new breakdown of the Microsoft SQL 2012 certification model offers new incentives and rewards. The entry level certification in the 2012 model starts with one of three certification tests.

In training hundreds of people over that last decade to get their Microsoft certification, to my surprise the biggest benefit you get is something else. The most common benefit my students tell me about is that they get invited to far more job openings after getting certified than they did before. When the stack or resumes gets sorted down, they need a proven reason to keep yours on the short list.

SQL in Sixty Seconds Video

We have attempted to explain the same subject in simple words over in following video.

Action Item

Get the book for yourself and your friend. This is just a reference everyone must have it.

Read the related blog post: SQL Basics: SQL 2012 Certification Path – Day 10 of 10

Available in Paperback (USA), Kindle (Worldwide) 

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

SQL SERVER – SQL Basics Video: What Are Filegroups – SQL in Sixty Seconds #064

This is the 9th post out of my 10 post series of my videos on my 10th book – SQL Basics. Today will show the importance of data and information.

You can get that in Paperback (USA) and Kindle (Worldwide).

There are many advantages to using filegroups to manage the database workload. A filegroup may contain many datafiles, and the properties of all the datafiles can be managed simultaneously with a filegroup. There are many advantages to using filegroups to manage the database workload. A filegroup may contain many datafiles, and the properties of all the datafiles can be managed simultaneously with a filegroup.

A primary filegroup contains the primary datafile (mdf) and possibly secondary datafiles (ndf). All system tables are allocated to the primary filegroup.

A secondary filegroup (also called a user-defined filegroup) contains secondary datafiles (ndf) and database objects.

The default filegroup contains objects which were created without an assigned filegroup. The primary filegroup is the default filegroup unless another filegroup is specified.

SQL in Sixty Seconds Video

We have attempted to explain the same subject in simple words over in following video.

Action Item

Get the book for yourself and your friend. This is just a reference everyone must have it.

Read the related blog post: SQL Basics: What Are Filegroups – Day 9 of 10

Available in Paperback (USA), Kindle (Worldwide) 

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

SQL SERVER – SQL Basics Video: Database Datafiles and Logfiles – SQL in Sixty Seconds #063

This is the 8th post out of my 10 post series of my videos on my 10th book – SQL Basics. Today will show the importance of data and information.

You can get that in Paperback (USA) and Kindle (Worldwide).

We know that SQL Server stores its data much like other applications, in files which are saved to a persistent drive. But a distinguishing feature of SQL Server is its robust ability to keep track of things. The security and safety of the data and reliability of the system are SQL Server’s top priorities. Therefore, you can imagine that logging activity, which tracks every transaction made in the database, is a pretty big deal. Examples where logging saves the day generally involve some type of database restore or recovery need. Once a database backs itself up, we are generally assured a reliable mechanism we can use to restore the system in case something unfavorable happens. Suppose we notice bad data has come into the system through one of the periodic feeds. In fact, this data is so problematic that the team decided we must restore the database back to the point a week ago. This gets us back to a time before the bad data began entering the system. The periodic database backup is built using information provided by the logfile. Logfiles keep track of the database transactions and help ensure data and system integrity, in case a system recovery is ever necessary.

SQL in Sixty Seconds Video

We have attempted to explain the same subject in simple words over in following video.

Action Item

Get the book for yourself and your friend. This is just a reference everyone must have it.

Read the related blog post: SQL Basics: Database Datafiles and Logfiles – Day 8 of 10

Available in Paperback (USA), Kindle (Worldwide) 

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