Microsoft Certification Examples, exercises, practises, tutorials, solutions about Database

Change page: < 1 2 3 4 5 6 7 8 9 10 > | Displaying page 1 of 10, items 1 to 30 of 300.

Protecting SQL Server Data : CELL-LEVEL ENCRYPTION - Views and Stored Procedures (part 2) - Creating the Stored Procedures

The final step in implementing these stored procedures is to grant the appropriate permissions to them. Requirement 6 allows the INSERT or UPDATE methods to be executed, if an encrypted column exists; only when the database role that performs the INSERT or UPDATE method has permissions granted to the key that performs the encryption.

Protecting SQL Server Data : CELL-LEVEL ENCRYPTION - Views and Stored Procedures (part 1) - Creating the View

The sensitive data that is contained within the Borrower_Identification table is now protected with cell-level encryption. Our next steps are to create the views and stored procedures via which our users can interact with the Borrower_Identification table.

Protecting SQL Server Data : Implementing Cell-Level Encryption

An optional argument when creating a certificate is ENCRYPTION BY PASSWORD. This argument defines a password protection method of the certificate's private key.

Protecting SQL Server Data : Preparing for Cell-Level Encryption

For simplicity and clarity we will focus on the Borrower_Identification table. The majority of the steps noted in this demonstration would be repeated as needed for each column in any table that contains data classified as "High" sensitivity.

Microsoft SQL Server 2008 R2 : Monitoring Replication (part 2) - New and Improved Peer-to-Peer Replication

For data distribution requirements that must have updates in multiple nodes, peer-to-peer replication is ideal. You must worry about conflicts, but typically they are rare and very easily handled by a simple conflict handler.

Microsoft SQL Server 2008 R2 : Monitoring Replication (part 1) - Replication Monitoring SQL Statements

SQL Server Management Studio provides considerable information about the status of replication. Most of this information is available via Replication Monitor. In Replication Monitor, you can see the activity for publishers, distributors, and subscribers; you can see all agent details; and you can configure alerts.

Microsoft SQL Server 2008 R2 : Scripting Replication

Packaging your skin is not necessary to use the skin. Packaging is also not necessary to move or deploy your skin on another DotNetNuke install or a different server.

Processing and Storing Data in SQL Server 2005 : Data Migration from One Data Store to Another Data Store

Sometimes data needs to be migrated from one place to another. If you need to transfer data from a database server to a back-end database server, you have several options.

Processing and Storing Data in SQL Server 2005 : Implementing the Record Failure Code

Remember that for each failure you will need to find a way to reprocess that record. In our case we are providing storage and notification but not reprocessing. Because of the unlimited number of reasons why something could fail, we have no surefire way to assure a single reprocessing solution.

Processing and Storing Data in SQL Server 2005 : Data Tracking Validation

Each solution has its pros and cons. I’m going to use a single file per record because I want to avoid any locking that could occur if I were to have a secondary automated process collecting this data or trying to reprocess it.

Processing and Storing Data in SQL Server 2005 : Updating the FileWorker Class

We need to create an instance of our LINQSQL class and then use the file that we found while polling our process folder to populate a new user record for each line in the process file.

Microsoft SQL Server 2008 R2 : Setting Up Replication (part 4) - Creating Subscriptions

Pull subscriptions allow remote sites to subscribe to any publication that they are allowed to, but for this to work, you must be confident that the administrators at the other sites have properly configured the subscriptions at their sites.

Microsoft SQL Server 2008 R2 : Setting Up Replication (part 3) - Horizontal and Vertical Filtering

In addition, you can specify horizontal filters by using the Filter Rows option on a publication (publication properties). This allows you to specify horizontal filtering on any table you publish.

Microsoft SQL Server 2008 R2 : Setting Up Replication (part 2) - Creating a Publication

When the distribution database has been created and publishing has been enabled on the server, you can create and configure a publication.

Microsoft SQL Server 2008 R2 : Setting Up Replication (part 1) - Creating a Distributor and Enabling Publishing

You can configure the server as a distributor and publisher at the same time, or you can configure the server as a dedicated distributor on the remote server separately.

SQL Server 2008 R2 : Basing the Replication Design on User Requirements

Business requirements drive your replication configuration and method. In addition, nailing down all the details of the business requirements is the hardest part of a data replication design process.

SQL Server 2008 R2 : Planning for SQL Server Data Replication & SQL Server Replication Types

Microsoft has narrowed the field to three major types of data replication approaches within SQL Server: snapshot, transactional, and merge. Each replication type applies to only a single publication.

SQL Server 2008 R2 : Replication Agents

SQL Server utilizes replication agents to do different tasks during the replication process. These agents are constantly waking up at some frequency and fulfilling specific jobs.

SQL Server 2008 : Replication - Subscriptions

A subscription is essentially a formal request and registration of that request for data that is being published. By definition, you subscribe to all articles of a publication.

SQL Server 2008 : Replication Scenarios

SQL Server 2008 has built-in functionality that allows the subscriber to update data in a table to which it subscribes and have those updates automatically made back to the publisher through either immediate or queued updates.

Protecting SQL Server Data : CELL-LEVEL ENCRYPTION - Special Considerations

At cell-level, encryption's finest level of granularity, each cell that contains encrypted data is protected by a key that is specific to the user that performed the encryption. Decryption is accomplished through the use of the same key, or a public key, depending on the encryption method applied.

Protecting SQL Server Data : SCHEMA ARCHITECTURE STRATEGIES - Harnessing Linked Servers

Linked Servers offer to security administrators, when implementing their schema architecture strategies, an additional layer of separation between sensitive and less sensitive data.

Monitoring SQL Server 2005 Performance : Using Windows System Monitor & Using SQL Server Profiler

The SQL Profiler tool is a graphical mechanism that enables you to monitor SQL Server events. This tool enables you to capture and save data about every event on a server. The data can be stored to a file or SQL Server table.

Monitoring SQL Server 2005 Performance : Monitoring and Recording Performance

To gather statistical information on how a server is performing requires, you need to use operating system tools to gather a broad scope of information. System Monitor and Event Viewer are two operating system tools you can use to gather hardware information and information pertaining to the interaction between SQL Server and the operating system.

SQL Server 2008 R2 : Replication - The Publisher, Distributor, and Subscriber Magazine Metaphor

A single database can contain more than one publication. You can publish data from tables, from database objects, from the execution of stored procedures, and even from schema objects, such as referential integrity constraints, clustered indexes, nonclustered indexes, user triggers, extended properties, and collation.

SQL Server 2008 R2 : Replication - What Is Replication?

Long before you ever start setting up and using SQL Server data replication, you need to have a solid grasp of what data replication is and how it can be used to meet your company’s needs.

SQL Server 2008 High Availability : Other HA Techniques That Yield Great Results & High Availability from the Windows Server Family Side

To enhance system uptimes, numerous system architecture enhancements that directly reduce unplanned downtime, such as improved memory management and driver verification, were made in Windows 2000, 2003, and 2008 R2

SQL Server 2008 High Availability : Building Solutions with One or More HA Options

When you have the fundamental foundation in place, as described in the preceding section, you can move on to building a tailored software-driven high-availability solution.

SQL Server 2008 High Availability : The Fundamentals of HA

Every minute of downtime you have today translates into losses that you cannot well afford. You must fully understand how the hardware and software components work together and how, if one component fails, the others will be affected.

Administering SQL Server 2008 with PowerShell : Step-By-Step Examples (part 4)

The preceding example shows how many features are packaged within PowerShell, which applies not only to SQL tables, but also to all .NET objects.