Provides general guidelines to help you decide which type of antivirus software to run on the computers that are running SQL Server in your environment.
Other News
DOM Inspector as accessibility tool
(Alex Surkov) As you probably know DOM Inspector (aka DOMi) is Firefox add-on designed to inspect web pages and Firefox UI. In some sense it’s ancestor of Firebug but perhaps not so fancy and miss some useful features like integrated JavaScript console.
Pagination & Sorting as Usercontrol
(Merry Joseph) It is a control used to move to any pages that we need .We can set the page size of the grid using this control. We can sort any column in ascending and descending order by just clicking corresponding heading with this control. Using this control users can move to the first and last p
Index Organized Tables – PCTTHRESHOLD (The Wedding Song)
(Richard Foote) I’ve recently returned from a great two-week holiday, firstly at the Australian Open Tennis (what a final !!) and then up at the Gold Coast in not quite so sunny Queensland. Time now to get back to my blog.
Installing Oracle Unified Directory in silent mode
(Sylvain Duloutre) By default, the OUD installer runs in GUI mode. Alternatively, it is possible to install and setup OUD in silent mode.
A Beginner’s Guide to PLINQ
(V.N.S Arun) Language Integrated Query (LINQ) is a feature introduced in .NET Framework 3.5 which, helps in querying various data sources like the in-memory objects, SQL databases and XMLs.
Apex variables in SQL
(Scott Wesley) When I was first learning Application Express, I found one of the trickiest things was deciphering when to use which substitution string. Martin Giffy D’Souza succinctly describes variable reference options here.
SSIS – Delete files older than retention period from folder with parameter using Script Task in SQL Server
(Paresh Prajapati) After using some of the ways to delete the files from the particular folder like Delete file using Script Task and File System Task in SSIS. We have seen such methods and used logic to get the files from the loop container and process to delete them and same thing applied for the
Domain Context Query Loader
(Kelvin Armstrong) While in the process of working through multiple solutions requiring numerous queries from a different, inter-connecting, Domain Contexts, I required a mechanism of knowing when all the queries had completed.
DB2 z/OS Systems Tuning Tactics
(Lockwood Lyon) In the z/OS environment, tuning a DB2 subsystem may require the DBA and systems programmers to wear multiple hats and approach overall performance tuning from several different angles. What approaches are best in what situations?