I always enjoy presenting at the DevLink conference, presented each summer in middle Tennessee. This year, I'm trying to be a better social media person and actually post my slides (in their most recent forms) on my SlideShare account for everyone to see and share. If you attended my session(s) and enjoyed them, feel free to download the content here. But it'd be even better if you also left a few words in the Comment section. Skip below to grab the slide decks. Thanks very much! Enjoy, -Kevin -Follow me on Twitter! -Google Author Microsoft SQL Server Internals & … [Read more...]
Third Party Applications and Other Acts of Violence Against Your SQL Server
I just got finished reading a great blog post from my buddy, Thomas LaRock (t | b), in which he describes a useful personal policy he used to track changes made to his SQL Servers when installing third-party products. Note that I'm talking about line-of-business applications here - your inventory management systems and help desk ticketing apps. I'm not talking about monitoring and tuning applications since they, by their very nature, need a different sort of access to your back-end server resources. (Full disclosure: both Tom and I currently work for different tools vendors. But we're both … [Read more...]
Filed Under: Administration, Databases, On-Line Resources, SQL Server, SQLServerPedia Syndication Tagged With: Best Practices, DBA
Join Me at the Ft. Lauderdale SQL Saturday on June 14, 2014!
Join Me at SQLSaturday #288 in Beautiful Ft. Lauderdale, FL SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This event will be held Jun 14 2014 at 3301 College Avenue, Davie, FL 33314. Admittance to this event is free, all costs are covered by donations and sponsorships. Please register soon as seating is limited, and let friends and colleagues know about the event. Where Is It? This event will be held on Jun 14, 2014 at Nova Southeastern University 3301 College Ave, Davie, FL 33314. You need to go to the Carl … [Read more...]
Filed Under: Conferences, Databases, PASS, Performance, Presentations, SQL Server, SQLMag, SQLServerPedia Syndication, Transact-SQL Programming Tagged With: SQLSaturday, Transact-SQL Programming
Interested in Self-Service Analytics at the PASS Business Analytics Conference?
I don’t know if you’re planning to attend the PASS Business Analytics Conference. But you'll be missing a ton of great content especially for data, analytics, and business intelligence professionals. There's still plenty of time to register and, if you use my discount code – BABS2B – you'll get $150 off the conference registration fee. There will be more than 60 sessions at the event by BA/BI experts from Intuit, Microsoft, SurveyMonkey, Wells Fargo, and more. Last year’s inaugural event was quite the shindig, bringing in around 900 business analysts, data scientists, architects, and BI and … [Read more...]
Filed Under: BigData, Business Analytics, Business Intelligence, Cloud, Conferences, Databases, PASS, Presentations, SQL Server, SQLMag Tagged With: Business Intelligence, SQL Server 2012
Top 10 DBA Mistakes on SQL Server
Hear one of my most popular session via streaming media at SQLSentry.TV! Microsoft SQL Server is easier to administrate than any other relational database on the market. But “easier than everyone else” doesn’t mean it’s easy. And it doesn’t mean that database administration on SQL Server is problem free. And since SQL Server is constantly growing from small, home-grown applications, many IT professionals end up encountering issues that others had tackled and solved years ago. Why not learn from those who first blazed the trails of database administration, so that we don’t make … [Read more...]
Filed Under: Administration, Challenges, Contests, Databases, IO, IT Horror Stories, On-Line Resources, Performance, Presentations, SQL Server, SQLMag, Tips & Tricks, Video
Join Me on March 14 in Silicon Valley for a Full-Day of SQL Server Configuration Tuning Lessons
Join me for a day of Real World Database Configuration and Tuning for Microsoft SQL Server SQL Saturday Silicon Valley 2014 Friday, March 14, 2014 from 8:30 AM to 4:00 PM (PDT) Mountain View, CA Click HERE to register Now! Seating is very limited! This full-day training event combines a thorough overview of fundamental architectural concepts of the SQL Server relational engine followed by hands-on demos to reinforce each conceptual lesson. Since most technologists learn by doing, this training is designed to maximize the time attendees spend working with SQL Server. … [Read more...]
Filed Under: Challenges, Databases, PASS, Performance, Presentations, SQL Server, SQLMag, SQLServerPedia Syndication Tagged With: Best Practices, Configuration, DBA, Troubleshooting
One Preparation that makes SSMS Crash Dumps Easy to Survive
Uh oh! So you're plugging along in SQL Server Management Studio (SSMS) when it suddenly goes belly up. Now you're staring at various dialog boxes telling you that SSMS crashed. Usually the first dialog box you get will ask you if you'd like to close OR the program. If you choose to close the program, you'll be presented with the opportunity to recover your lost SQL scripts once you reopen SSMS, as shown above. (Image above courtesy of Aalam Rangi). But let's say that closing the program represents a big issue for you due to lost time, productivity, etc. You want to go … [Read more...]
Filed Under: Challenges, Databases, IT Horror Stories, SQL Server, SQLMag, SQLServerPedia Syndication, Tool Time Tagged With: Best Practices, DBA, Developer, SQL Server 2012
Now Playing: RunAsRadio
I had the privilege last week of talking with Richard Campbell (t), Microsoft MVP and host of the very popular RunAsRadio podcast, a sister-show to the worldwide phenomena known as .NET Rocks!. Here's the write-up Richard used to describe the show: Richard talks to Kevin Kline about what's coming in SQL Server 2014. Yes, the database continues to evolve and Kevin digs into many of the new features. The conversation also jumps into the NoSQL movement and it's many forms, including making simple data storage easier for developers as well as the creation and management of big data solutions. … [Read more...]
Filed Under: Cool Technologies, Databases, Interviews, Opinion, SQL Server, SQLMag, SQLServerPedia Syndication Tagged With: BigData, NoSQL, SQL Server 2014
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 resource, activity, or process. Since wait statistics are categorized by type, one look will quickly tell the variety of problem that needs your attention, assuming you know meaning for Microsoft's lingo for each wait type. (As an aside, wait stats were implemented in the earliest days of relational database computing because the early RDBMSes ran on … [Read more...]
Filed Under: Databases, On-Line Resources, Performance, SQL Server, SQLMag, SQLServerPedia Syndication Tagged With: DBA, Monitoring, Performance, SQL Server 2012, Tools, Wait Stats
Now Playing on SSWUG TV!
Hi friends, I know a lot of you regularly read my blog either on my home page at KevinEKline.com, on SQLBlog.com, or one of the locations where it's syndicated. And you may also regularly take in my content on SQLSentry.TV or my monthly column on Database Trends & Applications magazine. Click the image to see my new weekly video series on SSWUG.org! Now I'm adding a new video format to the mix, in partnership with my friend Steven Wynkoop and SSWUG.org. I've been a frequent speaker in the SSWUG virtual conferences over the past several years and, we thought, why not … [Read more...]
Filed Under: Administration, Architecture, Cool Technologies, Databases, On-Line Resources, Opinion, Professional Development, SQL Server, SQLMag, SQLServerPedia Syndication Tagged With: Best Practices, Business Intelligence, cloud computing, DBA, Developer, Leadership, Management, Professional Development, SQL Server 2012
