3,880 reputation
817
bio website brentozar.com
location Chicago, IL
age 41
visits member for 5 years, 7 months
seen Dec 11 at 18:15

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

Stuff I'm proud of:


Apr
30
comment Is Vanilla Powershell Enough of a Language for Windows & DB Server Admins?
Right - you can't administer Windows completely through ANY language, like I said. "There's no other language that works better across all of those Windows tools either." That's what I said.
Apr
30
comment Is Vanilla Powershell Enough of a Language for Windows & DB Server Admins?
Right, like you said, it will still require work to develop your own solution. We're heading toward the day where you never have to leave PowerShell to do your job, but we're not there yet, would you agree?
Apr
30
answered RAID configuration on ICH9R with 3xHDD for Windows and Linux
Apr
30
comment Gigabit really gigabit?
How did you try to saturate the network connection? If you're using FTP, try using several simultaneous sessions each transferring a large file (same thing with file copies). Some protocols do fallback and you'll see a sawtooth-style utilization graph where it goes up, up, up, and then hits the output buffer max, then drops back down to a slower rate.
Apr
30
answered Cheap clustering for SQL server
Apr
30
awarded  Critic
Apr
30
answered SQL server in VMware
Apr
30
answered HP MediaSmart Server - can it run WISA? Windows IIS SQL Server ASP.Net
Apr
30
comment Building optimal custom machine for Sql Server
To get a better answer, can you talk about the size of the databases involved (to know how memory & cache is affected) and whether they're read-biased, write-biased, and how much load you have on TempDB? For example, if you're using some snapshot modes you can end up with a higher load on TempDB, and you wanna plan for that.
Apr
30
comment Best Method or Tool to Migrate from MySQL to SQL Server
To get a better answer, can you talk about how much data you're migrating, how many tables, how many databases, and what the client app is written in? Your queries can change from MySQL to MSSQL, and you may want to include that as part of your question.
Apr
30
answered In SQL Server, when should you split your PRIMARY Data FileGroup into secondary data files?
Apr
30
awarded  Supporter
Apr
30
comment SQL Server setup check list
WOW, dude, that's the first time I've ever seen somebody else quote my setup checklist. I'm flattered. I'm so used to going into these questions and copy/pasting my own link to my checklist - now somebody else is doing it for me. Love it! So of course I gotta upvote ya, heh.
Apr
30
answered How to exclude indexes from backups in SQL Server 2008
Apr
30
awarded  Teacher
Apr
30
answered Is Vanilla Powershell Enough of a Language for Windows & DB Server Admins?
Apr
30
awarded  Autobiographer