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)

About these ads

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)

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

This is the 7th 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 live system is the one that interacts with our customers and must stay up during all business hours which is often 24-7 in today’s global business world. These databases should be designed to collect the data in transactions that are needed to do business. This is often called the Online Transaction Processing database (or OLTP database). This OLTP system must respond immediately to user requests through a proper interface (such as an ATM).  During peak business hours the OLTP system can slow down and cause customer delays. If we were to run a query for a business meeting during this peak time we could slow the live system even further. For this reason any testing or analysis is often done on a copy of the database. This way company work and research can get done without interfering with the customer’s usage of the same database.

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 Careers – Day 7 of 10

Available in Paperback (USA), Kindle (Worldwide) 

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

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

This is the 6th 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).

With the SQL Server Management Studio User Interface (SSMS UI), we can create a table by writing code in a query window, or use the “point and click” method. Point and click allows us to create a table without writing any code ourselves. It is much easier to send someone the code script to accomplish a task with SQL Server than it is to send step-by-step instructions on how to point and click their way to accomplish the same task. For this reason, code script is the most common method used to consistently and reliably deploy new databases and objects the exact same way on many systems.

It is much faster to run code that has already been written and tested by someone else than it is to accurately and consistently navigate the user interface. There are times when creating long constructions of code is faster with the SSMS UI than it is to write out each line of code by hand. In addition, some people simply prefer to point and click their way to creating objects in SQL Server.

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 Code Generators – Day 6 of 10

Available in Paperback (USA), Kindle (Worldwide) 

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

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

This is the 5th 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).

By now you have written several queries. This means you have opened SQL Server Management Studio and then opened a query window to write your code. Once it came time to execute your code you can do so by pressing F5 or clicking the Execute button. Management Studio connects to your server and provides you handy tools to manage your databases. You even have the Object Explorer to browse all the parts of your server to see what is present. But what if one of your windows is gone? Or what if you are doing a presentation and the fonts are too small to be seen in the back of the room? You can customize the look and feel of Management Studio to your liking. This blog post will show you how to navigate the common windows in Management Studio.

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: Using Management Studio – Day 5 of 10

Available in Paperback (USA), Kindle (Worldwide) 

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