THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Best Practices   (RSS)
Showing page 1 of 15 (145 total posts)
  • Three Free Webinars About Using the SSIS Catalog

    Kent Bradshaw and I are delivering a series of webinars 27-29 Dec 2016 called SSIS Academy: Using the SSIS Catalog. Why? We’ve been using the SSIS Catalog in Production since 2012. We’ve learned a lot about how it works. Some parts of the SSIS Catalog are complex and we want to share – as best we can – what we’ve learned. The daily ...
    Posted to Andy Leonard (Weblog) by andyleonard on December 22, 2016
  • Use Biml to Remove Spaces from Flat File Column Names

    I hate a space in a database column name. Kent Bradshaw and I are updating our demo for loading National Provider Index (NPI) file data (We plan to present on this soon… more later…). The NPI files currently have 329 fields and almost every one of them contains spaces: I had 5 minutes, so I decided to fix it with Biml. I first created an SSIS ...
    Posted to Andy Leonard (Weblog) by andyleonard on July 6, 2016
  • Four New Slide Decks for SQL Server and IT Pros from the DevLink 2014 Conference

    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 ...
    Posted to Kevin Kline (Weblog) by KKline on August 29, 2014
  • 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 ...
    Posted to Kevin Kline (Weblog) by KKline on August 12, 2014
  • Writing and Delivering a Successful Full-Day Technology Seminar

    I was recently chatting with the current President of PASS, Thomas LaRock (Twitter | Blog), and Pieter Vanhove (Twitter | Blog), a prominent SQL Server consultant and expert in Belgium, about how I go about building and presenting a full-day technical seminar. In the SQL Server world, we tend to call these ...
    Posted to Kevin Kline (Weblog) by KKline on May 6, 2014
  • Top 10 DBA Mistakes on SQL Server. (Now with Prizes for Participation!)

    The first big mistake I made as a DBA was coming to work with my zipper wide open. But I digress.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 ...
    Posted to Kevin Kline (Weblog) by KKline on April 9, 2014
  • Join Me on March 14 in Silicon Valley for a Full-Day of SQL Server Configuration Tuning Lessons

     Join me for a day ofReal World Database Configuration and Tuning for Microsoft SQL ServerSQL Saturday Silicon Valley 2014Friday, March 14, 2014 from 8:30 AM to 4:00 PM (PDT)Mountain View, CAClick HERE to register Now! Seating is very limited! This full-day training event combines a thorough overview of fundamental architectural concepts ...
    Posted to Kevin Kline (Weblog) by KKline on February 18, 2014
  • 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 ...
    Posted to Kevin Kline (Weblog) by KKline on February 10, 2014
  • SQL Rally Pre-Con: Data Warehouse Modeling – Making the Right Choices

    As you may have already learned from my old post or Adam’s or Kalen’s posts, there will be two SQL Rally in North Europe. In the Stockholm SQL Rally, with my friend Thomas Kejser, I’ll be delivering a pre-con on Data Warehouse Modeling: Data warehouses play a central role in any BI solution. It's the back end upon which everything in years to ...
    Posted to Davide Mauri (Weblog) by manowar on October 9, 2013
  • 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 ...
    Posted to Kevin Kline (Weblog) by KKline on September 10, 2013
1 2 3 4 5 Next > ... Last »
Privacy Statement