If you store this information as plain text, unscrupulous users can easily steal the data either through online SQL queries or by scanning the files on the database server's hard drive. Microsoft ...

SQL Server 2005 or later script to generate TRUNCATE statements for all tables. Anyone that has tried this on anything but the most simplistic database has found, as I did, that this won't work. Any ...

To query any SQL database from PowerShell, you need to have the SQLPS module installed along with a few supporting packages. I am going to be focusing on the SQL Server 2012 packages in this article.

SQL Server tip No. 3: Use strongly typed input variables in your stored procedures. This is another must for Web applications. The biggest threat to Internet-exposed databases is ad hoc queries.

The Connection Properties dialog opens. For my sample ITworld application, I changed the data source to Microsoft SQL Server (SQLClient), and entered the necessary Server, Log On, and database values.