As we briefly mentioned in the previous installment of this series, among features introduced in the SQL Server 2005 Integration Services there are For and ForEach loops, implemented in the form of containers that can be incorporated into the Control Flow part of a package design.
2005-07-12
1,793 reads
The Microsoft .NET 2.0 platform introduces a new namespace called System.Transactions that brings in a lightweight, simplified transaction model. This article discusses the shortcomings of current transaction models and introduces System.Transactions for .NET Framework 2.0 beta 2.
Currently there are two transaction models available in the .NET world, both of which are suited for certain situations. The first is part of the rich ADO.NET data providers. The second is the enterprise services transaction. Before we examine System.Transactions, let’s have a look at the current models.
2005-07-11
2,446 reads
The term “Enterprise Metadata Management” has been in use since the late 1980’s when many of us worked in classic “mainframe environments” using “corporate data dictionaries” to manage our COBOL programs, Job Control Language (JCL), screens, reports, copybooks, and database schema definitions. Fast-forward to 2005 ~ has anything changed? What does “enterprise metadata management” mean today ? I recently surveyed a number of leading metadata management vendors, Global 5000 companies, and industry thought-leaders seeking their input.
2005-07-08
2,007 reads
In the race to secure data, one basic measure – encryption – is often overlooked. Philip Basham takes a look at the ramifications of data loss and how it can be prevented.
2005-07-07
1,748 reads
Kimberly L. Tripp talks about indexing best practices and what developers should know about SQL Server management. She also discusses stored procedure and parameterized queries caching, the new availability features in SQL Server 2005, and the SQL Server CLR.
2005-07-06
2,440 reads
In the beginning, there was the recordset, a central feature of classic ADO. Like a Swiss army knife, it wasn’t the perfect tool for every job, but given the correct configuration, it could do whatever you needed it to do.
The recordset wasn’t always pretty to watch, however, and it came into prominence at a time when client/server applications for which it was optimized were being replaced by web applications. Its dark side included an amazing level of complexity and the number of special cases when it was used with particular providers.
2005-07-05
4,419 reads
Bob Beauchemin is a developer who not only writes code and develops databases, but also teaches other developers to create applications and databases, often using the latest Microsoft technologies.
Bob has more than 25 years of experience working with IBM mainframes and Unix boxes, as well as Windows-based PCs. He has taught a number of database courses for DevelopMentor, a hands-on training company for experienced developers, and has given instruction on writing .NET web services and creating applications and components using C#.
2005-07-04
2,069 reads
You can monitor the system performance by using the Performance monitor console and its related counters in Windows 2000. These counters allow you to view or save information about the overall performance of your server. When you install Microsoft SQL Server, additional Performance monitor objects and counters are automatically installed. While you must have administrative access to your SQL Server to use these objects, SQL Server admins should find them invaluable in monitoring and tuning the database server. Furthermore, the Performance monitor can be used either locally or remotely, which allows admins greater control in monitoring SQL Server.
2005-07-01
3,715 reads
In Part 1 I covered a simple stored procedure that printed the current date. In this article I'll cover writing a stored procedure to return a recordset back to the client. In the process we'll learn a little bit more about .NET and C# including the SqlConnection, SqlCommand and SqlDataReader classes.
2005-06-29
3,601 reads
See an example of using the Many-to-Many dimension in SQL Server 2005 Analysis Services to analyze sales data, and get ideas for other uses such as treating medical conditions, software testing, and more.
2005-06-28
2,289 reads
By Steve Jones
With the AI push being everywhere, Redgate is no exception. We’ve been getting requests,...
By Steve Jones
fawtle – n. a weird little flaw built into your partner that somehow only...
AWS recently added support for Post-Quantum Key Exchange for TLS in Application Load Balancer...
Comments posted to this topic are about the item Semantic Search in SQL Server...
Comments posted to this topic are about the item Encoding URLs
Comments posted to this topic are about the item An SSIS Upgrade
I have this data in a table:
CREATE TABLE Response ( ResponseID INT NOT NULL CONSTRAINT ResponsePK PRIMARY KEY , ResponseVal VARBINARY(5000) ) GOIf I want to get a value from this table that I can add to a URL in a browser, which of these code items produces a result I can use? See possible answers