Browse by Tags
» Administration (RSS)
Showing page 1 of 2 (13 total posts)
(Originally appearing at http://kevinekline.com/2013/10/09/wait-statistics-in-sql-server/).When it comes to troubleshooting in relational databases, there's no better place to start than wait statistics. In a nutshell, a wait statistic is an internal counter that tells you how long the database spent waiting for a particular ...
It's an old story you've probably heard before. Provide a free version of your software product with strict limitations on performance or other specific capabilities so that folks can give it a try without risk, while you minimize the chance of cannibalizing sales of your commercial products. Microsoft has take this strategy ...
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 ...
Back when my day-to-day duties included database administration work and enterprise architecture, I became rather obsessed with the idea of operational excellence. I read everything I could on the topic. I made a list of favorites, which became somewhat shabby over time, as I dog-eared important pages and scribbled notes in the margins. ...
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 - ...
I’d like your opinion here.
Follow my logic here for a moment as I walk through a couple
rhetorical questions. Have you ever had a friend developed an
application entirely on SQL Server Developer Edition? (Not that YOU
would ever do such a thing, but maybe you know someone who has. Right?)
And has your friend’s IT department ...
I always enjoy spending time with my friends from Atlanta, as well as meeting folks and making new friends. If you live in the Atlanta area, I hope you'll join me on the evening of Wednesday, February 9th, 2011. Details are at the Atlanta SQL Server user group website.
It's common knowledge that I have a terrible memory for many ...
Back in late May, my pal Buck Woody (blog | twitter) and I presented SQL Server for the Oracle DBA. Buck played Jerry Lewis' role, while I played the straight man a la Dean Martin. You can see the recording and slide deck here. Since both Buck and I spent a considerable number of years working on Oracle, we felt like we had ...
We've got two sessions that you need to sign up
for right away. The upcoming webcast for Oracle-oriented folks has huge
registration numbers. So get in while you still can before we hit the
limit of what LiveMeeting can handle.
of the Week: SQL Server for the Oracle DBA
Webcast: SQL Server for the Oracle DBADate:
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 ...