Browse by Tags
» Troubleshooting (RSS)
Showing page 2 of 3 (25 total posts)
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 ...
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 ...
Lucy, You Got Some 'Splainin to Do!'
Quest Software's latest community initiative, Windows Azure-based Project Lucy, has debuted! Project Lucy is part infrastructure analytics, part social media experiment, and part performance data warehouse.
The best things about Project Lucy include:
It’s Free - just like our SQLServerPedia ...
Every year at PASS, I do the same thing. I hmm and haw over which sessions I want to go to, and I end up making some tough choices at game time. This year I believe I'll be pretty busy, so my typical pie-in-the-sky view of how much I'll be able to attend just isn't going to pan out. Instead, I have selected 5 sessions that I really ...
Join Us for 24 Hours of SQL Server Training
(with a special focus on SQL Server 2008 R2)Did I mention that your Cohorts in Crime
(that be me
Ozar) are presenting?!?
The FREE 24 Hours of PASS event is bringing an exceptional
lineup of SQL Server and BI experts to your computer starting at
12:00 GMT (UTC) on May ...
Quest Software Pain of the Week Webcast: The 5-Minute SQL Server Healthcheck
Join me and Christian Bolton, UK SQL Server MVP and blogger,as
we discuss how to quickly evaluate the basic health of your SQL Server
environment. You’ll learn about several quick checks you can perform in
minutes to determine if critical thresholds are being met—and ...
I’ve posted a new entry on my SQL Server Magazine blog about two free DMV monitoring tools available on CodePlex.Read the article here:http://www.sqlmag.com/Articles/ArticleID/102837/102837.html?Ad=1Take a look at the two tools and let me know which you like better and why. Inquiring minds want to know!Cheers,-Kevin Twitter ...
This is a recommendation I believe is worth repeating from time to time: Make sure you match data types when you write TSQL code. Else you in most cases end up with an implicit data type conversion. And in worst case, this conversion is performed at the column side - not the literal side of your query. What does that mean? Consider below: