BrentOzar

44 ms·

481.
by BrentOzar 14y ago
Brent the author here. No, I did not expect the Surface to be as productive as a Windows laptop, but I did expect that Word would be able to keep up with me while I type - just as any other modern device is. I'm not asking to do 3D renderin
482.
by BrentOzar 14y ago
Brent the author here. I use Google's app-specific passwords and I've already disabled my Surface RT passwords when I boxed it back up this morning. I salute you though!
483.
by BrentOzar 14y ago
Brent the author here. I'd be really curious to hear which portions of my experience are edge cases - typing in Word, using the camera, and checking my email don't seem out of the mainstream to me on a tablet whose main market purports to b
484.
by BrentOzar 14y ago
Hi. Brent here, the post author. Thanks for making the point. I had hoped that by recording videos of the problems, I wouldn't get attacked as just making off the cuff observations. Readers can see the problems for themselves. Still getting
485.
Microsoft SQL Server 2012 AlwaysOn AGs at StackOverflow(brentozar.com)
2 points by BrentOzar 14y ago|0 comments
486.
by BrentOzar 15y ago
>> But, if you store a SSN as say 123-45-6789 your using at least 11 bytes to store a 4 byte number. Plus it gets worse because people inevitably end up writing queries that parse the number with dashes, brackets, or other special d
487.
by BrentOzar 15y ago
The size of guids isn't the only challenge. (The size is a little trickier than it looks, too - remember that the guid will be included in every index so the database can find its way back to the clustered index.) The other problem with gu
488.
by BrentOzar 15y ago
Add an index to support foreign key relationships. If you've got a SalesHeader table and a SalesDetail table, you want an index on SalesDetail.SalesHeaderID, especially if you allow cascading deletes from the SalesHeader table.
489.
by BrentOzar 15y ago
It actually comes from Itzik Ben Gan's presentation, "Bug or Feature." He covers an array of SQL Server behaviors and asks the audience to guess whether it's a bug or feature, and then explains the answer.
490.
by BrentOzar 15y ago
RENTING, hahaha, I never thought of myself that way. I like it. I'm going to use a "For Rent" sign around my neck in an upcoming blog post!
491.
by BrentOzar 15y ago
I consider DBA-level skills as the ability to read an execution plan, figure out what indexes are being used, know the difference between a good plan and a bad one, and figure out how to rewrite your query to get the performance & plan
492.
by BrentOzar 15y ago
You'll want to watch the video, because I explain that in more detail. Of course I'm not against change control or security, but if you want to scale a database, everybody involved has to have DBA-level skills. StackExchange's sysadmins a
493.
by BrentOzar 15y ago
Sadly, yes - obviously it's not this site's target audience, but a lot of PHBs out there are buying into it hook, line, and sinker.
494.
by BrentOzar 15y ago
Yep, absolutely, you nailed it. There's a gazillion presentations out there about tuning databases, but that only takes you so far. I wanted to show that you need to take a step back before you go into query tuning details.