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 MoreSQL SERVER – List All the Tables for All Databases Using System Tables
Today we will go over very simple script which will list all the tables for all the database. sp_msforeachdb 'select "?" AS db, * from [?].sys.tables' Update: Based on comments received below I have updated this article. Thank you to all the readers. This is good example where something small like this have good participation from…
Read MoreSQLAuthority News – Interview of Author on 60 Seconds with Pinal Dave
Vijaya Kadiyala is my fellow .NET and SQL Expert and very respected member of the technology community in India. He is known for his easy but to the point attitude for technology. He regularly writes on his blog : DotNetVJ. I happen to meet him at MVP Summit in Seattle…
Read MoreSQL SERVER – Leading Zero to Number
I have received few emails asking how to prefix any number with zero. I have previously written two articles for the same subject. Please refer to my previous articles. SQL SERVER – Pad Ride Side of Number with 0 – Fixed Width Number Display SQL SERVER – UDF – Pad…
Read MoreSQL SERVER – Introduction to SQL Server 2008 Profiler – Summary
Introduction SQL Server Profiler is a powerful tool that is available with SQL Server since a long time; however, it has mostly been underutilized by DBAs. SQL Server Profiler can perform various significant functions such as tracing what is running under the SQL Server Engine’s hood, and finding out how…
Read MoreSQLAuthority News – Gandhinagar SQL Server User Group Meeting April 24, 2009
Gandhinagar SQL Server User Group launch event was held on March 27, 2009. This successful, well-attended event received very positive and warm community response. Visit Gandhinagar SQL Server User Group Portal and register yourself now! We are going to meet again this month on April 24, 2009 Friday from 6:30PM…
Read More