MSSQL Tutorial, Tips and Tricks of the Professional Database Administrator

     This section is to give you the tips, tricks and a tutorial of everyday DBA database problems. You can learn SQL and how to access the data in tables, how to maintain triggers, constraints and how to create stored procedures. Have you ever tried to find the answer to a SQL problem you are working on and been frustrated by the solutions found on the web?

Here is a list of problems I have solved over the years. Ideally, I have presented the problem and a solution with all the pieces necessary to resolve the problem situation. I hate going to web sites and they show a small segment of code, that is the right code for your database/SQL problem, but you spend the next three days fishing for all the other script to finish your project.

Now, I don't plan to do all your work for you. It is your responsibility to read and study SQL and database administration, so you understand what is the right piece of the puzzle you need for your project.

If you are looking for specific information on C# programming, then check out the following links.


This SQL tutorial will provide you with the information you need to solve your SQL problems. You can learn SQL and we can help. You will find SQL basics, SQL intermediate and SQL advanced solutions to database analysis issues. So here is a list of links to problems I have solved.
Data Definition Language
Data Manipulation Language
What is a Database?
What is SQL?

Additions to our SQL and Database Pages

SQL DELETE Statement

YouCanLearnSeries RSS feed for SQL tips and tutorials
A Powerful Command to Remove Rows from a Database The SQL DELETE statement is the most dangerous word in your arsenal of SQL statements. With one word and a table name you can inadvertently delete every row and column in a table. Use the following information cautiously...

SQL INSERT Statement

YouCanLearnSeries RSS feed for SQL tips and tutorials
The SQL INSERT statement is used to add rows to a table or view. When you want to add information to a table you use the INSERT keyword. This is different from the UPDATE statement because when using the UPDATE statement you are changing information in a row. With the INSERT statement you are adding new information to the table.

Power of the SQL SELECT statement

YouCanLearnSeries RSS feed for SQL tips and tutorials
Select Statement You can write SELECT statements and bring back information from any database. The SELECT statement retrieves information from the database. You can select information from one row or many rows, one field or column or many columns and from one table or many tables.

Success is Achieved by doing the fundamentals - Are you happy with the results. Did we get the number of visitors we wished for? Did our visitors click on revenue producing links and ads? Were our page views up for the year or down? Did users visit more than one page? Did they make it to the order form and then abandon or did they continue and purchase our products?

Latest You Can Learn Series Blog Articles:

We Arrive in Santiago de Compestela Spain

We walked for Thirty Three days straight

We have arrived in Santiago. We walked for 33 straight days. Some days were 12 milers and as many as 18 miles or more in one day. We reached our destination. We decided not to rush to reach the city. Mary had accidentally banged her knee on the table at the restaurant the night before and it was a little tender.

Day 31 Palas de Rei to Ribadiso

We have walked 31 days to Santiago de Compostela

Today we started early because we had reserved a room at an albergue and we had to get there by 2pm or we lost the reservation. Mary set a blistering pace in the dark morning mist. Sunrise is at 8 am but this morning we had clouds and fog so it was darker than yesterday. The path through the city was okay but then leaving the city it became more difficult.

Three days of walking left in our Camino

We only have 66 kilometers to Santiago

We have walked for 30 days with only 3 days till we reach our destination of Santiago de Compostela. It has been an amazing journey. We are in the Galicia region of Spain known for the rain it receives. Well we are extremely lucky because the weather has been beautiful for walking. It starts out cool in the high 40s but then warms up to the low to mid 70s. With plenty of sunshine.

We arrived in Sarria

Five walking days to Santiago

Today we started late at 8 am. We were almost the last people out of Triacastela walking the Camino.

Ocebreiro to Triacastela

Only 6 days remaining on the Camino de Santiago

We are sitting in a restaurant in the little village of Triacastela on day 27 having tapas. It was a short 12 miles that were mostly down. Tomorrow we hope to go to Sarria.

Views from Astorga Spain

From Leon to Astorga on the Camino de Santiago

We visited Leon, Spain yesterday and then we walked 35Km today. Leon was wonderful. Today we walked in rain for the first time. We went 35 KM yesterday for no other reason than we could.

Walked 17 Miles Today

Today we walked 17 miles on the Camino

Today we are sitting at the albergue in Terradillos de las Templarios. We are at the halfway point in our journey. We have walked over 250 miles or 400 kilometers. I truly didn't think we would be able to do this. Mary has been a real trouper walking through bad knees and the pain of shin splints.

Finished a Third of our Camino Experience

We have walked a Third of the way to Santiago

Today finds us in Ages, Spain only 14 miles from Burgos. We are quite excited that we have managed this distance. We hoped we could but we had doubts especially those first few days where we hurt so much.

The Path to Najera Spain

Eight Days of Walking

We have been walking for 8 days now. It has been interesting, tiring, painful, fun and a real learning experience.

Walking Through the Pyrenees

Walking Through the Pyrenees

Mary and I started our journey to Santiago Spain. The first day we started in Saint Jean Pied de Port in France. The goal was to arrive in Roncevalle, Spain before nightfall.

Home| About Us | NewsLetters | Contact Us |

Copyright © 2004-2014 You Can Learn Series

You Can Learn Series Home Page You Can Learn Series
You Can Learn Series Home Page Home            About the creators of YouCanLearnSeriesAbout Us      Contact YouCanLearnSeriesContact Us      Site map of YouCanLearnSeriesSite Map      Privacy Policy of You Can Learn SeriesPrivacy Policy       Terms of Use of You Can Learn Series web siteTerms of Use       YouCanLearnSeries RSS feed for SQL tips and tutorials     
C# and ASP.Net Programming TipsC# and ASP.Net      SQL Tutorial, tips and tricks for DBA'sSQL       Landscaping Tips for Home GardenersLandscaping       WeightLifting Tips for the Young and OldWeightLifting       Good health TipsGoodHealth       Learn about Great Travel DestinationsTravel     Web Business TipsWeb Business     

You Can Learn Series Home Page Home     
You Can Learn C# and ASP.Net SeriesC# and ASP.Net

You Can Learn SQL SeriesSQL
  Data Definition LanguageData Definition Language
  Data Manipulation LanguageData Manipulation Language
  What is a DatabaseWhat is a Database
  What is SQLWhat is SQL
  SELECT StatementSELECT Statement
  INSERT StatementINSERT Statement
  DELETE StatementDELETE Statement
  UPDATE StatementUPDATE Statement

You Can Learn Landscaping and Gardening SeriesLandscape Tips
You Can Learn WeightLifting SeriesWeightLift Tips
You Can Learn Good Health SeriesGood Health Tips
You Can Learn Series NewslettersNewsletters
Learn about Great Travel DestinationsTravel
You Can Learn Series Web Business TipsWeb Business Tips

Bill Welter - The Prepared Mind of a Leader

Americas Public Schools