Features


489 results found for Features, displaying items 1 - 20

Server 2008 Data Profiling

Learn how to use SQL Server 2008's Data Profiling task and Data Profile Viewer to examine and assess your data.

SQL Server Magazine

T-SQL 101, Lesson 5

Understand the differences between inner, outer, and cross joins before you use them in your queries.

SQL Server Magazine

Generate a Clickthrough Report using Visual Studio ReportViewer

See how you can set up a clickthrough report without using SQL Server Reporting Services (SSRS).

SQL Server Magazine

Who Can Do Backups? This article is only available to subscribers.  Sign up now and get instant access!

SQL Server Magazine

CLR UDT Caveats This article is only available to subscribers.  Sign up now and get instant access!

CLR UDTs aren't intended to turn SQL Server into a full-blown object-oriented database. Learn about the proper place of CLR UDTs and methods for overcoming common objections to using them.

SQL Server Magazine

Using Large CLR UDTs in SQL Server 2008 This article is only available to subscribers.  Sign up now and get instant access!

See how the VarBinaryComp UDT takes advantage of new support for large types to store,compress, and decompress up to 2GB of binary data.

SQL Server Magazine

Backup and Restore Fundamentals This article is only available to subscribers.  Sign up now and get instant access!

Back up your SQL Server databases regularly to prevent lost data in the event of a disaster.

SQL Server Magazine

Security Logging with Service Broker This article is only available to subscribers.  Sign up now and get instant access!

Create the message types, contracts, queues, and services for an event-logging solution, and use some simple ASP code to call a SQL Server stored procedure that places information in a security logging queue for automated processing.

SQL Server Magazine

T-SQL 101, Lesson 4 This article is only available to subscribers.  Sign up now and get instant access!

Thanks to the GROUP BY clause, you can write SELECT queries that produce detailed reports.

SQL Server Magazine

Sharpen Your Basic SQL Server Skills This article is only available to subscribers.  Sign up now and get instant access!

Discover the difference between Windows Authentication Mode and Mixed Mode, and learn the names and uses of installed system databases.

SQL Server Magazine

T-SQL 101, Lesson 3 This article is only available to subscribers.  Sign up now and get instant access!

SELECT queries aren't just for retrieving data. You can also summarize that data by incorporating COUNT, MIN, MAX, AVG, and SUM functions into SELECT queries.

SQL Server Magazine

In Search of Duplicate Indexes on Your Tables This article is only available to subscribers.  Sign up now and get instant access!

Heed this advice about how to identify duplicate or redundant indexes on the tables in your databases.

SQL Server Magazine

Creating Dimensions in SSAS Part 1 This article is only available to subscribers.  Sign up now and get instant access!

Learn how to build proper dimensions, add useful hierarchies that support user’s navigational needs, then perform the important step of adding attribute relationships to make your users' data analysis fast and easy.

SQL Server Magazine

Hack Your Database Before the Hackers Do This article is only available to subscribers.  Sign up now and get instant access!

Fortify the security of your SQL Server environment by using an assortment of tools for locating servers, identifying security best practices, cracking passwords, and finding vulnerabilities.

SQL Server Magazine

Creating Dimensions in SSAS, Part 2 This article is only available to registered users.  Sign up now and get instant access!

After you build the proper dimensions of a cube, you need to add attribute relationships to help the cube engine better process queries for faster data analysis.

SQL Server Magazine

Get Compliant with SQL Server 2005 Audit Logging This article is only available to registered users.  Sign up now and get instant access!

Help meet compliance goals by using SQL Trace, SQL Server Profiler, and C2 audit mode. View stored procedure examples that demonstrate audit logging with these features, and take a brief look at SQL Server 2008 auditing and third-party options.

SQL Server Magazine

Third-Party Audit-Logging Options This article is only available to registered users.  Sign up now and get instant access!

Third-party transaction-log analyzers and gateways can audit logs and process and filter SQL Server traffic. They can analyze backup logs and use listener agents to collect and process SQL Server traffic to filter out the good stuff.

SQL Server Magazine

Common Criteria Compliance This article is only available to registered users.  Sign up now and get instant access!

Common Criteria Compliance is an advanced configuration option available in SQL Server 2005 SP1 (SP2 is under review). Government, military, financial, and other entities with serious security needs may require its certification and implementation.

SQL Server Magazine

Alternative Backup Strategies This article is only available to registered users.  Sign up now and get instant access!

Learn about advanced SQL Server backup options.

SQL Server Magazine

T-SQL101, Lesson 2 This article is only available to subscribers.  Sign up now and get instant access!

Using a database named MyDB, a table named MyTable, and some dummy tables, you can learn how to create T-SQL queries that insert new data, update existing data, and delete old data.

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   next page