(Eric Herber) Relational database servers build the information backbone for many companies today. These companies rely on the smooth operation of their database servers and any outages could have an great impact on their business. Keeping that in mind, backup is one of the most critical aspects for
Author: SSWUG Research
Security Steps for Strong Authentication
(Sonu Chauhan) Weak authentication increases the identity spoofing threat. If a user’s logon credentials fall into the wrong hands, an attacker can spoof the user’s identity and gain access to the application. The attacker shares all of the user’s privileges in the application. Credentials must be p
Exporting Data from SQL to Access in Mdb File
(Yashwant Shukla) I was working on a Web Application in which client requested to keep backup of the Application DataBase in the Form of Access data in a MDB file for that i tried DTS package but the Database Server for application was kept on remote server where the host was not ready to provide ri
Using Master Pages in ASP.Net 2.0
(Peter Aitken) Many web sites follow a plan in which most of the pages have certain content in common, such as a header and footer. As the user navigates from page to page, only the content in the main part of the page changes.
Don’t Use Select *
(John Fuex) Something you see in a lot of database access code is a select statement that looks something like this: SELECT * FROM TableName WHERE …
Gather Windows system details and store in SQL Server 2005 Express with this VBScript
(Scott Lowe) Monitoring your servers and network can run from cheap to way-too-expensive-to-bother, and it can run from simple to way-too-hard-to-care. Unfortunately, as the profile of Information Technology is raised and systems become more integrated, it’s critical to be able to provide some sembl
Databases Programming in Python: Accessing MySQL
(A.P.Rajshekhar) While data storage for applications is no longer considered complex, it is now simplified to the point that flexibility is sacrificed. There is a good compromise, however. In this article, you will learn how to access a a MySQL database with Python.
Mastering OLAP Reporting: Meet Business Needs with Matrix Dynamics, Part 1
(William Pearson) As I have shown in many past articles, the Microsoft Integrated BI Solution, consisting of the MSSQL Server 2005 Database Engine, Analysis Services 2005 and Reporting Services 2005, provides unprecedented flexibility in helping implementers and developers to meet client and employe
Part I: Understanding the SQL Server 2005 XML Data Type
(Srinivas Sampath) XML has been widely adopted as a platform-independent mechanism for representing data, and is also commonly used to exchange data between disparate and loosely-coupled systems, such as B2B applications and workflow solutions. More recently, XML has been used to represent semi-stru
DataStage tip for beginners: developer short cuts
(Vincent McBurney) People who have been using a tool for a long time learn some shortcuts. I’ve done a brain dump of any DataStage short cuts I can remember.