Browse by Tags
» Administration (RSS)
Showing page 1 of 2 (16 total posts)
Uh oh!So you're plugging along in SQL Server Management Studio (SSMS) when it suddenly goes belly up. Now you're staring at various dialog boxes telling you that SSMS crashed. Usually the first dialog box you get will ask you if you'd like to close OR the program. If you choose to close the program, you'll be presented with the opportunity ...
I'm doing two new webcasts next week on Wednesday, December 19th, one in the morning and the other after lunch.
SSDs are a Game Changer for SQL Server Storage
No, session is not exclusively about SSDs. But this is my first session on IO and storage tuning that emphasizes SSDs over hard disks. As Bob Dylan said ''Times, they ...
In foreground, attendee makes dreaded ''shoot myself'' hand sign to the speaker.I was just telling the good people of Charlotte about how they (and how YOU) need to read all things by Paul Randal (blog | twitter), except for all of his cheesy romance novels like Caress and Conquer written under the nom de plum of ...
SQL Server comes with a wide array of tools for monitoring your environment. There are logs and traces that provide information when errors occur, but these are often used passively to react to events that have already occurred. There's PerfMon, and Profiler, and loads of Dynamic Management Views to check. But where to look?
When you're developing new Transact-SQL code or modifying some existing code, do you just launch directly into programming?
I know that I did just that, for years. It wasn't until I was trying to performance tune some existing code that I realized I hadn't actually taken caching of data and execution plans into account. So all those modified ...
First off - the Pain of the Week webcast series has been renamed. It's now known as The Expert's Perspective.
Please join us for future webcasts and, if you're interested in
speaking, drop me a note to see if we can get you on the roster!
bigger your databases get, the longer backups take. That doesn't really
seem like a ...
Interested in my various performance tuning and troubleshooting
videos about SQL Server? These videos feature my good buddies (and
uber-SQL Server experts) Brent Ozar (blog | twitter) and Buck Woody (blog | twitter).
View these insight-packed training videos from our SQL Server training
events originally presented on ...
There are so many great tools out there for data professionals using
Microsoft SQL Server. I really like to see all of these great tools
made free to the public. On the other hand, I'm bummed that the tools
are cast about in a very decentralized fashion. If you haven't done
migrations before, you might want to start with these ...
I profiled Adam Machanic's (blog | twitter)
excellent stored procedure, SP_WHOISACTIVE, back in August of 2010 in
my monthly SQLMag column, Tool Time. Adam has been diligent about
maintaining the tool and adding new features. Read the details on my SQLMag Tool Time column (here - ...
One of the things that I enjoy about working for Quest Software is that we give back copiously to the community. From activities and offerings like SQLServerPedia, to our free posters mailed anywhere in North America (and don't forget the free hi-res PDFs for the rest of the world),
Don't forget that free DVDs of our virtual conferences ...