7,689 reputation
1260
bio website brentozar.com
location Chicago, IL
age 40
visits member for 3 years, 8 months
seen Sep 18 at 12:16

I make SQL Servers faster and more reliable. I'm a Microsoft Certified Master and Microsoft MVP.

Stuff I'm proud of:


Sep
17
answered Weird deadlock graph
Sep
12
answered SQL Server is caching query plans with the same query when using parameterized SQL
Sep
12
revised Amazon: How to change database name in Amazon RDS MySQL?
Clarified MySQL in tag and title (since RDS is available w/MSSQL, MySQL, Oracle)
Sep
11
comment How do I tactfully bring up database shortcomings?
@James exactly, I'm saying let them believe it used to be a best practice. That lets them escape with dignity. There's no need to rub their face in what they did - as long as you can get the result you want an easier way, do it.
Sep
10
awarded  sql-server
Sep
9
awarded  Nice Answer
Sep
9
reviewed Approve suggested edit on Create relational database with same table items
Sep
9
answered How do I tactfully bring up database shortcomings?
Sep
5
answered SQLIO and its Flags
Sep
5
awarded  Organizer
Sep
5
comment Domain name change of SQL servers involved in replication
Are they just renaming the domain, or are they moving servers between domains? If it's the latter, are there any trusts between the old & new domains?
Sep
5
comment SQLIOSIM fails to run when using UNC path
Try adding a folder inside the share, like \\c16\vol1cifs\sqliosimtests, and grant full read/write access on that share to the public. (Just making sure it's not a permissions problem.)
Sep
5
revised comparing values between two tables
Removing SQL Server tags
Aug
31
awarded  Nice Answer
Aug
30
answered Join tables in two databases make query slow? is better to partition db?
Aug
18
answered Optimized Way of Scheduling a Differential Backup
Aug
18
answered SQL Server SSL connection
Aug
18
answered Why is an additional filtered statistic being ignored (EAV schema)?
Aug
18
answered Microsoft SQL Server Connection Coloring
Aug
17
answered Database events that will cause deletion of index