SEARCH RESULTS
 
Showing 1-10 of 111 records
 
Expand article

SQL Server - Fact Checking Recent Vulnerability History

2008-03-05 22:53:36 by jrjones in Jeff Jones Security Blog
 
Last week a web-based news story comes to my attention - Microsoft's glasnost on interoperability means more bugs . The article poses an interesting question of whether Microsoft's recent changes to expand interoperability will make it easier for researchers to find new vulnerabilities. I don't personally agree with the theory that sharing APIs...
 
Tags: server, claim sql server, sql, sql server team, sql vulnerabilities, vulnerabilities, sql server, vulnerability, sql team
 
 
 
 
Expand article

Tips for scheduling and testing SQL Server backups

2008-04-01 13:43:35 by Heidi Sweeney in WhatIs: Enterprise IT tips and expert advice
 
Whether you're using SQL Server or SQL Server Express Edition, these tips for scheduling backups will lead you to a successful restore. You'll learn how to schedule backups in SQL Server via the SQL Server Agent and in SQL Server Express using Windows Task Scheduler. SQL Server expert Denny Cherry also shares how to test and secure your backups
 
Tags: sql server, sql server express, backups, sql server agent, schedule backups, windows task scheduler, tips, successful restore, shares
 
 
 
 
Expand article

SQL and SQL Server Tutorial and Reference Guide

2008-04-22 10:56:19 by Heidi Sweeney in WhatIs: Enterprise IT tips and expert advice
 
SQL (Structured Query Language) is the language of databases. This Back to Basics SQL tutorial and reference guide provides a great starting point and foundation for learning SQL or brushing up your skills
 
Tags: sql, basics sql tutorial, reference guide, query language, language, skills, databases, foundation
 
 
 
 
Expand article

SQL Server PerfMon counters for access methods and buffer manager

2008-04-29 13:18:07 by Heidi Sweeney in WhatIs: Enterprise IT tips and expert advice
 
In this episode of the screencast series "PerfMon Counters for the SQL Server DBA," SQL Server MVP Kevin Kline focuses specifically on SQL Server counters. Kline shares best practices for using access method counters to watch for IO intensive operations, such as full table or clustered index scans and page splits. You'll also learn why it's...
 
Tags: sql server, sql server counters, buffer manager, buffer, sql server dba, perfmon counters, quickly pages age, access method counters, lazy writer
 
 
 
 
Expand article

SQL Server memory configurations for procedure cache and buffer cache

2008-06-10 11:11:06 by Heidi Sweeney in WhatIs: Enterprise IT tips and expert advice
 
To determine how much memory your SQL Server database uses for buffer cache and procedure cache, factor in the SQL version you're using, whether it's x86, x64 or Itanium and the amount of memory allocated to the SQL Server instance. SQL Server expert Denny Cherry lays out how the system configures memory and how to allocate the amount of buffer...
 
Tags: memory, procedure cache, buffer cache, buffer, system configures memory, sql server instance, sql server database, sql version, amount
 
 
 
 
Expand article

SQL Server high availability when upgrading to SQL Server 2005

2008-07-01 13:28:32 by Matthew Schroeder in WhatIs: Enterprise IT tips and expert advice
 
The pursuit of minimal downtime is complex when upgrading an Active/Active cluster to SQL Server 2005/Windows Server 2003. In part three of this series, SQL Server expert Matthew Schroeder outlines the stages for migrating a database to a transition server, and then the new source system. Areas covered in this tip include configuring logins,...
 
Tags: sql server jobs, source system, transition server, activeactive cluster, minimal downtime, tip include, permissions, complex, stages
 
 
 
 
Expand article

How to use the LEFT vs. RIGHT OUTER JOIN in SQL

2008-03-04 12:06:02 by Abbey M. Weintraub in WhatIs: Enterprise IT tips and expert advice
 
Learn how to use LEFT vs. RIGHT OUTER JOINs in this excerpt from "SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL, Second Edition." You'll learn how to define a SQL OUTER JOIN by using multiple tables and how to use the SELECT statement and embed JOINs with these techniques for creating simple queries
 
Tags: sql, sql outer join, sql queries, mere mortals, data manipulation, multiple tables, select statement, embed joins, outer joins
 
 
 
 
Expand article

SQL Server PerfMon counters for tracking Windows memory

2008-03-06 11:26:32 by Heidi Sweeney in WhatIs: Enterprise IT tips and expert advice
 
In part 1 of this series on "PerfMon counters for the SQL Server DBA," SQL Server MVP Kevin Kline walks you through significant PerfMon counters for tracking Windows memory. In this screencast, you'll learn the maximum numbers to watch for when using PerfMon counters as a method to avoid memory pressure in your SQL Server system
 
Tags: perfmon counters, significant perfmon counters, windows memory, avoid memory pressure, sql server dba, sql server system, maximum, series, screencast
 
 
 
 
Expand article

SQL Server PerfMon counters for Windows operating system (OS)

2008-03-18 10:46:08 by Heidi Sweeney in WhatIs: Enterprise IT tips and expert advice
 
SQL Server PerfMon counters can help troubleshoot and even avoid bottlenecks on your Windows operating system. In part 2 of this screencast series on "PerfMon counters for the SQL Server DBA," SQL Server MVP Kevin Kline walks you through best practices and maximum values to watch for when using counters to monitor OS performance
 
Tags: