(Bipin Joshi) There are many articles and tutorials around that illustrate the use of GridView control along with the new Data Source Controls. When attached with a Data Source control GridView performs tasks such as paging, sorting and editing automatically i.e. without writing any code. However, a
Author: SSWUG Research
SQL Server 2005 Integration Services – Security – Part 28
(Marcin Policht) Concern for security permeates all facets of life these days. While this trend can be easily recognized by reviewing practically any major technological change in recent years, its presence is particularly prominent in the area of database management systems. We have presented some
Security information management challenges and solutions
(Samantha Tran and Manoj Mohan) Managing secure information is one of the most difficult tasks to implement and maintain effectively. In the current network-centric business model it is becoming increasingly difficult to validate a person’s identity, control access, and maintain integrity and privac
Learn PL/SQL: Declaring Variables, Named vs Anonymous Blocks
(Lewis R Cunningham) This is part 2 of a series on learning PL/SQL. If you are new to PL/SQL, you should read part 1 first. Also, check out the Article Index.
How do I prevent linked server errors?
Many of us use systems where multiple SQL Servers need to talk to each other over the network. But nobody’s network is perfect. Sometimes the linked server is down, sometimes the link between them is down, sometimes another user changed the login credentials. Whatever the case, you need to be prepar
Regulatory compliance and the DBA: What you need to know
(Steve Lemme) At the top of business executives’ minds today is how to meet new regulatory compliance and corporate governance rules. New laws are changing the way companies collect, retain and manage information. DBAs need to understand what is happening in the corporate business world and how it w
Efficient development means knowing when to learn a new tool and when not to
(Robert L. Bogue) It seems like everyone likes a full toolbox. Whether you’re an auto mechanic with thousands of dollars in hand tools or an IT professional who knows every database technology ever written, tools are a good thing. Knowing how to use a tool can be the difference between struggling wi
Developers Working to Overcome AJAX Accessibility Issues
(Darryl K. Taft) Despite providing slick advantages over standard Web application techniques, AJAX presents accessibility issues for some users. Developers, however, are working to address the problem.
Extensible Markup Language (XML) Tutorial – Introduction
(Gez Lemon) The Extensible Markup Language (XML) is a subset of the Standard Generalised Markup Language (SGML), the standard for creating markup documents. Unlike HTML, another markup language based on SGML, XML allows you to describe data and its structure rather than display it. XML is not a repl
Growing Number of Object Attributes – Part II
(Eugene Asahara) A few weeks ago, I posted a blog similarly titled, Growing Number of Object Attributes in Relational Databases. In that blog, I described the problem of “vertical data explosion” occurring due primarily to increased data mining, where more and more characteristics (or attributes) of