SQL Archives - Page 208 of 519 - SQL Authority with Pinal Dave

SQL SERVER – Simple Trick to Backup Azure Database with SkyDrive

August 20, 2013

To ensure your SQL Server or Azure databases remain safe, you should backup your databases periodically. And it is important to store the backups in a reliable location. Microsoft SkyDrive currently offers 7GB free, Box offers 5GB free – both are reliable and it is simple to send your backups…

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…

SQL SERVER – SQL Basics: Database Careers – Day 7 of 10

August 13, 2013

Pinal Dave

SQL

Joes 2 Pros, SQL Server, SQLAuthority Book Review

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

SQL SERVER – SQL Basics: SQL Code Generators – Day 6 of 10

August 12, 2013

Pinal Dave

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

Joes 2 Pros, SQL Scripts, SQLAuthority Book Review

This is the 6th 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). Almost everyone these days feels comfortable with using a “point and click” process to get things…

SQL SERVER – SQL Basics: Using Management Studio – Day 5 of 10

August 11, 2013

Pinal Dave

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

Joes 2 Pros, SQLAuthority Book Review

This is the 5th 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). By now you have written several queries. This means you have opened SQL Server Management Studio and…

SQL SERVER – Weekly Series – Memory Lane – #041

August 10, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Memory Lane

Here is the list of selected articles of SQLAuthority.com across all these years. Instead of just listing all the articles I have selected a few of my most favorite articles and have listed them here with additional notes below it. Let me know which one of the following is your…