http://www.c-sharpcorner.comWatch latest content from SQL© 1999 - 2012 Mindcracker LLC. All Rights ReservedIn this article you will learn how to create a report in SSRS 2008.http://www.c-sharpcorner.com/UploadFile/47fc0a/create-a-report-in-ssrs-2008/May 20, 2013Surjeet YadavLearn about SQL Server Management Studio Keyboard Shortcuts.http://www.c-sharpcorner.com/Blogs/11712/sql-server-management-studio-keyboard-shortcuts.aspxMay 19, 2013Surjeet YadavIn this article you will learn about Join statements of SQL server.http://www.c-sharpcorner.com/UploadFile/47fc0a/explain-sql-joins/May 19, 2013Surjeet YadavCHECK FOR TABLE/PROCEDUE THAT DEPEND ON PROCEDURE/TABLE.http://www.c-sharpcorner.com/Blogs/11703/find-dependent-object-in-sql-server.aspxMay 17, 2013Sambhav YadavIn this article we will create symmetric key and encrypt and decrypt string using this key.http://www.c-sharpcorner.com/UploadFile/db2972/encrypt-and-decrypt-in-sql-server-part-5/May 16, 2013Akshay PatelThe article explains some nice data retreving techniques including Derived Tables and CTE.http://www.c-sharpcorner.com/UploadFile/6897bc/some-nice-select-query-techniques-for-db-programmers/May 15, 2013Sivaraman DhamodaranHere I show how to find duplicates and their frequency among multiple columns using the GROUP BY clause.http://www.c-sharpcorner.com/UploadFile/0f68f2/finding-duplicates-among-multiple-columns-in-sql/May 15, 2013Hemant SrivastavaIn this article you will learn how to create a new job and schedule that job for execution in SQL Server 2008.http://www.c-sharpcorner.com/UploadFile/raj1979/create-and-schedule-a-job-in-sql-server-2008/May 14, 2013Raj KumarSQL server Extended event is nothing but event handling system for server system. http://www.c-sharpcorner.com/UploadFile/ff2f08/extended-event-in-sql-server/May 14, 2013Jignesh TrivediIn this article we will encrypt plain text and decrypt encrypted text using asymmetric key.http://www.c-sharpcorner.com/UploadFile/db2972/encrypt-and-decrypt-in-sql-server-part-4/May 14, 2013Akshay PatelIn this article you will learn how to use a Temporary Table in SQL Server.http://www.c-sharpcorner.com/UploadFile/8911c4/temporary-table-in-sql-server/May 13, 2013Mahesh AlleIn this article we will generate certificate and using this certificate we will encrypt and decrypt the string.http://www.c-sharpcorner.com/UploadFile/db2972/encrypt-and-decrypt-in-sql-server-part-3/May 12, 2013Akshay PatelThis blog defines step by step process for to create linked server from MySQL TO SQL Server. http://www.c-sharpcorner.com/Blogs/11655/how-to-create-linked-server-from-mysql-to-sql-server.aspxMay 10, 2013Pankaj PandeyIn this article we will discuss how get the port no of our own SQL Server instance and how to use that port in SQL Server setting and at the end how use that port in your C Sharp application.http://www.c-sharpcorner.com/UploadFile/e881fb/secured-connection-between-sql-server-and-C-Sharp-using-specific/May 10, 2013Naveed ZamanIn this article we will discuss Database Master Key.http://www.c-sharpcorner.com/UploadFile/db2972/encrypt-and-decrypt-in-sql-server-part-2/May 08, 2013Akshay PatelIn this article we will discuss Service Master Key, backup, restore and alter Service Master Key.http://www.c-sharpcorner.com/UploadFile/db2972/encrypt-and-decrypt-in-sql-server-part-1/May 06, 2013Akshay PatelI encountered a problem today and thought to share with all of you so that in the future, if you confront such an issue then this article may help you.http://www.c-sharpcorner.com/UploadFile/97fc7a/the-database-principal-owns-a-schema-in-the-database-and-ca/May 06, 2013Sachin KaliaRemove Duplicate rows in a table.http://www.c-sharpcorner.com/Blogs/11626/remove-duplicate-rows-in-a-table.aspxMay 06, 2013Siva Ganesh RongalaHere you will learn how to create a Job Task in SQL Server 2008.http://www.c-sharpcorner.com/UploadFile/0fca19/step-by-step-procedure-to-create-a-job-task-in-sql-server-20/May 06, 2013Pankaj PandeyThis article looks at SQL Server string, numeric and date functions and their Oracle equivalents.http://www.c-sharpcorner.com/UploadFile/c5c6e2/sql-server-functions-and-oracle-equivalent/May 04, 2013Shankar MIn this article we create a database in SQL Server 2008 and install ASP.NET membership services then install an ASP.NET Memberships Services Database.http://www.c-sharpcorner.com/UploadFile/3d39b4/learn-membership-services-part-1-installing-Asp-Net-members/May 04, 2013Sandeep Singh ShekhawatIn this article you will learn about Temporary Tables and Table Variables in SQL Server 2008. http://www.c-sharpcorner.com/UploadFile/eec362/temporary-tables-vs-table-variable-in-sql-server-2008/May 04, 2013Yogesh BajpaiCall or execute a Stored Procedure from Select Statement in SQL Server using OPENROWSET.http://www.c-sharpcorner.com/Blogs/11616/call-or-execute-a-stored-procedure-from-select-statement-in.aspxMay 03, 2013Sachin KaliaRecently I am working on Entity Framework as data access layer based Project. We found many performance issues with this application. http://www.c-sharpcorner.com/UploadFile/ff2f08/prevent-dead-lock-in-entity-framework/May 02, 2013Jignesh TrivediIn this article, I would like to show how to extract the metadata about a database in SQL Server.http://www.c-sharpcorner.com/UploadFile/rohatash/databasepropertyex-function-in-sql-server/May 01, 2013Rohatash KumarRemove last character from a string by using some SQL functions.http://www.c-sharpcorner.com/Blogs/11591/remove-last-character-from-a-string-in-sql-server.aspxApr 30, 2013Pradip PandeyThis blog is about how to upgrade a database file to use LocalDBhttp://www.c-sharpcorner.com/Blogs/11585/how-to-upgrade-a-database-file-to-use-localdb.aspxApr 29, 2013Raj KumarThis blog defines the case statement with a simple example in SQL Server. http://www.c-sharpcorner.com/Blogs/11581/case-statement-in-sql-server.aspxApr 29, 2013Yogesh BajpaiHere, You will see how to create function and then call in SQL Query in SQL Server 2008.http://www.c-sharpcorner.com/Blogs/11580/how-to-create-function-in-sql-server.aspxApr 29, 2013Yogesh BajpaiHow to Convert Indian Rupee to Indian Rupee System using SQL Function.http://www.c-sharpcorner.com/Blogs/11525/how-to-convert-indian-rupee-to-indian-rupee-system.aspxApr 24, 2013Bhupendra Singhin this blog we will learn what is Between Functions and Stored Procedurehttp://www.c-sharpcorner.com/Blogs/11463/difference-between-stored-procedure-and-functions.aspxApr 18, 2013Vithal WadjeHow to write dynamic query in SQL. Means your query execute according to your requirement.http://www.c-sharpcorner.com/Blogs/11461/dynamic-query-in-sql.aspxApr 18, 2013Ravi ShekharIn this blog I will tell you that what is the difference between In and Between Operator in SQL.http://www.c-sharpcorner.com/Blogs/11356/difference-between-in-and-between-operator-in-sql.aspxApr 11, 2013Akash GargIn this blog I will provide a quick overview of how to use the max and min functions in SQL.http://www.c-sharpcorner.com/Blogs/11347/how-to-use-max-and-min-function-in-sql.aspxApr 10, 2013Akash GargWe can find out the first and last day with time of the previous month by simple step.http://www.c-sharpcorner.com/Blogs/11331/findout-first-day-and-last-day-with-time-of-the-previous-mon.aspxApr 09, 2013Akash GargUpdate Male TO Female and Female To Male with single queryhttp://www.c-sharpcorner.com/Blogs/11330/update-male-to-female-and-female-to-male-with-single-query.aspxApr 09, 2013Satyapriya NayakIn this blog we calculate the working days in a company by using SQL.http://www.c-sharpcorner.com/Blogs/11329/calculate-number-of-working-days-between-two-date-by-using-s.aspxApr 09, 2013Akash GargIn this blog differences between SQL Server 2008 and SQL Server 2012 are shownhttp://www.c-sharpcorner.com/Blogs/11323/difference-between-sql-server-2008-and-sql-server-2012.aspxApr 08, 2013Akash GargTriggers can be classified as a special type of stored procedure that executes automatically in response to some triggering action like INSERT, UPDATA, DELETE etchttp://www.c-sharpcorner.com/Blogs/11289/triggers-in-sql-server.aspxApr 03, 2013Jatin NagpalSql server table identity column in different session and scopes.http://www.c-sharpcorner.com/Blogs/11257/difference-between-identity-scope_identity-ident_cur.aspxMar 31, 2013Nitesh SinghalIn this video we will see how we can create a simple report using SQL Server reporting servcies.http://www.c-sharpcorner.com/UploadFile/shivprasadk/create-a-simple-report-using-sql-server-reporting-services/Mar 30, 2013Shivprasad This video gives introduction to DBMS, Advantages of DBMS over a physical database and the different types of SQL Commandshttp://www.c-sharpcorner.com/UploadFile/f64127/introduction-to-dbms-types-of-sql-commands/Feb 05, 2013Hemanth KumarWhat is CDC ( Change data capture ) in SQL Server ?http://www.c-sharpcorner.com/UploadFile/shivprasadk/what-is-cdc-change-data-capture-in-sql-server/Dec 23, 2012Shivprasad In this video we will try to understand can SQL Server views be updated.http://www.c-sharpcorner.com/UploadFile/shivprasadk/can-sql-server-views-be-updated-simple-sql-server-intervie/Nov 23, 2012Shivprasad In this webinar video Kamal and Akshay talk about essentials of SSIS ( SQL Server integration services) and SSRS ( SQL Server reporting services)http://www.c-sharpcorner.com/UploadFile/shivprasadk/abc-of-ssis-and-ssrs-webinar-C-Sharp-corner-mumbai-group/Jun 22, 2012Shivprasad In an enterprise data-driven application, the quality of SQL statements plays a vital role in an application's performance. A bad SQL statement can break the application. In this article, I discuss some best practices of using PL/SQL.http://www.c-sharpcorner.com/UploadFile/esubal/plsql-best-practices3/Jun 15, 2012Subal Mishra