SQLAuthority News Archives - Page 28 of 118 - SQL Authority with Pinal Dave

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

August 27, 2013

SQL, SQL Server, SQL Tips and Tricks, SQL Video, SQLAuthority News

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…

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

August 26, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQL Video, SQLAuthority News

Joes 2 Pros, SQLAuthority Book Review

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…

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

August 25, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQL Video, SQLAuthority News

Joes 2 Pros, SQLAuthority Book Review

This is the 4th 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 amount of effort to type the ‘–‘ signs for a single-line comment increases…

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

August 23, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQL Video, SQLAuthority News

Joes 2 Pros, SQLAuthority Book Review

This is the 3rd 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). An INNER JOIN clause allows us to join multiple tables in a single query,…

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

August 21, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQL Video, SQLAuthority News

Joes 2 Pros, SQLAuthority Book Review

This is the 1st 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). Databases have been around since cavemen were drawing stick figures of their family’s on…

SQL SERVER – SQL Basics: What Are Filegroups – Day 9 of 10

August 15, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

Joes 2 Pros, SQLAuthority Book Review

This is the 9th post out of my 10 post series of my 10th book – SQL Basics. Today will show the importance of data and information. You can get that in Paperback (USA) and Kindle (Worldwide). Using Filegroups There are many advantages to using filegroups to manage the database workload. A filegroup…

SQL SERVER – SQL Basics: Database Datafiles and Logfiles – Day 8 of 10

August 14, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

Joes 2 Pros, SQLAuthority Book Review

This is the 8th post out of my 10 post series of my 10th book – SQL Basics. Today will show the importance of data and information. You can get that in Paperback (USA) and Kindle (Worldwide). Logging Data Changes In my experience, many students do not find the concept of datafile and logfile activity…