(Chris Eaton) I thought I would start the year with some basics as I have had a lot of people asking me to cover off some of the basics of backup and recovery.
Other News
Simplify DB2 for i5/OS index advice
(Scott L. Forstie) DB2 for i5/OS on V5R4 has been enhanced to include an index advice condenser feature to simplify the analysis of index advice from the query optimizer. Index advice is accumulated as it occurs based upon query and SQL activity. Much of the raw index advice generated by DB2 has som
Windows Workflow Foundation Essentials
(Kevin McNeish) It can be tough keeping up with all the new technologies released by Microsoft, but Windows Workflow Foundation (WF) is a technology you do not want to miss. This article demonstrates the benefits of Windows Workflow and invites you to roll up your sleeves and get started creating yo
The SQLCMD workbench
(Robyn Page and Phil Factor) There are two ways of using SSMS to automate repetitive tasks that involve TSQL. One is by the use of templates. This gives you a ready-made library of standard routines that you can turn into executable TSQL simply by hitting Ctrl Shift M on the keyboard. Great for ad-h
VBScript Date Functions
(James Payne) In our previous article we talked about loops and touched briefly upon creating your own functions. As you know, VBScript comes packed with its own pre-defined functions (like our buddy document.write), and in this article we are going to cover most, if not all, of the Date Functions.
ASP.NET Multiple File Uploader
(Govardhana Reddy) There are many situations when a developer wants to allow a user to upload more than one file. Currently you may be stuck with either adding as many file input elements as the number of files you want to upload, or possibly having new ones appear ‘magically’ through Javascript.
Archiving Data with SQL Server 2005
(Vinod Kumar) Though HDD prices have fallen well beyond imagination, archiving of data and keeping the database to a manageable size is a concern for all organizations. Storing obsolete data online reduces the performance of a database server. A well-designed archival strategy minimizes the performa
Security: Using the Command Line
(Buck Woody) I’m continuing my series on the concepts behind SQL Security. In the previous entries I’ve explain SQL Server logins and database logons, and I’ve given you the basics on object and statement permissions.
Back Up Compression Option in SQL Server 2008
We have been covering the new features of the upcoming release of the next version of SQL Server. You can search on gSQL Server 2008 on this blog and get to those posts. In this post, we will briefly cover the back up compression option that has been introduced in SQL Server 2008. All this code i
New datetime datatypes in SQL Server 2008
(Muthusamy Anantha Kumar) From the beginning, Microsoft SQL Server DBAs have longed for two different datatypes, where you could store time and date separately. The long wait is over. In all of the older versions, we had only one data type that could store Datetime datatype, and it stored both the v