SQL Server 2005 Integration Services Review | |
SQL Server 2005 Integration Services using Visual Studio 2005 A Beginner s Guide SQL Server 2005 A offering of Microsoft Corporation for database management the SQL server 2005 is one of the powerful database management systems in the world Available for integration in almost any system that uses Mi
|
|
Working with XML in Visual Basic | |
Working with XML in Visual Basic Extensive markup language and Visual Basic is the odd couple of the industry Visual Basic is one of the most common languages that are being used today This Microsoft introduced language was meant to be middle tier in characteristic but has managed to get the top tie
|
|
What are the differences between stored procedures and triggers? | |
Stored procedures are compiled collection of programs or SQL statements that live in the database. A stored procedure can access and modify data present in many tables. Also a stored procedure is not associated with any particular database object. But triggers are event-driven special procedures whi
|
|
Language Enhancements in SQL Server 2005 | |
The T-SQL has been enhanced to include error handling, recursive query and to support the new database engine capabilities.
Two new relational operators have been introduced—PIVOT and UNPIVOT for use in the FORM clause query. They perform manipulation on an input table valued expression an
|
|
Security enhancements in SQL Server 2005 | |
The trustworthy computing initiative has contributed greatly to help microsoft improve customer experience. A number of customer needs on security have been addressed.
1. Restricting user access to sql server
2. Disabling services and restricting service configuration
3. Reducing the surface are aof
|
|
Application Frameworks in SQL Server 2005 | |
The new application framework of SQL called the Service Broker is a distributed application framework that provides relable asynchronous messaging at the database to database level. It allows internal and external processes to exchange streams of reliable asynchronous messages using extensions of T-
|
|
ADO.NET new Features in SQL Server 2005 | |
The new features of ADO.NET are:
1. Query change notifications
2. multiple active result sets
3. Native type support
4. Notification support for SQL Server queries.
The above features make for greater flexibility and scalability and commands can now be sent to the SQL Server to request that a notifi
|
|
ITIL Framework | |
We have seen discussions concerning ITIL framework ever since the development of the methodology in the later years of the 1980’s. Over the last twenty plus years ITIL has quickly become the de facto standard in Service Management all over the world.
Oddly enough the ITIL started as a sim
|
|
The Interview Snafu | |
How to turn someone else’s mistake to your advantage
Your dream job is about to become reality. A recruiter gave you the heads up about the perfect position at Humungous Conglomerate, Inc. You went through five interviews as well as a battery of psychological tests mandated by their HR de
|
|
Winning a Job Interview with a Winning Resume | |
Does your resume unlock your potential, take your skills to the highest level and win you the interview and the job you want now? The job market today is highly competitive and even if you think you have what it takes to get an interview you won’t get over the line without a polished, prof
|
|
|
