By Eric Knorr – For conclusive evidence, look no further than the staid, slow-moving world of relational database management, which is embracing XML as its own.
Tag: sql server
Yukon to Hit Beta in 2002, 64-bit SQL 2K On Tap
Yukon is the version of SQL Server that will bring .NET, the Common Language Runtime environment and XML much deeper into the plumbing of the database engine and build in considerable scale-up engineering. SQL Server 2000 had some native capability for importing XML documents and doing qu
Programming ADO SQL Server Applications
Microsoft® ActiveX® Data Objects (ADO) is a data access interface used to communicate with OLE DB-compliant data sources, such as Microsoft SQL Server™ 2000. Data consumer applications can use ADO to connect to, retrieve, manipulate, and update data from an instance of SQL Server.
Inserting Images ( binary data ) into Database
In this tutorial you are going to learn everything in detail step by step you’ll ever want to know about inserting binary data ( images, zip files etc ) into database. This is actually first of the three articles I am going to write on manipulating binary data in the database.
Auditing Your SQL Server Environment, Part II (Reviewing Role Memberships)
by Randy Dyess – This article is the second article in a series to share those stored procedures and methods I have learned with you, in order to help you document and learn a new environment if you move on, or obtain another project at your existing company.
SQL Server CE 2.0 Might Foster the Killer App
By Brian Moran – Microsoft’s new .NET Compact Framework and SQL Server CE 2.0 might encourage the development of killer apps for mobile devices that even SQL Server administrators couldn’t live without.
Moving from Access to SQL Server
By Jorge Cano – These kinds of tasks are a little more complex because we have to take care of the objects that we’ll move (or migrate) from Access to SQL Server. SQL Server has some tools and wizards that can help you, like the Enterprise Manager, Query Analyzer and others. SQL Server does not mana
Take Advantage of SQLXML with ASP.NET
Randy Holloway explains how to use SQLXML 3.0 with SQL Server to expose Web services through your ASP.NET applications by executing T-SQL stored procedures and user-defined functions.
Utilizing Parameters in SQL Stored Procedures
By Bruce Johnson – By now, you have listened to reason and are utilizing stored procedures when working with you database. Assuming that you’re not using Access, that is. The reasons for taking advantage of stored procs are both numerous and beyond the scope of this articles. Just trust me on this o
Accessing Data From SQL Server
By Subhagata Swarnakar – Among the many things that are changing with .NET is data access. Under the .NET Framework, data access is handled by a set of classes called ADO.NET which are essentially an augmentation of the existing ActiveX Data Objects (ADO).The ADO.NET components have been des