|
|
|
|
|
Total Hits: 33 | Today: 0
|
Author: John C. Hancock
|
Rating:
|
|
Flexible reporting capabilities are a requirement for most business applications and their integration into Web apps makes them more versatile than ever. With the recent release of SQL Server™ 2000 Reporting Services, you can easily add reporting from diverse data sources. In this article I will introduce report authoring using Visual Studio® and Reporting Services and demonstrate how to integrate reports into your Web applications....
|
|
|
|
Total Hits: 50 | Today: 0
|
Author: Scott Baldwin
|
Rating:
|
|
In my previous article SQL Server Express (Part One) - Another reason to move your user applications onto a stable platform, I presented a common problem in development, and gave the 4000 foot overview of how SQL Server Express (SSE) attempts to solve the problem with user instances, in part 2 I want to dive a bit further under the hood and discuss how user instances work. I also want to make it clear what restrictions are placed on SSE and what this means to applications running against it....
|
|
|
|
Total Hits: 63 | Today: 0
|
Author: SQL Server Engine Tips
|
Rating:
|
|
SQL Server 2005 SP2 has an important enhancement to OBJECT_NAME metadata function and a new OBJECT_SCHEMA_NAME metadata function. I will first describe the old functionality to give some context and demonstrate how the new features help a lot.
Please note that the examples uses DMVs that looks at metadata in each database or plan cache so performance of the queries depends on your environment, number of objects in the database, auto open/auto close setting of database, size of buffer pool or ...
|
|
|
|
Total Hits: 168 | Today: 0
|
Author: Alex Papadimoulis
|
Rating:
|
|
In most installations, SQL Server acts as the bottom layer in a standard application stack (user interface, middle tier, and database). Users rarely know what type of database they're using, let alone access and use it directly. For this reason, database security configuration is minimal, and often lax. Sometimes only an easy-to-guess username and password sit between the database and the middle tier....
|
|
|
|
Total Hits: 281 | Today: 1
|
Author: Alexander Kuznetsov, Rajiv Rajak
|
Rating:
|
|
Sometimes we developers put unnecessary burden on the server, having it perform too many sorts or sort more data than necessary. By applying the techniques described in the following sections to your design and coding practices, you'll reduce the number of sorts your server performs—and provide your users with much better response times....
|
|
|
|
Total Hits: 32 | Today: 0
|
Author: Microsoft Corporation
|
Rating:
|
|
Learn how to apply the new tracing functionality in Microsoft data access technologies such as ADO.NET 2.0, MDAC 2.82, SQL Server Native Client, and the JDBC driver; and in the SQL Server network protocols and the Microsoft SQL Server 2005 database engine....
|
|
|
|
Total Hits: 25 | Today: 0
|
Author: Stacia Misner
|
Rating:
|
|
This article presents an excerpt from the book, Microsoft SQL Server 2005 Reporting Services Step by Step, by Stacia Misner and Hitachi Consulting. Learn how to monitor reporting services by implementing an execution logging database and reviewing reports that query that database. (...
|
|
|
|
Total Hits: 27 | Today: 0
|
Author: Fang Wang
|
Rating:
|
|
This white paper covers best practices on report design and helps you avoid common mistakes when choosing a report layout and output format. Take advantage of existing product features to achieve the results you want. The paper includes report and code examples that implement functionality that is frequently requested....
|
|
|
|
Total Hits: 38 | Today: 1
|
Author: Ed Hild
|
Rating:
|
|
Imagine you work for a company that has a critical database application that continually records new incoming information. This database could be storing order information, sales contacts, or just about any other kind of data. Now consider that a group of individuals within your company rely on reports about this data—perhaps trend analysis of monthly billing statements—for making key business decisions. These reports are created on a schedule: daily, weekly, or monthly. Sound familiar? Chances ...
|
|
|
|
Total Hits: 46 | Today: 1
|
Author: John Magnabosco
|
Rating:
|
|
Filtering is an important aspect of writing most complex queries. While there may be instances where you don't need a filter, such as a simple query that retrieves a list of all U.S. states, in the majority of cases you need to filter the data to a more precise set. For example, you might need to obtain a list of all U.S. states that begin with the letter "I."
Developers and DBAs have many operators available to perform such filters. Query performance is definitely a very high considerati...
|
|
|
|
Total Hits: 97 | Today: 0
|
Author: Scott Mitchell
|
Rating:
|
|
In the previous tutorial we saw how to use the SqlDataSource control to retrieve data directly from a database. Using the Configure Data Source wizard, we could choose the database and then either: pick the columns to return from a table or view; enter a custom SQL statement; or use a stored procedure. Whether selecting columns from a table or view or entering a custom SQL statement, the SqlDataSource control’s SelectCommand property is assigned the resulting ad-hoc SQL SELECT statement and it i...
|
|
|
|
Total Hits: 63 | Today: 0
|
Author: Kevin S. Goff
|
Rating:
|
|
Microsoft implemented many new features in SQL Server 2005, including an impressive set of language enhancements. From new language statements for SQL-99 compatibility to new features in response to customer requests, Transact-SQL 2005 helps to increase developer productivity. This article covers most of the new language features by posing a statement/scenario and then provide some code samples to show how you can use T-SQL 2005 to address the problem....
|
|
|
|
Total Hits: 22 | Today: 0
|
Author: Alexander Chigrik
|
Rating:
|
|
Shared (S) locks are used for operations that read data, such as a SELECT statement. During Shared (S) locks used, concurrent transactions can read (SELECT) a resource, but cannot modify the data while Shared (S) locks exist on the resource. If you do not use the HOLDLOCK locking hint and your transaction isolation level is not set to REPEATABLE READ or SERIALIZABLE, the Shared (S) locks on a resource are released as soon as the data has been read. If you use the HOLDLOCK locking hint or your tr...
|
|
|
|
Total Hits: 147 | Today: 0
|
Author: David Hayden
|
Rating:
|
|
The other day I had this epiphany that my Database Explorer and Code Generator needed to physically create stored procedures in SQL Server 2005 as opposed to just creating scripts that would create stored procedures. This led me down a path where I discovered SQL Server Management Objects (SMO) that are available with SQL Server 2005 and allow me to create stored procedures in SQL Server 2005 programmatically using C# ( and VB ). I created a post that provided a short snippet on how to create ...
|
|
|
|
Total Hits: 60 | Today: 0
|
Author: Brian Mains
|
Rating:
|
|
SQL Server Integration Services (SSIS) in SQL Server 2005 has been redone, and is clearly superior over SQL Server 2000. With all of the new capabilities and features in SSIS, it is possible to create very complex transformation packages. This article will show you how to take advantage of the control flow features....
|
|
|
|
Total Hits: 92 | Today: 0
|
Author: Narayana Vyas Kondreddi
|
Rating:
|
|
While browsing the SQL Server newsgroups, every once in a while, I see a request for a script that can search all the columns of all the tables in a given database for a specific keyword. I never took such posts seriously. But then recently, one of my network administrators was troubleshooting a problem with Microsoft Operations Manager (MOM). MOM uses SQL Server for storing all the computer, alert and performance related information. He narrowed the problem down to something specific, and neede...
|
|
|
|
Total Hits: 109 | Today: 0
|
Author: Dinesh Asanka
|
Rating:
|
|
You may have wondered how to add, drop, or alter (type or size) a column of a table that is an article of a publication. I have seen this question in many forums and discussion boards. Obviously, dropping the replication, making the necessary changes, and then recreating the replication is not efficient. Your customers may not even allow you to drop the replication, as this method will virtually shut down the system. In today's competitive environment, you cannot afford to shut down your system ...
|
|
|
|
Total Hits: 133 | Today: 0
|
Author: Serge Rielau
|
Rating:
|
|
Do you want to learn some tricks for tuning SQL procedural language? This article describes common examples for tuning SQL procedures in IBM DB2 UDB V8.2 for Linux, UNIX, and Windows, with a special focus on procedures ported from other database management systems. The SQL procedural language (SQL PL) is a popular tool in many DB2 developers' toolboxes. This is true even more so when migrating or porting an application from Oracle, Sybase, or Microsoft® SQL Server to DB2....
|
|
|
|
Total Hits: 205 | Today: 0
|
Author: Tony Patton
|
Rating:
|
|
I once was pulled into a discussion about the merits of stored procedures versus placing SQL directly in the code. The atmosphere resembled a heated political debate, with each side presenting valid points. Here are both sides of the discussion. It's rare to tackle a development project that doesn't interact with a backend data source. After all, data is the lifeblood of an organization. When you create an application with a backend database like SQL Server, the Transact-SQL (T-SQL) programming ...
|
|
|
|
Total Hits: 79 | Today: 0
|
Author: ExtremeExperts.com
|
Rating:
|
|
Have you ever imagined that you can write a spell checking mechanism in SQL Server 2000? Take a deep breath. In this article I will show you some cool features that SQL Server has and how we maximize the same. If I were to walk you through the concept, it is quite simple. All we need to invoke is the spell checker method available in Word application and use its capability for doing such tasks....
|
|
|
|
|
|
