programming4us
programming4us
DATABASE
Change page: < 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 >  |  Displaying page 14 of 16, items 521 to 560 of 625.
OData with SQL Azure - Enabling OData on an Azure Database
When you first look at OData and its interoperation with SQL Azure, you may think you're in for a lengthy process and a ton of reading. Wrong. Enabling OData is simple and takes no time at all.
OData with SQL Azure - OData Overview
OData stands for Open Data protocol. It's a REST-based web protocol for querying and updating data completely independent of the platform or source.
SQL Server 2008 : Performing Nonlogged DML Operations
Most DML operations are logged operations. When an operation is logged, data about the operation is stored in the SQL Server transaction log. The transaction log files can be backed up and replayed into an earlier database backup.
SQL Server 2008 : Using the OUTPUT Clause with the MERGE Statement
The OUTPUT clause is of great value when used with the MERGE statement. Because the MERGE statement can perform multiple actions depending on the results of a join, it is hard to tell what data was updated, what data was inserted, and what data was deleted.
SQL Server 2008 : Returning Data from DML Operations Using the OUTPUT Clause
The OUTPUT clause is a very powerful feature of INSERT, UPDATE, DELETE, and MERGE DML statements. This clause allows you to return information about the data affected by a DML statement.
SQL Server 2008: Working with System Databases
The first thing you come across when opening the Databases folder in the Object Explorer is a folder called System Databases.
SQL Server 2008 : Using @@IDENTITY and NEWID Functions in DML Statements
Using automatically incrementing IDENTITY columns is very popular with database developers. You don’t need to explicitly calculate unique surrogate keys when inserting new data; the IDENTITY column functionality does that for you.
SQL Server 2008 : Using Advanced Functionality with DML - Introduction
The use of DML is not limited to DML queries. Usually, database developers create stored procedures that encapsulate DML statements.
Defensive Database Programming with SQL Server: The Ticket-Tracking System (part 2) - Removing the performance hit of ON UPDATE CASCADE
We need to discuss in a little more detail the ON UPDATE CASCADE behavior and its performance implications. Whenever a developer's status changes, the corresponding DeveloperStatus column in the Tickets table changes automatically, for all the tickets assigned to that developer
Defensive Database Programming with SQL Server: The Ticket-Tracking System (part 1) - Enforcing business rules using constraints only
Here, we'll re-implement these business rules using only constraints and, in addition, we'll be able to enforce the rule that "newly added active tickets cannot be assigned to a developer on vacation," which would have required an additional AFTER INSERT trigger.
SQL Server 2008 : Working with DML Queries - Using the MERGE Statement
The MERGE statement is new in SQL Server 2008. It allows you to synchronize one table with another. This is achieved by performing INSERT, UPDATE, and DELETE operations on a target table based on the results of a join with a source table
Defensive Database Programming with SQL Server : Client-side Error Handling
In order to overcome the described limitations and difficulties with error handling using SQL Server's TRY...CATCH, my advice is simple: when we need to implement feature-rich error handling to respond intelligently to an anticipated error, we should do it in a language that offers more robust error handling, such as C#.
SQL Server 2008 : Working with DML Queries - Using the DELETE Statement
The DELETE statement deletes existing rows from an existing table or updateable view based on a given criteria.
Programming Microsoft SQL Server 2005: Using Data Mining Extensions (part 2) - Data Mining Predictions Using DMX
DMX is a powerful tool for mining structure and mining model DDL queries, but you can also use it to write what are arguably data mining’s most valuable asset: prediction queries.
Programming Microsoft SQL Server 2005: Using Data Mining Extensions (part 1) - Data Mining Modeling Using DMX
DMX can be used to create, modify, and train the same mining structures and models as those created using the Data Mining Wizard and modified using the Data Mining Designer
SQL Server 2008 : Working with DML Queries - Using the UPDATE Statement (part 2)
SQL Server 2008 provides a capability to append or insert text into existing text columns as part of the UPDATE statement. This is achieved using the column. WRITE expression.
SQL Server 2008 : Working with DML Queries - Using the UPDATE Statement (part 1)
The UPDATE statement updates existing rows in an existing table or updateable view. Let’s examine the syntax of the UPDATE statement.
Azure Programming Considerations
The service will fire up and what you see is a REST (Representational State Transfer) based service on top of your relational database, a mere XML representation of the service and the entities exposed via the service
Programming with SQL Azure : Record Navigation in WCF Data Services
The service will fire up and what you see is a REST (Representational State Transfer) based service on top of your relational database, a mere XML representation of the service and the entities exposed via the service
Defensive Database Programming with SQL Server : TRY...CATCH Gotchas (part 2) - TRY...CATCH blocks cannot catch all errors
Interestingly enough, sometimes TRY...CATCH blocks just do not catch errors. This sometimes represents "expected behavior;" in other words, the behavior is documented and the reason why the error is not caught, for example when a connection fails, is intuitive.
Defensive Database Programming with SQL Server : TRY...CATCH Gotchas (part 1) - Re-throwing errors
In many cases, we do not wish to handle certain errors in our CATCH block, and instead want to re-throw them, so that they are handled elsewhere.
SQL Server 2008 : Working with DML Queries - Using the INSERT Statement (part 2)
Sometimes, instead of the list of values, you may wish to insert results of a subquery into your existing table. In this case, you will not use the VALUES clause. Instead of the VALUES clause you will use the INSERT statement with the SELECT clause.
SQL Server 2008 : Working with DML Queries - Using the INSERT Statement (part 1) - Using the INSERT Statement with the VALUES Clause
The table_or_view is the name of the table or view into which you wish to insert the data. As well as tables and views, you can also use a table-valued variable.
Programming Microsoft SQL Server 2005: Using the Data Mining Wizard and Data Mining Designer (part 7) - Nested Tables
Nested tables are perhaps one of the most confusing features of SSAS data mining. Once you understand them, however, they will likely become an integral component of your data mining toolset.
Programming Microsoft SQL Server 2005: Using the Data Mining Wizard and Data Mining Designer (part 6) - Validating and Comparing Mining Models
We have processed the mining models and analyzed their predictive contents, which, though similar, are not identical. Although it is easy to conclude that being a long-time customer is an important determinant of customer profitability, the models differ somewhat in their conclusions about which other customer characteristics or buying behaviors are important indicators of profitability
Programming Microsoft SQL Server 2005: Using the Data Mining Wizard and Data Mining Designer (part 5) - Viewing Mining Models
SSAS provides algorithm-specific mining model viewers within Visual Studio Analysis Services projects (and in SQL Server Management Studio—more on that later) that greatly ease the otherwise daunting task of interpreting a model’s contents, observed patterns, and correlations.
Programming Microsoft SQL Server 2005: Using the Data Mining Wizard and Data Mining Designer (part 4) - Deploying and Processing Data Mining Objects
We have done a good bit of work already, having defined a mining structure with several mining models. We are almost ready to view and query the models, but we must first deploy and process the SSAS database that contains them.
Programming Microsoft SQL Server 2005: Using the Data Mining Wizard and Data Mining Designer (part 3) - Editing and Adding Mining Models
With your mining structure and first mining model created, you are ready to create additional models within the structure. On the Mining Models tab of the data mining structure designer, you can view the definition of your mining model, as shown in Figure 5
Programming Microsoft SQL Server 2005: Using the Data Mining Wizard and Data Mining Designer (part 2) - Creating a Mining Model
SSAS has two types of tables for use in mining models: case tables and nested tables. Every mining structure must have a case table. Simply put, the case table defines the entities to be analyzed for your mining model
Programming Microsoft SQL Server 2005: Using the Data Mining Wizard and Data Mining Designer (part 1) - Creating a Mining Structure
Mining models in SSAS are contained within mining structures. A mining structure consists of a subset of columns from your DSV and one or more mining models that use the columns.
Microsoft SQL Server 2005 : Report Management
Completed report definitions are loaded to a report server, where they can be accessed and subscribed to. The process of loading the report is referred to as publishing.
Microsoft SQL Server 2005 : Report Definition and Design (part 5) - Report Builder
Report Builder is an ad hoc reporting tool delivered as a .NET 2.0 ClickOnce application that a user downloads from the report server. Predesigned report templates are used as a design surface, with drag-and-drop placeholders for data.
Defensive Database Programming with SQL Server : Using TRY...CATCH blocks to Handle Errors
To handle errors in T-SQL modules, in SQL Server 2005 and upwards, we can use TRY...CATCH blocks. If any command inside the TRY block raises an error, the execution of the TRY block terminates immediately, which is similar to the behavior under the XACT_ABORT setting
Microsoft SQL Server 2005 : Report Definition and Design (part 4)
The Treeview control on the left has a list of syntax categories. Select one of these to fill the center list of syntax options. The description on the right panel explains how to use each feature.
Microsoft SQL Server 2005 : Report Definition and Design (part 3)
The Data subtab for a report definition manages datasets. You can edit existing datasets or add new ones using the Dataset drop-down list at the top left of the dialog box. Each dataset has a name, data source, and other information specific to the command type and selected data source type.
Microsoft SQL Server 2005 : Report Definition and Design (part 2) - Business Intelligence Development Studio
Report Designer is installed as part of Business Intelligence Development Studio (BI Development Studio), which comes standard with SQL Server 2005. BI Development Studio is really a slimmed-down version of Visual Studio.
The SQL Programming Language : Creating Tables and Entering Data
Using SQL for querying is important—even for the beginner—because of SQL's power and flexibility. Using SQL, it is also possible to create tables, insert data into them, update data in them, and delete data from them.
Microsoft SQL Server 2005 : Report Definition and Design (part 1) - Data Sources
Data sources can be specific to a single report or shared across multiple reports. Reports can contain one data source or many. Specific data sources are defined in the RDL file for that report. Shared data sources are stored in a separate file structure in the development environment and on the report server.
The SQL Programming Language : Complex Queries and Join Queries (part 4)
In this section, the use of built-in functions and calculated columns is illustrated with join queries. Recall that the Movie and Role tables are in a one-to-many relationship, with the primary key of the Movie table, movieID, embedded as a foreign key in the Role table.
The SQL Programming Language : Complex Queries and Join Queries (part 3)
GROUP BY and HAVING can be combined with a join query. For example, suppose you wanted to find the titles of movies, along with the number of roles in them, grouped by title and having at least five roles
 
Top 10
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Finding containers and lists in Visio (part 2) - Wireframes,Legends
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Finding containers and lists in Visio (part 1) - Swimlanes
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Formatting and sizing lists
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Adding shapes to lists
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Sizing containers
- Microsoft Access 2010 : Control Properties and Why to Use Them (part 3) - The Other Properties of a Control
- Microsoft Access 2010 : Control Properties and Why to Use Them (part 2) - The Data Properties of a Control
- Microsoft Access 2010 : Control Properties and Why to Use Them (part 1) - The Format Properties of a Control
- Microsoft Access 2010 : Form Properties and Why Should You Use Them - Working with the Properties Window
- Microsoft Visio 2013 : Using the Organization Chart Wizard with new data
REVIEW
- First look: Apple Watch

- 3 Tips for Maintaining Your Cell Phone Battery (part 1)

- 3 Tips for Maintaining Your Cell Phone Battery (part 2)
programming4us programming4us
programming4us
 
 
programming4us