Posts Tagged ‘Internals’

Microsoft SQL Server Internals & Architecture Matter!

Tuesday, August 2nd, 2011

EPIC FAIL!  This was supposed to go out last week.  But I didn’t schedule it properly, so I’d just like to point out that there are lots of other great webcasts to watch at the Pragmatic Works webcast URL below.  Plus, my session will be available via streaming by the end of the week.  And thanks the the 1600 folks who registered!

 

-=-=-=-

 

Come join me on Tuesday, August 2, 2011 11:00 AM – 12:00 PM EDT for a free webcast covering the internals and architecture of Microsoft SQL Server.  It’s not everyday that a dry topic like this is presented in a fun and easy to understand format, so get in while the gettin’ is good.  :^)

Registration is free, thanks to the fine folks at Pragmatic Works.

REGISTER HERE

And don’t forget to check out all of Pragmatic Works’ other free webcasts.  It’s great stuff and it’s FREE!

Enjoy,

-Kev

Follow me on Twitter

 

Available Online – SQL Server Training Videos

Tuesday, May 31st, 2011

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 (blogtwitter) and Buck Woody (blogtwitter).  View these insight-packed training videos from our SQL Server training events originally presented on March 3 and July 21 of 2010:HERE.

You can watch the videos now at the URL above or order a DVD, shipped free of charge in the USA and Canada, HERE.

Enjoy!

-Kev

~~~

Twitter at kekline

More content on my Blog

New on SQLMag.Com: Update to SP_WHOISACTIVE

Thursday, April 21st, 2011

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.

Enjoy!

-Kev

Back in Atlanta! Wed, Feb 9 2011

Monday, February 7th, 2011

Me and Adam, er, Aaron

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 things.  However, one of the few things that my memory is usually really good at is remember names & faces (and remembering stories, but that is another story as well).

It’s only in the last couple years that I’ve gotten to know Atlanta-area folks like Aaron Nelson (blog | twitter), at left.  Aaron likes to tease me because the first time or two we talked after our initial introduction, I kept getting his name wrong.  That’s uncharacteristic of me.  But, hey, I was distracted because Aaron had brought his 12 year old daughter along and I kept wishing that I’d brought mine!  Aaron has really good content on SQL Server and PowerShell on his blog and in his presentations.  Don’t miss out!

The Flying Ainsworth Brothers

Another person in the Atlanta area I’ve enjoyed getting to know better is Stuart Ainsworth (blog | twitter).  Stuart has really stepped up to the plate these last couple years as a leader and a volunteer.  I’m really impressed with his efforts, especially because they’re in very important but rather invisible and thankless tasks.  One example is his work in succession governance for PASS.  Stuart, I salute you and thank you for your efforts.

I hope to see y’all there!  And if I don’t, y’all come up and visit us in Nashville some time.

Cheers,

-Kev

Video: Where are good SQL Server resources?

Thursday, January 27th, 2011

Kevin discusses resources online that he uses and considers to be excellent destinations for SQL Server professionals. Kevin will discuss each site he uses in detail – check it out!

Posted August 15, 2008.

Video: Ensure Optimal Performance When Deploying SQL Server 2005

Thursday, December 16th, 2010

Kevin Kline will offer insight into best practices for SQL Server 2005 set up, configuration and queries. He will also discuss tuning for both the server and hardware to help an application perform better after it is deployed. This presentation will offer a better understanding of several SQL Server performance related areas including:
* Hardware design
* SQL Server configuration settings
* Database configuration settings
* Application design
* SQL Tuning

Posted December 20, 2006.

Video: SQL Server Memory Troubleshooting

Tuesday, November 23rd, 2010

Need to troubleshoot SQL Server 2005 memory settings? Not sure where to look to measure SQL 2000 memory pressure? Kevin lays out your options in today’s podcast.

You can view this video in higher quality or your favorite portable formats at:

http://sqlserverpedia.com/blog/sql-se…

Video published December 24, 2008.

And the Winners are…

Thursday, November 18th, 2010

The winners were named last week in our contest for bloggers on SQLServerPedia.  Lots of great bloggers and great articles for you to read.

A complete list of the winners is here:

The First Annual SQLServerPedia Blogger Contest

Thanks to the thousands who participated!


Follow me on Twitter!

DBTA: What’s the Fuss about Data Deduplication?

Tuesday, November 16th, 2010

Listen to a group of database professionals talk for awhile and someone will eventually bring up the topic of data deduplication. Data deduplication is a means  to eliminate redundant data, either through hardware or software technologies.  To illustrate, imagine you’ve drafted a new project plan and sent it to five teammates asking for input.  That single file has now been reproduced, in identical bits and bytes, on a total of six computers. If everyone’s email inbox is backed up every night, that’s another six copies backed up on the email backup server.  Through data deduplication technology, only a single instance of your project plan would be backed up, and all other instances of the identical file would simply be tiny on-disk pointers to the original.

[READ MORE]

Posted Dec 14, 2009

Follow me on Twitter!

TN Summit 2010 – Surviving the Data Avalanche

Tuesday, November 9th, 2010

Here’s the link to my revamped presentation on Surviving the Data Avalanche

The Abstract for this presentation is here.

The slides for this presentation are here.