Chad Miller put out a new SQL Server PowerPack for Quest’s free PowerShell tool, PowerGUI, which got me to thinking – I wonder if there’s been more PowerShell adoption lately?
[poll id="2"]
And because the results can get skewed by job description:
[poll id="3"]
Thanks for taking the time to answer! Your feedback is a giant wooden stick that, [...]
In my SQL Server CMDB webcast this week, I ran a poll: how many of the ~100 attendees had worked with PowerShell?
No, but plan to – 40%
No, and don’t plan to – 40%
Yes, for 0-6 months – 10%
Yes, for 6 months or more – 10%
I’m rounding those percentages. The short story was that 4 in [...]
On Wednesday night at 8:30 PM CST, I’ll be appearing on the live Mind of Root show with Steve Murawski:
We will have Brent Ozar, SQL Server Expert for Quest Software, joining us to talk about becoming a DBA (Database Administrator), a sysadmin’s guide to working with DBA’s, and tips for sysadmins who have become “Accidental DBA’s”. We’ll [...]
Pop quiz: should you be worried if your SQL Server’s page life expectancy is averaging 214? There’s only one correct answer: it depends.
Performance tuning is all about finding the RIGHT bottleneck, focusing on it, and fixing it to the application owner’s satisfaction. Learn what happens if you don’t do it right.
Read More »Erika’s friends call her “Fancy Feast” because she only likes the best things in life. She’s got champagne tastes, but we can’t afford to buy the best of everything. I recently picked up a coffee table from Ikea, and it got me thinking about SQL Azure.
In a perfect world, I’d have on-premise SQL Server for every database. I’d use cutting-edge storage and cluster everything. But this isn’t a perfect world…
Read More »I get a lot of questions from people who want to get a better job. They want to know if certification, training, or branching out will help them get the job of their dreams. These things just aren’t the real answer.
The answer is simple: the Buddy System. Learn why.
Read More »In high school, I threw a huge party in Grandma’s house. It had long-lasting implications – among other things, I got disinherited.
Learn why SQL Server data compression has a lot in common with me after that Jungle Juice bash.
Read More »When my Grandpa Ozar wanted to find out if his 10 megabyte 5.25″ hard drive was responding fast enough to handle his database loads, he monitored the Perfmon counter Physical Disk: Disk Queue Length.
Things have changed since Grandpa’s time, though, and now it’s time to learn a new performance tuning trick – SQL Server waits.
Read More »