Search Results: KILL

• 
  SSIS - Using SP_Who and KILL for Table Locks

  The dreaded table lock can occur and cause your SSIS packages to fail. A popular request I receive asks “How can I get rid of these table locks?” This blog will show you how to build a package that will kill any SPID’s that are running on your system that

  Author:  MikeDavis     Date: 12/20/2010     Section: Blog

  tags : Kill, SP_Who, SP_Who2, Table Lock, SSIS
• 
  Kill them all... Your SPIDs of course!

  I had a pretty common task to perform the other day. And that task was to simply restore a database on a development server. Now, restoring a database in and of itself is a very simple thing to do. So simple, it's probably one of the very first things you

  Author:  kylewalker     Date: 6/25/2012     Section: Blog

  tags : KILL, Restore database, SPID, SQL Server
• 
  How to become an Exceptional DBA

  Today I have attended the webinar by Brad McGehee titled 'How to become an Exceptional DBA' which was an inspirational talk about why and how you need to be exceptional. Characteristics of an Exceptional DBA : Enjoy Technology, challenges, problem solving

  Author:  indupriya     Date: 2/23/2010     Section: Blog

  tags : Exceptional DBA, DBA
• 
  Truncating Transaction logs

  You want to grow your transaction log out to the largest size it needs to hold the largest transaction (very simplified way of putting it). If you're in full recovery mode you should be taking frequent transaction log backups. If you don't, the transactio

  Author:  sqlchicken     Date: 6/10/2011     Section: Forum

  tags : administration, transaction logs, vlf, dba
• 
  Tour de Career: Team Roles

  In cycling each team is made up of nine riders. Each rider on a team can have a different specialization. A careful balance of skill sets on a team can determine if a team will stand triumphant on a champion's podium at the end of the day or simply fade i

  Author:  sqlchicken     Date: 7/26/2010     Section: Blog

  tags : profdev, tour de career, professional development
• 
  The Rewards of the Foundation

  Hi All, My name is Sherri McDonald and the instructor for the Pragmatic Works Foundation. When I first started teaching the Foundation class, it was a nice addition to my current responsibilities. As I have facilitated the class for a year now, it is so m

  Author:  SMcDonald     Date: 10/26/2011     Section: Blog

  tags : Free I.T. training, free training
• 
  STOP! Consolidate and Listen

  I just wrapped up my 24 Hours of PASS session on consolidation. A big THANK YOU again to everyone in attendance, who kindly put up with my horrendous rapping "skills"! As promised, below is the link to the slide deck. In the presenter's notes you'll find

  Author:  sqlchicken     Date: 3/21/2012     Section: Blog

  tags : 24 Hours of Pass, 24HOP, Consolidation, presentation
• 
  Memorized Reports

  While all suggestions are good ones, you could capture the results of the parameters and the users from the ReportServer database. There are executions of each report, who executed them, how long it took and a lot more. With that being said, you would jus

  Author:  briankmcdonald     Date: 9/10/2012     Section: Forum

  tags : Brian K. McDonald, parameters, Pro SQL Server 2012 Reporting Services, SQLBIGeek
• 
  SSIS 2012 Best Practices

  Not bad but just a few things to think about. First, the "best infrastructure" is what's best for your needs. For example I could recommend buying a DL980 with 1TB of RAM to host your SSIS infrastructure but it could (probably) be way overkill for your ne

  Author:  sqlchicken     Date: 8/27/2012     Section: Forum

  tags : Architecting a Promotion System, architecture, infrastructure, SSIS architecture
• 
  Study/Training Tips for Passing Microsoft Certification Exam 70-452 (MCITP)

  After earning my MCTS certification a few months back, I jumped right into prepartion for passing the 70-452 certification exam (MCITP). Shortly thereafter in mid November, I earned my MCITP certification. The 70-452 exam builds upon the technical skills 

  Author:  DustinRyan     Date: 12/28/2010     Section: Blog

  tags : MCITP, Microsoft Certification Exam 70-452
• 
  SQL Rally 2012 Recap In Yo’ Face!

  This past Thursday and Friday I attended my first PASS SQL Rally event in Dallas, Texas. The week was full of some pretty amazing sessions presented by some even more amazing speakers. If you were a DBA looking for performance tuning tips or other ways to

  Author:  DustinRyan     Date: 5/14/2012     Section: Blog

  tags : community, SQLRally
• 
  The Best SQL Documentation Tool on the Market

  If you read my blog you know from time to time I will blog about an exceptional third party SQL tool. Previously I’ve blogged about Task Factory and BI xPress , two amazing SSIS development tools. Well this week I figured I would talk about a killer SQL d

  Author:  DustinRyan     Date: 7/11/2011     Section: Blog

  tags : Document SQL Server, Pragmatic Works, BI Documenter
• 
  SQL Saturday 85 Follow Up

  Last weekend I travelled down to SQL Saturday 85 in Orlando, FL. Like all of the other events that I’ve presented at, this event was great. The last I heard, there were nearly 300 attendees and it seemed that all were very pleased with the event. Ch

  Author:  briankmcdonald     Date: 10/2/2011     Section: Blog

  tags : Brian K McDonald, SQL Saturday 85 Follow Up, sqlbigeek
• 
  JSSUG Speaker Idol 2012

  The Jacksonville SQL Server User Group (JSSUG) has always encouraged new talent to be added to the pool of local speakers. That’s why tomorrow we will be hosting an annual event called Speaker Idol (I know the name isn’t very original don&rsqu

  Author:  DevinKnight     Date: 8/15/2012     Section: Blog

  tags : JSSUG, Speaker Idol, Speaking
• 
  Mobile Apps Testing Training Online

  There is worldwide tremendous growth in Mobile phone market and lots of companies launching and have launched their Mobile phone brands, this scenario has created a high demand of 'Mobile Phone Testing' resources in market and there is high resource crunc

  Author:  shilrot     Date: 11/30/2012     Section: Blog
• 
  New 2008 Microsoft BI Certifications Reviewed

  I am not about to get into a theoretical discussion of whether certifications will benefit you in your career. I am a firm believer that this follows the rule of “it depends”. However if you’re a professional in a field, whether plumbing or technology, ce

  Author:  AdamJorgensen     Date: 11/23/2009     Section: Blog

  tags : MS Certification, Testing, Certification
• 
  Introduction to SSRS 2008 and SQL Saturday 38

  In a few short weeks, another great event is coming to Jacksonville Florida at the UNF campus. There are many great speakers from around the SQL Server community that will be sure to increase your skill set. Here is a synopsis of my Introduction to Report

  Author:  briankmcdonald     Date: 4/26/2010     Section: Blog

  tags : Reporting Services, SSRS, SQL Saturday
• 
  2010 1st Quarter Goals Review

  I know it’s kind of late to write a review of my first quarter goals, since we are well into the second quart of 2010. However, I did state in my blog post earlier this year, 2010 1st Quarter Goals , that I would keep you all abreast of my progress. So, h

  Author:  PatrickLeBlanc     Date: 5/7/2010     Section: Blog

  tags : Goals, Patrick LeBlanc, Speaking
• 
  Third day of Foundation

  Well today has definitely been a fast paced day! Yet as fast moving as it was, I still learned so much! Especially that I need to think faster on my feet when being quizzed on certain ways to write a query OR what function gets me certain results. We play

  Author:  tiffswn     Date: 3/2/2011     Section: Blog

  tags : BIDS, datasets, stored procedures
• 
  Hey, >> PragmaticWorks authors / bloggers << -- a writing question for you

  Something that I admire about the Pragmatic Works employees that I read on here - you all seem to have very concise writing styles. Are you hired already having strong written communication skills? Do you have additional training for that? Do you "just" p

  Author:  KeithHyer     Date: 10/26/2011     Section: Forum

  tags : blogging, technical writing, writing
• 
  Report Builder Clickthrough Report differences between versions

  I doubt that mircosoft will revert back to the way it did something in previous versions. Microsoft's history does not lend it that way. As far as report building tool VS 2008 is very powerful and has many features. As those features improve and the techn

  Author:  ogonzalez     Date: 6/29/2011     Section: Forum
• 
  SSIS Certification Question

  In addition to that good stuff Dustin posted, you should also read this: http://sqlskills.com/BLOGS/PAUL/post/How-valuable-are-certifications.aspx . I assume you're going legit route but for those thinking of using exam dump or some other cheat method, yo

  Author:  sqlchicken     Date: 3/12/2012     Section: Forum
• 
  SSIS Transforms and Execution Trees

  Even if you have pretty good skills with a particular technology, there is always more to learn. Recently, I decided to take my SSIS skills to the next level and found out there is a wealth of information about tuning SSIS packages. Like anything else, ge

  Author:  KathiKellenberger     Date: 9/5/2012     Section: Blog
• 
  JULY 31: SQL Saturday 40

  SQL Saturday #40 is quickly approaching and many are gearing up for the trip down there to hear some awesome speakers on various subjects. Many are Business Intelligence related, but there are others available to for all of you true developers out there.

  Author:  briankmcdonald     Date: 7/20/2010     Section: Blog

  tags : SQL Event, SQL Saturday
• 
  MDX Puzzle #1

  MDX Puzzle #1 Recently, I embarked on a mission to become proficient at writing MDX queries. This is a challenge, as many of you may already know. MDX, though a query language, is very different from T-SQL as I quickly found out. Each week I will share wi

  Author:  PatrickLeBlanc     Date: 6/22/2010     Section: Blog

  tags : SSAS, MDX