The Wayback Machine - https://web.archive.org/web/20090410064342/http://stackoverflow.com:80/users/26837/brent-ozar

Brent Ozar

2,469
Reputation
1297 views

Registered User

Name Brent Ozar
Member for 6 months
Seen yesterday
Website http://www.brentozar.com
Location Whitehall, MI
Age 35
I've been working with SQL Server since the late 1990s, and I've also done SAN administration and VMware administration. I specialize in performance tuning and storage. I work as a SQL Server expert for Quest Software, the makers of Toad, LiteSpeed, Spotlight, Performance Analysis and more.

BrentOzar.com
Twitter.com/BrentO
0

Questions

 

98

Answers
15
Windows Azure for web developers vs Amazon EC2
15
CPU utilization by database?
8
SQL Server “AFTER INSERT” trigger doesn’t see the just-inserted row
7
Is SQL Server Express good enough for a developer, or should they get Developer edition?
7
Advantages of MS SQL Server 2008 over MS SQL Server 2005?
7
Emulate MySQL LIMIT clause in Microsoft SQL Server 2000
6
Parameter Sniffing (or Spoofing) in SQL Server
6
Can an MS SQL 2005 backup be restored onto an instance of MS SQL 2008?
5
Can I use SQL Server Management Studio 2005 for 2008 DB?
5
Logging requests on high traffic websites
5
Writing efficient .Net/SQL Server code
4
Poll: Build Server in a Virtual Machine?
4
Restoring a Backup to a different Server - User Permissions
4
Performance Tuning SQL - How?
4
Disable messages in SQL2008 result set
4
Database for ENORMOUS amounts of data?
4
Database Backup/Restore Process
3
Toad unicode input problem
3
Stored Procedures MSSQL2005
3
Detailed error message for violation of Primary Key constraint in sql2008?
3
Is there a performance hit by added nonenforced foreign keys to a SQL Server 2008 database?
3
How to switch between databases
3
SQL Server Compare field value with its default
3
Best load balance configuration with Windows 2008 and SQL Server 2008
3
Migrate and Merge several databases into one
2
SqlClient.SqlException occurs during Database Fail Over
2
How might someone crack the SQL Server 2005 encryption stack?
2
Sql Server Object Organisation
2
Cannot delete SQLServer2005 data or log files
2
Identifying Unused Objects In Microsoft SQL Server 2005
2
Creating 1K IDs, assigning a transactionID to all the rows with concurrency in mind.
2
Enabling Auditing feature in SQLServer 2005
2
Using virtual servers for hosting SQL Servers
2
Undo changes to MSSQL 2005 database
1
Moving SQL2005 app to SQL2008
1
SQL Server2005 memory locking
1
Simulating queries of large views for benchmarking purposes
1
SQL split/merge of table partitions: What is the best approach to implement?
1
Best software for showing SQL Server Database Structure
1
SQL 2005 sql login ip restriction
1
Microsoft.SqlServer.Management.Smo and its brothers works on SQL2000?
1
SQL Server query execution plan shows wrong “actual row count” on an used index and performance is terrible slow
1
How do I start extending MS SQL Reporting Services?
1
Automate download of BusinessObjecs Web Intelligence reports
1
What is a good way to paginate out of SQL 2000 using Start and Length parameters?
1
SQL Server Management Studio as Application Platform
1
SQL 2005: should I roll my own log shipping?
1
Software Developers With Blogs…
1
SQL find non-null columns
1
SQL Server Database File and WCF
1
Tools to encrypt sql server database
1
Partitioning in SQL Server 2005
1
Data Warehouse - business hours
1
Dynamic Stored Procedure in Sql Server 2005
1
Publicly available SQL Server replication Publisher
1
How to access SQL Server from Cocoa (Mac OS X)?
1
Sql Server to Excel via a Web Service
1
How do I set a field to null in Quest Toad “Browse Database Objects” view?
1
Any SQL Server multiple-recordset stored procedure gotchas?
1
MS-Access Add Additional Linked Tables
1
SQL order by and left outer join doesn’t have correct order
1
Trace file - how to use it
1
Can we write a sub function or procedure inside another stored procedure - SQL Server
1
SQL Server - Transactional Replication (partial data only)
1
SQL Server 2000/5 - Script to get list of Active or Inactive databases (except system ones)
1
Full-text Indexing for a view with multiple databases
1
Are there any performance implications of making cross database calls in SQL 2005?
1
Can SQL Server 2000 be made to populate a fulltext catalogue without blocking the tables it is reading?
1
Alternatives to MS SQL 2005 FullText Catalog
1
Software Bandwidth/Database Growth Formulas
1
Upload file to SQL database using classic ASP
1
Have anyone read Microsoft® SQL Server® 2008 Internals yet?
1
Performance Impact of Empty file by migrating the data to other files in the same filegroup
1
SQL Logins for the service and cluster accounts
0
uploading a realtime database into the web
0
How do you use completely free software to create ovf files for VMware ESXi?
0
How to achieve multiple Active (read and write) sites(datacenters) with continuos datareplication using SQL Server 2008?
0
First steps to SQL Server
0
Running a SQL install script with SMO. Alternative solutions needed.
0
Understanding SQL Profiler trace
0
Dynamically create temp table based on resultset from SP
0
SQL Server 2005 - Queries going into suspended state immediately
0
Dimension Security in SSAS & SSRS
0
SQL Server FTS performance after adding many records
0
Script for pushing database change to servers
0
How to use a slowly changing dimension in Sql Server Analysis Services
0
The filestream of sql server 2008
0
Recommended framework for data aggregation
0
Log table access using SQL Server Profiler
0
Transaction level, nolock/readpast and concurrency
0
What’s the best way to strip literal values out of SQL to correctly identify db workload?
0
Alternatives to Toad
0
In SQL Server 2008 how can I secure data in a way that it cannot be decrypted unless connected to a network?
0
How can I add SQL Server database objects to TFS?
0
Very poor (non-completing) performance of UNION in SQL Server 2005
0
Cloud Hosting options for ASP.NET 3.5 and SQL Server 2008
0
Speed of online backups with BLOBs
0
SQL 2005 Snapshot Security

 

112

Votes
up102down
up10down

 

142

Tags
× 54
× 27
× 12
× 12
× 10
× 7
× 5
× 4
× 4
× 3
 × 3
× 3
× 3
× 2
× 2
× 2
× 2
× 2
× 2
× 2
 × 2
× 2
× 2
× 2
× 2
× 2
× 2
× 2
× 2
× 2
 × 2









 

10

Badges
● Nice Answer× 2
● Necromancer
● Organizer
● Critic
● Commentator
● Supporter
● Editor
● Teacher
 ● Autobiographer