programming4us
programming4us
DATABASE
Change page: < 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 >  |  Displaying page 13 of 16, items 481 to 520 of 625.
Synching an On-Premises Database with SQL Azure
Microsoft has released a Community Technology Preview (CTP) of a tool called Microsoft Sync Framework Power Pack for SQL Azure. This tool lets you synchronize your local database with an Azure database.
SQL Server 2008 : Managing Query Performance - Finding Similar Queries
Prior to SQL Server 2008, you would have to capture a set of queries using a trace or Dynamic Management View (DMV), perform some logic to replace literal values within those queries, and then group by some or all of the query text
SQL Server 2008 : Correlating Profiler and the Performance Monitor
One interesting feature added in SQL Server 2005 is the ability to import performance logs into SQL Server Profiler so that you can correlate activity on the system to specific queries.
SQL Server 2008 : Explaining XML - XML Indexes
SQL Server 2008 allows for the creation of indexes only on the XML data type. It’s used to optimize XQuery queries, which index all tags, values, and paths over the XML instances in the XML data type column.
SQL Server 2008 : Explaining XML - XQuery and XPath
XQuery is a language used to query XML data. You can query and manipulate data from XML documents or data sources that can be viewed by XML
SQL Azure : Managing a Shard (part 2) - Working with Partial Shards
Having created a shard and reached the point of being able to run queries and add data, you can begin to think about higher-level issues: how to handle exceptions, manage performance, control transactions, and more.
SQL Server 2008 : OPENXML, sp_xml_preparedocument, and sp_xml_removedocument
Microsoft started supporting OPENXML in SQL Server 2000. OPENXML is a SQL Server function, which accepts a stream of XML data and provides an in-memory relational rowset view of the XML data.
SQL Server 2008 : Retrieving and Transforming XML Data
You can return results as XML documents rather than a standard rowset. You can retrieve results using the FORXML clause in a SELECT statement. In your FORXML clause you specify an XML mode, RAW, AUTO, or EXPLICIT.
SQL Azure: Building a Shard (part 4) - Updating and Deleting Records in the Shard & Adding Records to the Shard
You see how easy it is to add records to the shard databases. This shard works best from a performance standpoint when all databases in the shard have a roughly equal number of records; this is because parallel processing is performed without any deterministic logic.
SQL Azure: Building a Shard (part 3) - Reading Using the Shard & Caching
To minimize roundtrips to the source databases, the shard library provides an optional caching mechanism. The caching technique used in this library offers basic capabilities and can be extended to address more complex scenarios
SQL Azure: Building a Shard (part 2) - Managing Database Connections
The shard library declares the following property to hold the list of preloaded connection objects. The ShardConnections property is declared as static so it can be used across multiple calls easily
SQL Azure: Building a Shard (part 1) - Designing the Shard Library Object
The library accepts requests directly from client applications and can be viewed as an API. Note that you're using extension methods to make this API blend in with the existing SqlCommand class
SQL Azure: Designing for High Performance - General Performance Concepts
An application that opens a database connection for every database call and performs a roundtrip for every update performs slower than an application that loads data for multiple objects in a single call and sends changes in bulk
SQL Server 2008 : Explaining Advanced Query Techniques - Creating and Altering Tables
In this section we look at new features in SQL Server 2008 for more efficiently storing columns with a large number of NULL values as well as for compressing the data in a table.
SQL Server 2008 : Explaining Advanced Query Techniques - Managing Internationalization Considerations
The need to support data from sources around the world as well as to support clients from various cultures is a common need these days. SQL Server has been designed with support for these international data sets and clients out of the box.
Programming Microsoft SQL Server 2005 : Deployment (part 2) - Testing Your Stored Procedures
With your assembly and stored procedures now deployed, you’re ready to run and test them. Typically, you should do this from Management Studio; however, Visual Studio SQL Server projects allow you to test your SQL CLR code from Visual Studio itself
Programming Microsoft SQL Server 2005 : Deployment (part 1) - Deploying Your Assembly
Visual Studio deploys the SQL Server project version of the sample code when you build, start, or step through the project or use the Build/Deploy function on Visual Studio’s main menu.
Programming Microsoft SQL Server 2005 : CLR Stored Procedures and Server-Side Data Access
SQL CLR stored procedure code runs in an instance of the .NET CLR that is hosted by SQL Server itself; it is not called as an external process, as COM-based extended stored procedures (XPs) would be
SQL Server 2008 : Explaining Advanced Query Techniques - Controlling Execution Plans (part 3) - Using the Resource Governor
The Resource Governor is a new feature that was introduced with SQL Server 2008. It is available only in the Enterprise, Developer, and Evaluation editions of SQL Server.
SQL Server 2008 : Explaining Advanced Query Techniques - Controlling Execution Plans (part 2)
One of the most powerful and beneficial features of SQL Server is its query optimizer. Part of what we are paying for when we purchase SQL Server is the expertise of the SQL Server product engineers in the form of the query optimizer.
SQL Server 2008 : Explaining Advanced Query Techniques - Controlling Execution Plans (part 1)
One of the most powerful and beneficial features of SQL Server is its query optimizer. Part of what we are paying for when we purchase SQL Server is the expertise of the SQL Server product engineers in the form of the query optimizer.
Reporting Services with SQL Azure : Deploying the Report & Creating a Subreport
Your report is called Documents, but it displays users—and that's why you're going to add a subreport. You want to display all documents for the related users (one user can have multiple documents).
Reporting Services with SQL Azure : Creating the Report Design
With your report in Design view, you can now start laying it out. In this example you don't do anything flashy or extensive, just something simple to demonstrate your connectivity to SQL Azure.
SQL Server 2008 : Explaining Advanced Query Techniques - Applying Ranking Functions (part 2) - Using RANK, DENSE_RANK and NTILE
The ROW_NUMBER function returned a sequential number based on the number of rows in the given “partition” and ordered by the some value.
SQL Server 2008 : Explaining Advanced Query Techniques - Applying Ranking Functions (part 1) - Using ROW_NUMBER
We will start with the ROW_NUMBER function because it is the most basic of the four ranking functions. It simply generates a numeric value based on the number of rows in the result.
SQL Server 2008 : Demystifying Data Types - Computed Columns
A computed column is calculated from an expression that can use other columns in the same table. The expression can be a noncomputed column name, constant, function, and any combination of these connected by one or more operators.
Programming Microsoft SQL Server 2005: Overview of SQL CLR - Visual Studio/SQL Server Integration
The combination of Visual Studio 2005 and SQL Server 2005 on the same development machine provides a special SQL Server Project type in Visual Studio and, within projects of that type, defined templates for the five basic SQL CLR entities.
Programming Microsoft SQL Server 2005: DDL Triggers and Notifications
DDL triggers work synchronously, immediately after the triggering event, similar to the way that DML triggers in previous versions of SQL Server work.
Programming Microsoft SQL Server 2005: Enabling CLR Integration
The SQL CLR features of SQL Server 2005 are sophisticated and can be very useful, but they are also, technically, nonessential.
Reporting Services with SQL Azure : Creating the SQL Azure Data Source
Granted, these steps are no different than those for connecting to a local database. But although the steps are the same, some of the key selection components are different, where you select the specific Microsoft SQL Azure provider and the SQL Azure–specific connection information.
Reporting Services with SQL Azure : Starting a SQL Azure–Based Report
When you're creating reports that access data from SQL Azure, the process is the same as creating reports that access local data, with one slight difference: the connection to the data.
SQL Server 2008 : Service Broker - Message Types
Message Types are the first of the types of objects that we will be looking at. The Message Type is simply a definition of the type of data that will be contained within the message
SQL Server 2008 : Service Broker Defined
There are two main concepts within SQL SERVICE BROKER: sending and receiving messages. Any process can send a message, provided it has the required rights to do so
SQL Azure : Building Two OData Consumer Applications (part 2) - Windows Mobile 7 Application
In this example, you create a new application that consumes the same OData service that you consumed in the last example, but this time you use a Windows Phone 7 application to consume the service.
SQL Azure : Building Two OData Consumer Applications (part 1) - Simple Demo App
The rest of this article focuses on building two applications that consume the OData service that you just enabled on your SQL Azure database.
SQL Server 2008 : Explaining Advanced Query Techniques - Creating CTEs
Many people find the subquery version to be more difficult to understand because the “inner” query is stated in the middle of the “outer” query. It can make it difficult to figure out where one query starts and the other stops.
SQL Server 2008 : Multiple Sources with SQL Server Integration Services
With the installation of SQL Server 2008, you will get an additional tool called SQL Server Business Intelligence Development Studio, which is used to create SSIS packages, SSAS cubes, and SSRS reports
SQL Server 2008 : Working with Multiple-Source Queries - OpenQuery, OpenRowSet, and OpenDataSource Explained
Apart from using four dotted notations, you have three functions to access remote servers. Those functions are OpenQuery, OpenRowSet, and OpenDataSource.
SQL Server 2008 : Working with Multiple-Source Queries - Using Four-Part Database Names & The DTC Explained
If the data is in another SQL server, complete the four-part name that is required to access data from the remote SQL server. Server.Database.Schema.ObjectNameSELECT or DML query
SQL Server 2008 : Working with Multiple-Source Queries - Using Linked Servers
You can configure Linked Servers in two different ways. The easiest way is to use SQL Server Management Studio because it provides you with the relevant screen to enter Linked Server parameters.
 
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