SQL

Showing posts with label SQL. Show all posts

MySQL(1995) is a dependable Database Management System (DBMS) that employs Structured Query Language (SQL) to perform data-related tasks. Its well-known version provides an open-source platform to which you may quickly gain access and carry out your Data Management responsibilities.

 

MySQL is one of the most common relational database management systems; before we go into the introduction to MySql, let us go over some database basics.

Published by on under MySQL Database | SQL
This is another small guest post on SQL Server submitted by Joydeep Das. In the previous post, he described about "Join Hint in SQL".

In this post, he will guide you to illustrate the concepts of Database Compression on SQL Server 2008. It is the concepts behind the compression only. For details level of learning you need to follow the MSDN or any MS Notes.

Read more to understand the concept from Joydeep and don’t forget to ask your SQL Queries in the comments section.
Published by on under GuestPost | Joydeep-Das

This is a small guest post on SQL Server submitted by one of my friend Joydeep Das. In this post, he will guide you to understand the basics of Join hint and when to use that.

 

He will also guide you on various types of Join hint used in SQL Server with algorithm and code example. So, why are you waiting for? Read more to understand the concept from Joydeep and don’t forget to ask your SQL Queries in the comments section.

Published by on under CodeProject | GuestPost

On 3rd October 2011, I had started a giveaway contest of “SQL Wait Stats Joes 2 Pros” book authored by Pinal Dave, Microsoft Evangelist and Founder of SQLAuthority.com. The contest ended on 21st October 2011.

 

We received no. of participants in the contest and after reviewing all the entries, I have randomly picked up two Winners, who will receive signed copy of the “SQL Wait Stats Joes 2 Pros” book. Congratulation email will be send out to the winners requesting their shipping address. Find out whether you are the lucky winner of the contest.

Published by on under Book | SQL

Do you work on SQL Server as a SQL developer or administrator and want to gain some good knowledge on SQL Wait Stats and Parallel Execution from SQL Guru Pinal Dave? Then this post will help you to win a hard copy of his book.

 

Pinal Dave, who is a Microsoft Evangelist published a book “SQL Wait Stats Joes 2 Pros” recently. He accepted my request and going to giveaway 2 copies of his book to my blog followers. Read more to register for the contest and Win the book Free.

Published by on under Book | SQL

image

The SQL developer needs to be able to create processes for the working database by using one of the many programming objects (like functions, stored procedures, constrains, or triggers). By creating objects that talk with SQL you simply the way other programs (like applications or web pages) can interconnect. These eternal programs only need to call on the names of your programming objects by name rather than needing to submit large pieces of advance code.

 

With SQL Programming Development (Volume 4 of 5) in the SQL Server Joes 2 Pros development series, you learn how programming objects work in SQL Server. This book has been authored by Rick A. Morelan, Pinal Dave and Jessica Brown. If you are a SQL Developer, you may like the series of the book.

 

Published by on under Book | DZone

Last three days we learnt about the new feature of Windows Phone 7 (Mango) called "Local Database Support". Yesterday we discussed it in depth by building a small demo application. While working with the demo you might noticed that, we used a connection string to connect with the local database present in the Windows Phone storage.

 

In this post, we will discuss more on the connection string. After reading this post, you will be able to know what are the various types and parameters available for connection string.

Published by on under Mango | Silverlight

Do you know that, Windows Phone 7.1 (Mango) now supports local database? Yes, you can now use local database inside your Phone 7 device and use it to CRUD operations. You can now create a DataContext class from an existing database and use it as the entry point class to do DB operation.

 

In this chapter we will learn how to create a DataContext class for local SQL CE database. At the end of this tutorial our data context class will be ready for further DB operations.

Published by on under Mango | Silverlight