THE SQL Server Blog Spot on the Web

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

Search

You searched for the word(s):
Showing page 1 of 108 (1,079 total posts) < 1 second(s)
  • SSIS Catalog Environments– Step 20 of the Stairway to Integration Services!

    SSIS Catalog Environments Step 20 of the Stairway to Integration Services is live at the Stairway to Integration Services site at SQL Server Central! Enjoy! :{&gt;
    Posted to Andy Leonard (Weblog) by andyleonard on February 18, 2015
  • Interpreting Communication

    One important thing about which to be self-aware is how you interpret communication. Communication is a two-phase commit. The first part lies with the person communicating. She has an idea she wishes to communicate, and she communicates it in writing or verbally. The second part is with the person (or people) to whom the communication is ...
    Posted to Andy Leonard (Weblog) by andyleonard on January 28, 2015
  • Executing SSIS: Run SSIS Packages in the SSIS Catalog via Stored Procedure

    In my article titled A Custom Execution Method Level 19 of the Stairway to Integration Services posted at SQL Server Central, I created a stored procedure to execute SSIS packages stored in the SSIS Catalog. Really, all I did was build a rudimentary wrapper for the stored procedures used by the SSIS Catalog to execute packages. To learn more ...
    Posted to Andy Leonard (Weblog) by andyleonard on January 26, 2015
  • Self-Awareness – Feedback

    Self-awareness is an important trait. I believe it is especially important for consultants. For each of us, there is some gap between reality and what we perceive. I believe one measure of humility (or pride) is this self-awareness delta. I also believe we can narrow this gap by engaging in exercises in intentional awareness. Which exercises? ...
    Posted to Andy Leonard (Weblog) by andyleonard on January 23, 2015
  • Managing Geeks Now Available for the Kindle!

    Managing Geeks A Journey of Leading by Doing is now available at Amazon in paperback and Kindle editions! Many people have expressed interest in obtaining an electronic copy of Managing Geeks. Im sorry it took this long, but it is finally available. On a related note, I now know a lot more about self-publishing. The book is based on a ...
    Posted to Andy Leonard (Weblog) by andyleonard on January 22, 2015
  • A Custom Execution Method – Level 19 of the Stairway to Integration Services!

    A Custom Execution Method Level 19 of the Stairway to Integration Services is live at the Stairway to Integration Services site at SQL Server Central! Enjoy! :{&gt;
    Posted to Andy Leonard (Weblog) by andyleonard on January 21, 2015
  • re: SSIS Expression Language and the Derived Column Transformation

    Hi KentD, &nbsp; For today's date at the local time of my typing, your char(19) would equal '2015/01/19 08:38:30'. To convert this to a SQL Server DateTime data type in SSIS I would using an SSIS Expression Language Casting function. It would look like this: &nbsp; (DT_DBTIMESTAMP)'2015/01/19 08:38:30' Hope this helps, Andy
    Posted to Andy Leonard (Weblog) by andyleonard on January 19, 2015
  • Administering SSIS: Security-related SSIS Questions

    I credit my friend and brother, Chris Yates (Blog | @YatesSQL), for inspiring me to write this post with his (excellent) post: Reports in SSIS. If I had a nickel for each time Ive been asked, What permissions are required for SSIS? I would have a lot of nickels. Its a fair question with an unfair answer, It depends. It Depends on ...
    Posted to Andy Leonard (Weblog) by andyleonard on January 19, 2015
  • Administering SSIS: Parsing SSIS Catalog Messages for Lookups

    ''The SSIS Catalog is a database and an application.'' - Andy Leonard, circa 2015 If theres one thing I want you to get from this post, its this: The SSIS Catalog is a database and an application. While its a pretty cool database and application, it isnt anything different from the databases and applications you support every day. As ...
    Posted to Andy Leonard (Weblog) by andyleonard on January 16, 2015
  • When Wronged…

    My lovely bride and I visited Paris last year for SQL Saturday 323. We stuck around a few days to do touristy stuff and we learned a lot about the history of France. While reading about an uprising in the late 1800s, Christy stumbled upon the story of l'affaire Dreyfus (the Dreyfus Affair). In 1894 Captain Alfred Dreyfus was convicted of treason ...
    Posted to Andy Leonard (Weblog) by andyleonard on January 14, 2015
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement