Browse by Tags

• Administration
• Best Practices
• Career
• Cloud Computing
• Conferences
• Database Design
• DBA
• Fusio-io
• Hekaton
• Internals
• IO
• NoSQL
• Opinion
• PASS
• People
• Performance
• Professional Development
• Speaking
• SQL Server 2012
• SQL Server 2014
• SQLMag
• Tips
• Tools
• Transact-SQL Programming
• Troubleshooting

• ICYMI: Partitioning Advice, Purging Data Bloat, and an example of TVF Misbehavior - SQL Server Performance

  Here are some oldies, but goodies that I recommend you read: Two Partitioning Peculiarities and Aggregates and Partitioning Most of us know that partitions are one of the best ways to scale very large databases or very large IO workloads. However, there Read More... Posted Monday, March 30, 2015 10:24 AM by KKline | 0 Comments Filed under: SQL Programming, Internals, Troubleshooting, PASS, Database Design, Developer, DBA, Transact-SQL Programming

• ICYMI: Query Optimization Phases, Observer Overhead, and Secrets of SP_Updatestats - SQL Server Performance

  Do you do a bit of query tuning? Then check out this treasure trove of performance tuning advice! Optimization Phases and Missed Opportunities and Working Around Missed Optimizations Paul White ( b | t ) writes two fascinating blog posts that go hand-in-hand Read More... Posted Monday, March 23, 2015 10:20 AM by KKline | 0 Comments Filed under: Performance, SQL Programming, Developer, Transact-SQL Programming

• ICYMI: Troubleshooting CPU, Logging Myths, Missing Indexes, and Query Tuning Examples

  Great Articles at SQLPerformance.com There are so many good articles from SQLPerformance.com this ICYMI article that it’s hard to know which are best to highlight in the limited space. So, I’ll be arbitrary and simply choose a few of my favorite entries Read More... Posted Monday, March 16, 2015 10:08 PM by KKline | 0 Comments Filed under: Performance, SQL Programming, Troubleshooting, Database Design, Developer, Transact-SQL Programming

• The SQL Sentry forum for SQL Statement Tuning

  Check out this community website dedicated to helping SQL programmers tune their most difficult and problematic queries. Read More... Posted Wednesday, February 25, 2015 11:48 AM by KKline | 6 Comments Filed under: Performance, SQL Programming, Developer, Transact-SQL Programming

• Four New Slide Decks for SQL Server and IT Pros from the DevLink 2014 Conference

  Get slides about Microsoft SQL Server: Internals & Architecture, Top 10 DBA Mistakes, Ten SQL Coding Practices, and Persuasion Techniques for IT Pros Read More... Posted Friday, August 29, 2014 7:37 AM by KKline | 2 Comments Filed under: SQL Programming, Best Practices, Administration, Internals, Professional Development, Conferences, Tools, Developer, Career, SQL Server 2014

• Hear the SQL Server 2012 story on DotNetRocks

  Listen to a fun and informative a chat about SQL Server 2012 with my buddies over at www.dotnetrocks.com, Carl Franklin and Richard Campbell, in episode number 876 (yes, 876!) Read More... Posted Friday, May 31, 2013 11:32 AM by KKline | 1 Comments Filed under: Performance, SQL Programming, Cloud Computing, Developer, NoSQL, SQL Server 2012, IO, Hekaton, Fusio-io

• Dev Advice: Make a Tiny Dev Database Act Like a HUGE Prod Database

  If you're struggling with doing development on a big SQL Server database, learn the ropes on cloned databases asap! Read More... Posted Friday, March 16, 2012 10:30 AM by KKline | 3 Comments Filed under: SQL Programming, Best Practices, Tips, Tools, Developer, SQLMag, Transact-SQL Programming

• How Do You SKU?

  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 Read More... Posted Wednesday, March 30, 2011 10:49 AM by KKline | 9 Comments Filed under: SQL Programming, Administration, Internals, Opinion, Database Design, Developer

• Join Me May 19th for 24 Hours of PASS

  Check out all the great SQL Server sessions you can attend for FREE in this on-line event. Read More... Posted Monday, April 26, 2010 10:16 AM by KKline | 0 Comments Filed under: Performance, SQL Programming, Administration, Internals, People, Speaking, Troubleshooting, Professional Development, PASS, Database Design, Cloud Computing, Developer