January 2, 2009 8:46 PM
Posted by: Denny Cherry
Backup & recovery,
Database security,
JournalSpace.com,
SecurityFightClub,
SQL InjectionIn case you live under a rock and haven't heard about Journalspace.com's little mistake, they have gone out of business due to a database problem. Here's a
December 22, 2008 11:00 AM
Posted by: Denny Cherry
BIDS,
SQL Server 2008,
SSISUnlike in SQL 2005, when developing SSIS packages in SQL Server 2008 BIDS you must have the SSIS service installed on your workstation. This is a change from SQL Server 2005 where you did not have to have the actual SSIS service installed on your workstation.
It doesn't appear that you...
December 15, 2008 8:03 PM
Posted by: Denny Cherry
Quest Software,
SQLServerPedia.com,
WebcastI've been informed that the webcast I did last week with some of the other editors for SQLServerPedia.com has been archived for offline...
December 15, 2008 9:00 AM
Posted by: Denny Cherry
Back To Basics,
T/SQL,
XMLOne of the most popular ways to get data multiple pieces of data in a single parameter from one stored procedure to another, or from a client application to the database is to use XML. This can be done in SQL Server 2000 by using the NTEXT (or TEXT) datatype, and in SQL 2005 using the XML...
December 8, 2008 1:06 PM
Posted by: Denny Cherry
CREATE PROCEDURE,
SQL Server 2008,
T/SQL,
Table VariablesI would have to say, that one of the coolest new features of SQL Server 2008 is the ability to pass a table as a single parameter to a stored procedure.
While we have been able to do this in the past, by using XML to pass more than one value in, then break it apart. But this is just such a...
December 1, 2008 11:00 AM
Posted by: Denny Cherry
Article,
Clustering,
SQL Server 2005,
SQL Server 2008For those of you who are SQL Server Magazine Subscribers you should be getting your copies right about now (if you haven't already). When you do be sure to check out the article which I have in the magazine about clustering your SQL Server.
For those without a subscription you can sign up for...
November 30, 2008 11:15 PM
Posted by: Denny Cherry
SQLServerPedia.com,
WebcastGain access to SQL Server experts and learn more about SQLServerPedia.com by attending this webcast. SQLServerPedia.com is the free reference resource created for SQL Server professionals, by SQL Server professionals. See how...
