Features


571 results found for Features, displaying items 1 - 20

Gathering Deadlock Information with Deadlock Graph This article is only available to subscribers.  Sign up now and get instant access!

Using the Deadlock graph event class lets you easily gather information on SQL Server deadlocks that you can display graphically in SQL Server Profiler or SQL Server Management Studio or review in XML for more detailed information.

SQL Server Magazine

Passing a Table Variable from SSIS This article is only available to subscribers.  Sign up now and get instant access!

By using table variables as parameters, you can make code maintenance easier.

SQL Server Magazine

Build a Policy-Based Management System for SQL Server 2008

Deal with the limitations of SQL Server 2008’s built-in policies by creating a table-driven solution that lets you insert policy exceptions and regulate policy execution.

SQL Server Magazine

Ted Kummert on the SQL Server and MySpace Connection

Ted Kummert, senior vice president of the business and platform division at Microsoft, discusses the explosive growth of the MySpace SQL Server implementation.

SQL Server Magazine

Getting Started with SQL Azure Database This article is only available to subscribers.  Sign up now and get instant access!

SQL Azure Database supports many—but not all—SQL Server features. Here are some commonly used features that SQL Azure doesn't support.

SQL Server Magazine

Key SQL Azure Database Differences This article is only available to subscribers.  Sign up now and get instant access!

SQL Azure Database supports many—but not all—SQL Server features. Here are some commonly used features that SQL Azure doesn't support.

SQL Server Magazine

Security Reporting for SQL Server Analysis Services This article is only available to subscribers.  Sign up now and get instant access!

Implement this solution to provide data owners with a way to audit access to data they’re responsible for.

SQL Server Magazine

Upgrading a SQL Server 2005 Cluster to a SQL Server 2008 This article is only available to subscribers.  Sign up now and get instant access!

Minimize downtime when patching clusters by upgrading your SQL Server 2005 clusters to SQL Server 2008 to take advantage of its rolling upgrade functionality.

SQL Server Magazine

SSIS Logging Best Practices

Follow these best practices to provide DBAs with the necessary information to identify errors when they arise.

SQL Server Magazine

Guidelines and Best Practices in Optimizing LINQ Performance

Although with LINQ you can query data in your object model seamlessly, you need to consider a few best practices to ensure that your application performs well.

SQL Server Magazine

DBCC CHECKDB for Very Large Databases This article is only available to subscribers.  Sign up now and get instant access!

Running DBCC can be problematic on VLDBs. Use the author's Admin/Worker Job approach to ease the process.

SQL Server Magazine

Building Your First Cube

Jump into advanced BI by using this step-by-step guide to making your first cube.

SQL Server Magazine

Passing NULL Parameters This article is only available to subscribers.  Sign up now and get instant access!

Have you ever had a stored procedure that could accept a NULL value as a parameter but didn't seem to work correctly when you did so? Here's what might have gone wrong.

SQL Server Magazine

Administer WSS 3.0 Content Databases from SQL Server This article is only available to subscribers.  Sign up now and get instant access!

Find out how to use specific T-SQL queries to pull useful information out of tables in SharePoint’s content databases.

SQL Server Magazine

Enforce Multitable Constraints Using Indexed Views This article is only available to subscribers.  Sign up now and get instant access!

If you need to enforce business rules on multiple tables, try indexed views, which let you join tables and enforce uniqueness on the result set.

SQL Server Magazine

Pivoting the Dynamic Way This article is only available to subscribers.  Sign up now and get instant access!

The PIVOT statement is a great tool for presenting data in an easy-to-read format, but it has one key limitation: You must know about and include all the column names in the PIVOT query. You can work around this limitation with dynamic pivoting.

SQL Server Magazine

SQL Server Reporting Services Questions Answered

Use these techniques and sample reports to get answers to your most frequently asked reporting questions.

SQL Server Magazine

How SQL Server CLR and C# Can Solve a Common Problem This article is only available to subscribers.  Sign up now and get instant access!

Ever need to create temp tables with cursors in T-SQL to mimic the utility of an array? You can use the array in C# to easily provide a solution to a common need: the transposition of a query’s result set.

SQL Server Magazine

Monitor SQL Server 2008 with OpsMgr This article is only available to subscribers.  Sign up now and get instant access!

The SQL Server management pack in Microsoft System Center Operations Manager 2007 can help you monitor SQL Server 2008 locks, space utilization, backup jobs, and more.

SQL Server Magazine

Checking Backup Status on Multiple SQL Server Systems This article is only available to subscribers.  Sign up now and get instant access!

Use this method to generate a simple backup status report that you can use to ensure all your SQL Server systems are backed up when they’re suppose to be.

SQL Server Magazine

Add these Headlines to your Website



     [1]  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29   next page 




 

ADS BY GOOGLE