programming4us
programming4us
DATABASE
Change page: < 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 >  |  Displaying page 16 of 16, items 601 to 625 of 625.
SQL Server 2008 Command-Line Utilities : The tablediff Command-Line Utility
The tablediff utility enables you to compare the contents of two tables. It was originally developed for replication scenarios to help troubleshoot nonconvergence, but it is also very useful in other scenarios.
SQL Server 2008 : Programming Objects - Implementing Functions
Although Microsoft SQL Server provides a great set of built-in functions, you can also create your own function to encapsulate a routine that performs an important action in your application, such as a complex calculation.
Surviving Changes to Columns
One of the most common causes of brittle code is a failure to program defensively against subsequent changes to the columns of the underlying data tables. These changes can take the form of adding columns, or changing the definition of existing columns, for example, their data type or size.
Surviving Changes to the Signature of a Stored Procedure
The lesson here is clear: stored procedure calls with explicitly named parameters are more robust; they continue to work correctly even when the signature of the stored procedure changes, or they give explicit errors instead of silently returning incorrect results.
Exploring the T-SQL Enhancements in SQL Server 2005 : The PIVOT and UNPIVOT Operators
Let’s face it: Users usually want to see data in tabular format, which is a bit of a challenge given that data in SQL Server is most often stored in a highly relational form. PIVOT is a new T-SQL operator that you can specify in your FROM clause to rotate rows into columns and create a traditional crosstab query.
Exploring the T-SQL Enhancements in SQL Server 2005 : Common Table Expressions
A common table expression (CTE) closely resembles a nonpersistent view. It is a temporary named result set that you define in your query that will be used by the FROM clause of the query.
SQL Azure Data Access
SQL Azure allows you to connect to the cloud database only using the TDS protocol with limited support, as described in the previous section. But because the TDS protocol is supported by most of the SQL Server client APIs, all the features supported by SQL Azure work with existing client APIs.
SQL Azure Architecture
SQL Azure is a scalable and highly available database utility service in the cloud. Like all other Windows Azure services, it runs in Microsoft data centers around the world. The data center infrastructure provides the SQL Azure service with load balancing, failover and replication capabilities
SQL Server : Transactions and Exceptions
No discussion of exceptions in SQL Server can be complete without mentioning the interplay between transactions and exceptions. This is a fairly simple area, but one that often confuses developers who don't quite understand the role that transactions play.
SQL Server : Exception Handling
Exception handling in T-SQL should be thought of as no different from exception handling in any other language. A generally accepted programming practice is to handle exceptions at the lowest possible scope, in order to keep them from interacting with higher levels of the application.
How Exceptions Work in SQL Server
The first step in understanding how to handle errors and exceptions in SQL Server is to take a look at how the server itself deals with error conditions. Unlike many other programming languages, SQL Server has an exception model that involves different behaviors for different types of exceptions
Surviving Changes to the Definition of a Primary or Unique Key
Changes to the keys in your tables should, hopefully, be rare, but they can cause trouble to the unwary when they happen. In a broader context, the defensive programmer should always fully document and test any assumptions about the underlying uniqueness of the column data.
Multi-Server Administration : Policy-Based Management
Policy-Based Management is a new feature in SQL Server 2008 that allows you to define and implement policies across the organization. Policy-Based Management was initially called the Declarative Management Framework but was changed before the final release of SQL Server 2008
Queries in SQL
SQL is an acronym that stands for Structured Query Language. SQL is an international standard, and all fully relational database management systems include it. Using SQL, it is possible to create a database, enter data into it, and retrieve information from it. Any information that can be retrieved from a database can be retrieved by means of an SQL query.
SQL Server 2008 : Roles
Like Windows groups, SQL Server provides two roles, server- and database-level roles into which logins and users can be added. Server-level roles are fixed roles that have a serverwide permission scope.
Full-Text Indexing in SQL Server 2008
Full-text indexing is a feature of SQL Server 2008 that allows you to carry out sophisticated searches of text-based data called a full-text search. A full-text search is different from a normal search of data through a normal index because it enables you to use linguistic-based searches.
sp_configure and SQL Server Management Studio
SQL Server Management Studio is the central tool for managing SQL Server, and you will need to be very familiar with it for the exam. Fortunately, most of the exam objectives require the use of this tool so you will get plenty of practice with it .
Binding Application Data to the UI objects in Silverlight
The Binding markup extension or the FrameworkElement.SetBinding() method can be used to bind properties on instances of application data types to dependency properties defined on any type inheriting from FrameworkElement. The application data type properties are called the source properties for the binding, and the dependency properties are called the target properties.
Performance Management Tools in SQL Server 2008
In addition to configuration and management tools discussed previously, SQL Server 2008 ships with three specialized tools for capturing, analyzing, and troubleshooting performance data.
Management Tools in SQL Server 2008
SQL Server 2008 ships with a set of nine tools for managing SQL Server instances and interacting with data: OSQL, SQLCMD, Tablediff, Bulk Copy Program (BCP), SQLDiag, Resource Governor, SQL Server Configuration Manager, SSMS, and Database Mail.
Editions of SQL Server 2008

SQL Server 2008 is available in a variety of editions. Each edition is tailored to meet an assortment of needs based on the features required for various applications within an organization.Table 2-1 on page16 lists the available editions of SQL Server.

Upgrading to SQL Server 2008

You can upgrade from SQL Server 2000 or SQL Server 2005 to SQL Server 2008 using either an in-place or side-by-side upgrade. An in-place upgrade allows you to install SQL Server 2008 over the top of an existing SQL Server 2000 or 2005 instance.

Clustered Indexes in SQL Server 2008

The column(s) defined for the clustered index are referred to as the clustering key. A clustered index is special because it causes SQL Server to order the data in the table according to the clustering key. Because a table cannot be sorted more than one way, you can define only one clustered index on a table.

Installing SQL Server 2008

Now that we have covered the basic background for SQL Server instances, you will install your first SQL Server Database Engine instance along with Analysis Services, Reporting Services, Integration Services, and all of the tools that ship with SQL Server.

LINQ Projection Queries and Alternatives in WCF Services

The presenter at my local .NET user group was writing a LINQ query during his session last month when I asked him, "How did we ever live without LINQ?" Since it was introduced in Visual Studio 2008, LINQ has made such a difference in how we code in the Microsoft .NET Framework. In combination with the many new language features that were introduced in Visual Basic and C#, it's a consistent problem solver for querying in-memory objects and data sources.

 
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