SQLServer

Showing posts with label SQLServer. 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