3,860 reputation
817
bio website brentozar.com
location Chicago, IL
age 40
visits member for 5 years, 2 months
seen Jul 10 at 20:51

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

Stuff I'm proud of:


Jan
28
answered sql server and vms
Jan
28
answered Please advise on VPS config choice (with SQL Server Express)
Jan
28
answered Resource Pool sharing in Hyper-V Virtual Machines
Oct
22
comment Verify SQL Server Mirroring failover is successful
Thanks, glad you like the blog! Yes, if you want automatic failover, mirroring is the only game in town. You can use high performance mode for mirroring, which doesn't commit transactions on both servers simultaneously and doesn't allow for automatic failover, but then human beings have to get involved when there's a server failure.
Oct
18
comment Boost SQL Server priority: should it be used?
Agreed. I've also seen cases where SQL Server's priority has exceeded the hardware manufacturer's driver priority, and the drivers haven't been able to get the CPU time they need to keep up with SQL Server. Caused a bluescreen at StackOverflow, believe it or not.
Oct
18
answered Verify SQL Server Mirroring failover is successful
Oct
18
comment Implementing dual control SQL updates in SQL Server
+1 - there's nothing in SQL Server that will do this.
Oct
18
answered How can I automatically transfer data between R-Base database version 4 and SQL Server 2008?
Oct
8
comment CREATE DATABASE equivilant of RESTORE DATABASE WITH REPLACE
I hear ya, but not everybody runs SQL Server as a limited access user and sets filesystem permissions correctly.
Oct
8
answered CREATE DATABASE equivilant of RESTORE DATABASE WITH REPLACE
Oct
1
awarded  Enlightened
Aug
10
comment Sysobjects issue in sql 2000
No problem! If it's the right answer, hit the Accept Answer thing here so it'll close the question. Thanks!
Aug
10
answered Sysobjects issue in sql 2000
Aug
3
awarded  Nice Answer
May
28
comment Best Information Technology Blogs
thanks, sir!
May
16
comment Is it OK to run perfmon on production servers? And why?
Ah, cool! Let me know what you think of it.
May
12
comment Is it OK to run perfmon on production servers? And why?
Agreed - there's no overhead from running Perfmon. Another answer suggested running Profiler instead of Perfmon, but there is a very real overhead to running Profiler. I've seen Profiler traces take down production servers when the tracing box couldn't keep up with the load, or when the added load pushed the production server over the edge.
May
1
awarded  Yearling
Feb
22
answered How can I create a restore point for VMware and Microsoft Virtualization
Feb
19
comment Recommended settings for 2-tier server environment
Thanks, glad you liked it!