Administration


2602 results found, displaying items 1 - 20

Express Essentials: The Finished Report This article is only available to registered users.  Sign up now and get instant access!

Michael Otey wraps up the SQL Server Express Reporting Services report he's worked on in his series of articles and shows how to deploy it.

SQL Server Magazine

Jump Start: SET NOCOUNT ON This article is only available to registered users.  Sign up now and get instant access!

Disabling the SQL Server row-count feature can help optimize T-SQL stored procedures and batches.

SQL Server Magazine

Welcome to Making IT Work

Welcome to Michael Otey's new blog, where he covers not only SQL Server Express and T-SQL, but Windows Server 2008, Vista, Hyper-V, VMware ESX Server, and more.

Windows IT Pro

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

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

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

SQL Server Change Management Tools

These solutions help protect your SQL Server environment from unwanted modification by registering changes to data, server configurations, and schemas. Find out which one you can use to roll back changes or to migrate databases to a different platform.

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

Take the Drudgery Out of Making Sure Your Databases Are Being Backed Up Properly This article is only available to registered users.  Sign up now and get instant access!

Ensuring that databases are being backed up properly is an important but time-consuming task, especially for DBAs who manage multiple servers and databases. The sp_ShowBackups stored procedure makes this task quick and easy.

SQL Server Magazine

Temporal Histograms This article is only available to subscribers.  Sign up now and get instant access!

Handling distribution of events over time is tricky. Break the problem into steps. If handling all of a task’s requirements at once is too complicated, relax some requirements, solve a simpler form of the problem, then reintroduce the complexity layers.

SQL Server Magazine

The Logical Puzzle This article is only available to subscribers.  Sign up now and get instant access!

Get the solution to April’s puzzle, “Suicidal Mosquito,” and prepare your mind for May’s puzzle, which involves distance calculation.

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

What If You Had a Benchmark and Nobody Came? This article is only available to registered users.  Sign up now and get instant access!

Michael looks at some of SQL Server 2008's benchmark scores and discusses why the TPC-E benchmark currently isn't useful for comparing database platforms.

SQL Server Magazine

Panorama Provides BI Functionality in Google Docs

We recently met with Panorama to discuss its partnership with Google and latest product offerings.

SQL Server Magazine

Jump Start: Tracking Transactions This article is only available to registered users.  Sign up now and get instant access!

Michael Otey responds to reader questions about how transactions work, when and where the data is written, and whether the data is put into the database before the transaction is committed.

SQL Server Magazine

Jump Start: Tracking Transactions

Windows IT Pro

Potential SQL Injection Attack on Oklahoma Prison Thwarted

Sharp-eyed observers reported code vulnerable to a possible SQL injection attack to Oklahoma state prison officials.

SQL Server Magazine

SQL Server 2008's Report Designer Preview

This week, Derek discusses the Report Designer Preview feature that will be included with SQL Server 2008.

SQL Server Magazine

SQL Server 2008's Report Designer Preview

Windows IT Pro

Check It Out: Windows Vista SP1 This article is only available to registered users.  Sign up now and get instant access!

Are you running Windows Vista? If so, you'll want to check out the improvements that SP1 provides.

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  30  31  32  33  34  35  36  37  38  39  40  41  42  43  44  45  46  47  48  49  50  51  52  53  54  55  56  57  58  59  60  61  62  63  64  65  66  67  68  69  70  71  72  73  74  75  76  77  78  79  80  81  82  83  84  85  86  87  88  89  90  91  92  93  94  95  96  97  98  99  100  101  102  103  104  105  106  107  108  109  110  111  112  113  114  115  116  117  118  119  120  121  122  123  124  125  126  127  128  129  130  131   next page