Kunal-Chowdhury.com - Microsoft Technology Blog for developers and consumers: SQL
Showing posts with label SQL. Show all posts
Showing posts with label SQL. Show all posts

Data Compression in SQL Server 2008 - Guest Post by Joydeep Das

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.


Join Hint in SQL - Guest Post by 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.


Announcing Winner of the SQL Book Contest

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.


Participate in the Contest and Win “SQL Wait Stats Joes 2 Pros” Book Authored by Pinal Dave

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.


SQL Programming Joes 2 Pros - Authored by Pinal Dave

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.

 


Windows Phone 7 (Mango) Tutorial - 25 - Learn about Database Connection String

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.



Windows Phone 7 (Mango) Tutorial - 22 - Local Database Support, Create DataContext

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.

 
© 2008-2017 Kunal-Chowdhury.com - Microsoft Technology Blog for developers and consumers | Designed by Kunal Chowdhury
Back to top