SQL 2000 User Defined Function Primer
Many programming languages have supported User Defined Functions for years, but they are new to SQL Server 2000. In this article we will look at some of the ways functions can be used within SQL Server 2000.
Working with Image Objects in InfoPath 2003 and SQL Server 2000
You can use features in Microsoft Office InfoPath 2003 Service Pack (SP) 1 to work more efficiently with image objects and other data. Learn how to use BLOB data types to work with data stored in a Microsoft SQL Server 2000 database from an InfoPath form. InfoPath 2003 provides a robust and rich interface to store and access data in SQL Server databases. Learn about best practices for integrating SQL Server databases and InfoPath form data, with an illustrative example.
Versioning
How many times has an application exploded because you upgraded or patched SQL Server? How many people were aware that a patch was applied? New author Andre Vigneau has dealt with this and gives us some code that our applications can use to check to see if anything has changed. It doesn't keep the code working, but it does allow you to inform users that something has changed.
MDX Essentials: Basic Set Functions: The EXTRACT() Function
This is the twenty-fourth article of the series, MDX Essentials. The series is designed to provide hands-on application of the fundamentals of the Multidimensional Expressions (MDX) language, with each tutorial progressively adding features designed to meet specific real-world needs.
Review - dbMaestro
Version control in SQL Server is fairly immature, to put it nicely. Fortunately it's also an area that a number of vendors are working to make smoother. Dinesh Asanka looks at dbMaestro, a tool from Extreme Technologies to help you track changes in multiple databases.
Restore multiple DTS packages
This article examines how to take advantage of VB Script and MS-DOS batch files to restore multiple DTS packages stored in the form of structured storage files from one folder to a SQL Server box.
Implementing a Flexible Backup Strategy
SQL Server has a rock solid backup routine that works every time. However the schemes used to implement backups with maintenance plans, Enterprise Manager, etc., are not a smooth or as flexible as what most people require. Author Eli Lieba brings us his strategy and code for ensuring that each database is backed up how he needs it to be, whether a full or differential backup.
SQL Server 2000 Security - Part 13 - SQL Injection attack
Typically, access to data is provided via client applications, which increases the range of potential vulnerabilities and places an equal share of responsibility for data security on software developers. This is especially important since application flaws can have just as catastrophic implications as a misconfigured or unsecured SQL Server installation.
Custom String Functions
SQL Server's Data Transformation Services (DTS) is a fantastic tool for importing data from any type of source. However even with this tool, you sometimes need more flexibility than it appears to have, especially if the data formats are unknown far enough in advance. New author Chris Cathers has developed a technique that allows him to be extremely flexible without causing too many headaches down the road.
Query Notifications in ADO.NET 2.0
Learn how to use the new notification technologies in ADO.NET 2.0 and SQL Server 2005 to handle ad-hoc data refreshes.
Blogs
Plan Time for Self-Development
By Brian Kelley
As you begin the new year, if you don't already have time set aside...
BK’s Bookshelf: Never Split the Difference
By Brian Kelley
I picked up Never Split the Difference: Negotiating As If Your Life Depended On...
Replacing Images in PBIR Format Reports
With the PBIR format of Power BI reports, it’s much easier to make report...
Forums
The Learning Plan for 2025
Comments posted to this topic are about the item The Learning Plan for 2025
Leveraging the “STUFF” Function for Enhanced Data Representation and String Manipulation
Comments posted to this topic are about the item Leveraging the “STUFF” Function for...