SQL Server 2008 Management and Administration (Paperback)
SQLAuthority News – Author Visit – TechEd India 2009 – Hyderabad
I am sure most of you have already heard the good news -Microsoft TechEd India 2009 finally arrives! Tech.Ed-India is a great opportunity to gear yourself up to keep pace with the latest technology innovations and trends. This event offers you the platform to get comprehensive hands-on-training and free certifications…
Read MoreSQL SERVER – Roadmap of Microsoft Certifications – SQL Server Certifications
Introduction In these times of economic slowdown and uncertainties, more and more IT professionals are concerned about their job security and their qualifications. With job insecurity looming on their minds, it is a common trend for developers to start hunting for ways to update their skills. Sound knowledge and real…
Read MoreSQL SERVER – Add or Remove Identity Property on Column
This article contribution from one of my favorite SQL Expert Imran Mohammed. He is one man who has lots of ideas and helps people from all over the world with passion using this community as platform. His constant zeal to learn more about SQL Server keeps him engaging him to…
Read MoreSQL SERVER – Example of DDL, DML, DCL and TCL Commands
DML DML is abbreviation of Data Manipulation Language. It is used to retrieve, store, modify, delete, insert and update data in database. SELECT – Retrieves data from a table INSERT – Inserts data into a table UPDATE – Updates existing data into a table DELETE – Deletes all records from…
Read More
SQLAuthority News – Gandhinagar SQL Server User Group Meeting April 24, 2009
We had another successful Gandhinagar SQL Server User Group Meeting on April 24, 2009. In spite of our User Group being just two months old, it received overwhelming warm response from the audience! The meeting once again saw around 50 SQL Server enthusiasts eagerly looking forward to brush up their…
Read MoreSQL SERVER – FIX : ERROR : is not a valid Win32 application. (Exception from HRESULT: 0x800700C1)
Just a day ago, one of my friend sent me email requesting help with following error: is not a valid Win32 application. (Exception from HRESULT: 0x800700C1) In fact this is not SQL Server error but it is of .NET application. The solution of this error is just changing configuration of…
Read MoreSQL SERVER – Solution to Puzzle – Shortest Code to Perform SSN Validation
One of my friends – a SQL Server MVP- Jacob Sebastian has a knack for coming up with interesting ideas and stuffs, the latest example being SQL Server Puzzles on his blog. Jacob is a regular blogger and a talented writer. I enjoy reading his blogs and books. He has…
Read More
SQL SERVER – Introduction to SQL Server Encryption and Symmetric Key Encryption Tutorial with Script
SQL Server 2005 and SQL Server 2008 provide encryption as a new feature to protect data against hackers’ attacks. Hackers might be able to penetrate the database or tables, but owing to encryption they would not be able to understand the data or make use of it. Nowadays, it has become imperative to encrypt crucial security-related data while storing in the database as well as during transmission across a network between the client and the server.
SQLAuthority News – Starting the SQL Journey – How Did I Get Started With SQL?
This is the very first time I am answering any online tag. SQL Expert Jorge Segarra (a.k.a @SQLChicken) recently tagged me with a very simple yet significant question related to my journey on the path of SQL Server. Let me introduce you all to Jorge first before moving on to…
Read More