Search results matching tags 'Performance' and 'SQL Programming'

Hear the SQL Server 2012 story on DotNetRocks

KKline — Fri, 31 May 2013 15:32:00 GMT

I was privileged to have a chat with my buddies over at www.dotnetrocks.com, Carl Franklin and Richard Campbell, episode number 876 (876!). Listen to the most popular internet audio talk show for .NET developers! Here's the abstract:

Carl and Richard talk to Kevin Kline about the latest features in SQL Server 2012. The conversation starts out talking about the new features that developers will love, like windowing - no need for cursors anymore, you can request a window of records from a set and move easily window-to-window. Kevin also talks about the new column store index that is especially useful with repeating data. There's also a discussion on the role of SQL Server in an increasingly NoSQL world, along with cool new technologies like Hadoop, Cassandra and Hekaton. Kevin closes with an offer of some free tools at SQL Sentry, including Plan Explorer, a tool to help you understand the query plans that SQL Server makes from your queries. Check it out!

Let me know what you think. Thanks,

-Kevin

- Follow me on Twitter!

- Google Author

Database Maintenance Scripting Done Right

KKline — Fri, 18 Feb 2011 13:16:00 GMT

I first wrote about useful database maintenance scripts on my SQLBlog account way back in 2008. Hmmm - now that I think about it, I first wrote about my own useful database maintenance scripts in a journal called SQL Server Professional back in the mid-1990's on SQL Server v6.5 or some such. But I digress... Anyway, I pointed out a couple useful sites where you could get some good scripts that would take care of preventative maintenance on your SQL Server, such as index defragmentation, updating statistics, and so forth. One of the script kits came directly from Microsoft's internal database management team. But, alas, they haven't published any updates in quite a while. On the other hand, the other set of scripts came from Ola Hallengren, who has done a great job keeping his scripts up to date. Recently, Ola added support for updating column statistics, both in a generalized update and also updates for only those columns whose statistics have been modified. He's added some other goodies to the latest release, which you can read about here, http://ola.hallengren.com/Versions.html for all details. In addition, I'd like to remind you of the white paper I wrote a while back called Automating DBA Processes, which covers many aspects of database automation and cherry picks some of the best practices from many different thought leaders, such as Ola, Michelle Ufford (blog | @sqlfool) who will be speaking at the 24HOP soon, and Allen White (blog | twitter).

Join Me May 19th for 24 Hours of PASS

KKline — Mon, 26 Apr 2010 14:16:00 GMT

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 and Brent 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 19.

Get an in-depth look at the hottest SQL Server and BI topics, including (but not limited to!) - the new SQL Server 2008 R2, with its business intelligence and data management innovations, and much more.

When does it start? 12:00 GMT (UTC):

New York: 08:00
Chicago: 07:00
San Francisco: 05:00
London: 13:00
Paris: 14:00
Moscow: 16:00
Mumbai: 17:30
Singapore: 20:00
Sydney: 22:00

The roster of phenomenal speakers features many MVPs and top-rated presenters, including Adam Machanic, Andy Leonard, Brad McGehee, Brent Ozar, Brian Knight, Chuck Heinzelman, Dean Richards, Don Kiely, Don Vilen, Donald Farmer, Glenn Berry, Greg Low, Jacob Sebastian, Jessica Moss, Kevin Cox, Kevin Kline, Louis Davidson, Maciej Pilecki, Peter Myers, Peter Ward, Rushabh Mehta, Sean McCown, Simon Sabin, Thomas Grosher.

Check out all the great SQL Server sessions you can attend for FREE. Share this information with a friend or colleague.

PASS is looking forward to having you join us all for this exceptional event. Please contact us at 24hrs@sqlpass.org with any questions. You can also find lots of general details at http://www.sqlpass.org/24hours/2010/.

2009: The Year in List Form

KKline — Tue, 05 Jan 2010 18:53:00 GMT

Before I jump onto the Goals and Themeword meme started by my buddy, Thomas LaRock (blog | twitter), I decided I'd spend a few minutes looking back on both the year 2009. (From a personal standpoint, the 00's were my most difficult decade yet. Major problems of every stripe beset me on all sides and with alarming frequency throughout the decade. I was all "Good Riddance" and "Don't let the door hit y'ass on the way out, 2009!" as the ball dropped in Times Square.)

Rather than spend a lot of time cooking up my own top 10 lists, I reckoned (that's Southern for "thought", btw) I'd recap a few others top X lists that are in the ballpark of my own personal opinion. I couldn't resist putting together my own list at the end, which I'd love to hear your thoughts on. In addition, I want to hear about your Top 10 (or 5 or 3) for 2009!

Their Lists

Time Magazine's list of Top 10 of Everything 2009 was a pretty good recap for the year on big ol' cultural touch points like movies and music. I found at least one thing to agree with in each of their pop culture lists: movies - The Hurt Locker - check; TV shows - my personal favorite for its brilliant cohesive multiyear storyline and excellent character studies, Lost - check; album - I and Love and You by the Avett Brothers - check; books (sigh - if only I had more time) included the wonderful The Age of Wonders by Richard Holmes.

Lifehacker's Top 5 Hive Topics of 2009 is a very interesting list covering lots of topics and pointing out a lot of interesting tools that I hadn't encountered before. My personal favorite among them was the Top 5 Alternative File Copiers, since the Windows Explorer copy feature reminds me of hungrily awaiting my food in the microwave and just as the counter gets to the T-10 countdown, it goes back up to 30, then down to 8, then back up to 42, then down to 14.

I'm not sure if they meant to be funny but Digg's Top 10 Most Popular Stories of 2009 is hilarious, much in the same way that Brent Ozar (blog | twitter) and I were when we put on an unintentionally hilarious performance at the PASS 2009 Summit Quiz bowl. Go ahead - ask Colin Stasiuk (blog | twitter) what he thought of our performance...

Impressed by Our Quiz Bowl Performance?

Speaking of unintentionally funny, have you seen Yahoo's Top 10 Searches of 2009? Evidently, the median Internet user (at least from their metrics) is hormone-laden, teenage redneck with a thing for fast cars (Nascar), Hollywood hotties (Megan Fox), and an unassailable but secret love for Mormon-influenced Vampires (Twilight).

My List

I usually try to blog at least once per week and, when I can, even more. I still have this deep down urge to post lots of small blog posts of just a couple paragraphs. But for some reason, I always seem to come out with these big ol' epistles. Despite my verbosity, y'all still read what I write and for that I'm very thankful. Over the last year, these were my top ten blog posts according to your interest:

Best of the [SQL Server] Blogs and its sister post Great Blogs from the Microsoft SQL Server Teams, also my number one spam generators. Ever spammer on the planet seems to want their comment appended here.
Microsoft Resources Too Good Not to Share, which I can't honestly remember if they were any good or not. But I bet they were.
Are We There Yet, Mom? in which I flashback to my childhood road trip experiences when considering Microsoft's overall product strategy.
Does the Down Economy Have an Impact on Your Job, cuz it sure punched mine in the mouth.
Why Do I Keep Seeing This Mistake, in which I learn that "Hello World" type applications can lead to massive misunderstandings.
Microsoft [Corporate] Marketing Throws SQL Server Under the Bus. We can't get no respect, not even from corporate HQ.
Looking for Good DMV Database Admin Queries, where you can find just about every good DMV query ever written except those other really good ones that are posted here in the comments.
Old Performance Recommendations Die Hard, and when I saw "die hard" I don't mean like Bruce Willis.
Things You Know Now, a semi-successful meme I started where I asked participants to tells us about stuff they'd do differently if they knew it way back in the day.
Understanding SQLIOSim Output, because no one seems to fully understand this tool, including me.

I excluded a few posts that were numerically in the top ten because, well, they're my blog posts and I didn't want them in the top ten. So there! But those that I excluded were things like reposting an interview done by another blogger or maybe a product or book that I plugged for some reason or an other.

I hope you've enjoyed my blogging and found it valuable. Tomorrow, I'm jumping on the themeword and goals meme. In fact, I'm crashin' the party because none of my peeps called on me. [pout]

Be well!

-Kevin

Twitter @KEKline

Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 <!--[if gte mso 10]> http://sqlblog.com/blogs/kevin_kline/archive/2007/06/28/understanding-sqliosim-output.aspx

Upcoming Seminar and SQL Saturday in Florida, Oct 13-17

KKline — Sun, 04 Oct 2009 21:24:00 GMT

Please join me for SQL Saturday #21 coming up on Saturday, October 17th. There are over 50 sessions on tap with great speakers from the area and across the nation. Some of the notable speakers include:

Andy Leonard (blog here)
Andy Warren (blog here)
Brian Knight (blog here)
Buck Woody (blog here)
Chad Miller (blog here)
Joe Celco (blog here)
Joe Webb (blog here)
Jonathan Kehayias (blog here)
Kendal Van Dyke (blog here)
Ken Simmons (blog here)

Not only do we have SQL Saturday coming up, but Andy & company put together five world class seminars the week leading up to it! Use code "KKLINE" to get a 20% discount if you register for two or more seminars!

Oct 12 - Essential SQL Server Administration By Andy Warren
Oct 13 - Learn BI In a Day by Brian Knight
Oct 14 - Real World Performance Tuning by Kevin Kline
Oct 15 - Zero to SSIS by Andy Leonard
Oct 16 - Performance Tuning Methodology by Buck Woody

Seminars will be held at the Embassy Suites in Altamonte Springs, FL. Each seminar is $149 and includes a full lunch. Seating is limited, register today!

Attendees of my seminar will get a free copy of my book, Database Benchmarking: A Practical Approach for Oracle and SQL Server, plus other free goodies from my employer, Quest Software. As an added note of explanation, Buck's excellent seminar centers around detecting and troubleshooting performance problems, while my seminar focuses on writing high-performance and highly scalable SQL and Transact-SQL code. Why not sign up for both of them to get comprehensive education on the entire process of writing great code, deploying it, and monitoring it for continued excellent performance?

Finally, I'll be speaking at user groups in the area leading up to SQL Saturday. If you can join me at my seminar or at SQL Saturday, maybe one of these other events better fits your schedule:

Tuesday, Oct 13, Tampa SQL Server User Group (http://www.tampasql.com)
Wednesday, Oct 14, Orlando SQL Server User Group (http://www.opass.org)
Friday, Oct 15, Jacksonville SQL Server User Group (http://jacksonville.sqlpass.org)

I h0pe to see you there!

-Kevin

Twitter @KEKline

Webcasts on-line

KKline — Thu, 08 Feb 2007 14:02:00 GMT

As I've been traveling around speaking at various SQL Server user groups, I get requests for my slide decks. Of course, I'm happy to share those, but I've got one better for you. As it turns out, you can find five of my most recent webcasts here. These are recorded webcasts that you can listen to any time. I believe that registration is required. The topics are:

- Ensure Optimal Performance in Deploying SQL Server 2005
- Worth Upgrading to SQL Server 2005
- SQL Query Tuning
- Disk Optimization and I/O Tuning on SQL Server 2005
- Best Practices for Stored Procedures Presentation

I'd love to hear your questions or comments about the sessions. Post comments here or email me at kevin_kline@sqlpass.org.

Enjoy,

-Kevin