April « 2009 « SQL Server Journey with SQL Authority

Archive for April, 2009

SQL SERVER – FIX : ERROR : is not a valid Win32 application. (Exception from HRESULT: 0x800700C1)

Posted in Pinal Dave, Readers Question, SQL, SQL Authority, SQL Error Messages, SQL Query, SQL Security, SQL Server, SQL Tips and Tricks, T SQL, Technology on April 30, 2009 | 1 Comment »

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 IIS7. Fix/Solution/Workaround: Go to IIS. [...]

Read Full Post »

SQL SERVER – Solution to Puzzle – Shortest Code to Perform SSN Validation

Posted in Database, Pinal Dave, SQL, SQL Authority, SQL Puzzle, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology on April 29, 2009 | 4 Comments »

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 recently published his new book [...]

Read Full Post »

SQL SERVER – Introduction to SQL Server Encryption and Symmetric Key Encryption Tutorial with Script

Posted in Pinal Dave, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Security, SQL Server, SQL Tips and Tricks, T SQL, Technology, tagged SQL Server Encryption on April 28, 2009 | 58 Comments »

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 [...]

Read Full Post »

SQLAuthority News – Starting the SQL Journey – How Did I Get Started With SQL?

Posted in About Me, Pinal Dave, Readers Question, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News, SQLServer, T SQL, Technology on April 27, 2009 | 4 Comments »

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 his question. Jorge lives in [...]

Read Full Post »

SQL SERVER – List All the Tables for All Databases Using System Tables

Posted in Pinal Dave, Readers Question, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Server, SQL Stored Procedure, SQL System Table, SQL Tips and Tricks, SQLServer, T SQL, Technology, tagged undocumented SQL on April 26, 2009 | 24 Comments »

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 readers. Reference : Pinal Dave [...]

Read Full Post »

Older Posts »