Search Results: powershell

• 
  What is difference between Xp_cmdshell and Power shell

  Technically speaking, you can do almost everything you can do in command line in PowerShell. With PowerShell, you don't need to enable it as a feature on the instance like you do with xp_cmdshell. Check out this post from Jack Corbett for an example of ho

  Author:  sqlchicken     Date: 10/29/2012     Section: Forum

  tags : PowerShell, scripting, sqlps
• 
  Upcoming Free Education from Pragmatic Works

  It's been a great month of free education from Pragmatic Works. The recordings from the previous ones are now posted and I have one on Tuesday on SQL Server Data Warehousing Fast Tracks. Check out all the information below: June 22, 2010 View Recording Po

  Author:  BrianKnight     Date: 6/27/2010     Section: Blog

  tags : performance point, powershell, sharepoint, sql server fast track, ssis, webinar
• 
  SQL Saturday Tampa 2011- The Aftermath

  Well it was a great SQL Saturday in Tampa and we all learned and networked alot. In my session with Aaron Nelson "SQL Smackdown" we compared powershell and SSIS. You can download a copy of the packages here . These packages are SQL 2008 In Iron Chef Devin

  Author:  MikeDavis     Date: 1/18/2011     Section: Blog

  tags : Iron Chef, Powershell, SQL Smackdown, SSIS, SQL Saturday
• 
  Check Mount Points Free Space with PowerShell

  Those who know me will know that this post is a little out of the ordinary... I am posting about PowerShell. I have done one previously about Backing up and restoring site collection in SharePoint , so believe me I will admit that it has its place. Well I

  Author:  BradSchacht     Date: 8/12/2011     Section: Blog

  tags : powershell
• 
  MDS 2012: Part 3–Installing Master Data Services

  In the first two parts of this blog series we spent time talking about master data, master data management (MDM) and the architectural patterns that are prevalent in MDM solutions. In this post we will start narrowing our focus to Master Data Services (MD

  Author:  cprice1979     Date: 4/23/2012     Section: Blog

  tags : Master Data management, Master Data Services, MDM, MDS, Tips and tricks
• 
  iPowerShell

  As a consultant I travel a lot, and am usually on my small laptop with it?s 13 inch screen. A great size for travel, but a bit small on occasion. Doing PowerShell I often want to look things up, but it?s a pain having to jump back and forth between my edi

  Author:  arcanecode     Date: 4/4/2012     Section: Blog
• 
  Powershell for SQL Server : An Introduction -- Free webinar

  A free webinar is being organised by Idera on Powershell for SQL Server. Here is an excerpt from the site. In this session, Microsoft MVP Aaron Nelson will discuss what PowerShell is and demonstrate how and why DBAs should use it. Aaron will step you thro

  Author:  indupriya     Date: 8/3/2011     Section: Blog

  tags : windows powershell webinar
• 
  PowerShell Help Community Edition

  Last week when I blogged about iPowerShell from Sapien, I mentioned they had a few free community tools. One of those is PowerShell Help Community Edition. As you can see, it provides a simple, easy to you way to navigate help in PowerShell. I find this e

  Author:  arcanecode     Date: 4/10/2012     Section: Blog
• 
  PowerShell to reclusively delete .bak and .txt files older than 5 days.

  I ran across a server that has backups being generated and it doesn’t have any maintenance plans created on the server itself. The backups are being created from some external source. The disk drives are being filled up as there is nothing that is d

  Author:  sqlscottgleason     Date: 6/12/2012     Section: Blog

  tags : Backups, powershell
• 
  Backup and Restore SharePoint 2010 Site Collection with PowerShell

  One of the most annoying processes with SharePoint is backing up a site collection. There is a build in tool that you can use but it is kinda clunky and can take a while to perform the backup. I used it once and was not impressed. PowerShell provides a qu

  Author:  BradSchacht     Date: 7/13/2011     Section: Blog
• 
  PowerShell Training Resources

  OK, I admit it. I love PowerShell! It?s the way to go when you want to do automation. Not only that, it has the ability to hook into all aspects of the Microsoft tool stack. Not just SQL Server, but SharePoint, Exchange, Windows Server, and more. So here

  Author:  arcanecode     Date: 4/2/2012     Section: Blog
• 
  Deploying SSRS Solutions (DataSources,DataSets,Reports,etc)

  Hi All I am facing a problem in deploying SSRS Solutions having working in a DEV environment we work constantly and create new things and promote certain things to QA and once UAT is done in QA its promoted to PROD The problem I am facing is how to deploy

  Author:  Toufeeq     Date: 11/22/2012     Section: Forum

  tags : deployment, MigrationTool, RSscripter, tools
• 
  Using Data Mining models inside applications

  Hi Mark Sorry no one has answered your question. The topic of querying Microsoft Data Mining models is done through ADOMD.NET. I provided a few PowerShell examples on my blog, and I have a recurring ADOMD.NET tag: http://www.marktab.net/datamining/index.p

  Author:  marktab     Date: 1/24/2011     Section: Forum

  tags : ADOMD.NET, PowerShell, StreamInsight
• 
  SQL Smackdown at SQL Saturday Tampa 2011

  Come see two Database Powerhouses go Head to Head in an ETL challenge. Mike Davis and Aaron Nelson Square off in the SQL Smackdown. Mike Davis will use SSIS, Aaron Nelson will use Powershell Both men will show what pros and cons of each method in ETL Who

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

  tags : powershell, SSIS
• 
  View Flat File Contents Using PowerShell

  We have all been there; you need to take a look at the data inside a file. Sure you can open it in Notepad if it is under 20-30MB, bigger than that and you may run into problems depending on the computer. Sometime WordPad will handle the larger files, aga

  Author:  BradSchacht     Date: 8/21/2012     Section: Blog
• 
  AlwaysOn: Configuring Secondary Read-Only Access

  Now that you have AlwaysOn configured and your first Availability Group (AG) created, it’s time to start leveraging those secondary replicas. The first step is to set the connection access for the primary and secondary role, if you haven’t alr

  Author:  PatrickLeBlanc     Date: 2/8/2012     Section: Blog

  tags : AlwaysOn, High Avilability
• 
  On connection fail go to next

  I haven't done this is about a year and a half - expect "sketchiness" on the details at best. I would recommend that you take a look at the WMI Data reader task. If your servers allow WMI access ( powershell-type stuff ), you can query the server(s) to se

  Author:  KeithHyer     Date: 4/5/2013     Section: Forum

  tags : forceexecutionresult, ssis, WMI reader task
• 
  Deploying SSRS Solutions (DataSources,DataSets,Reports,etc)

  Thanks for the reply I have downloaded the BiXpress tool however I get errors when trying to move DAtasets between folders. Also it does not save the Data Connections to the servers. I have logged a support call for these issues. I know there is a way to

  Author:  Toufeeq     Date: 11/28/2012     Section: Forum
• 
  SQL Rally, Here I Come!

  On May 10th and 11th, all SQL hell is breaking loose in Dallas, Texas at SQL Rally ! It's sure to be an incredible event, with tons of experts presenting on an amazingly wide range of SQL-y topics. There will be everything from PowerShell to development t

  Author:  DustinRyan     Date: 2/29/2012     Section: Blog

  tags : PASS, SQLRally
• 
  SQLRally Overdrive: Birds of a Feather Discussions Event

  Just wanted to post a quick note/invitation to everyone to come join us on Thursday, May 12th from 5:45-7:00 for the SQLRally Overdrive: Birds of a Feather Discussions event . We'll have several tables, each with a dedicated expert in the field hosting co

  Author:  sqlchicken     Date: 5/11/2011     Section: Blog

  tags : events, sqlrally, sqlpass
• 
  SQL Server Denali CTP3: Policy-Based Management

  Whether you know it or not, Policy-Based Management is an integral part of the new release of SQL Server "Denali". Did you know that the HADR feature actually leverages PBM for checks? Yup, that's right folks. If you're an administrator and you're NOT usi

  Author:  sqlchicken     Date: 7/13/2011     Section: Blog

  tags : administration, policy-based management, pbm
• 
  SQL Lunch Returns: MVP Max Trinidad (Let’s Talk about SQL Powershell)

  I know you have missed the crazy antics, but after taking a short hiatus from my community contributions, the SQL Lunch is back. #60-Let’s Talk about SQL Powershell Speaker: Max Trinidad Add To Outlook: Add To Calendar Live Meeting URL: https://www.liveme

  Author:  PatrickLeBlanc     Date: 5/20/2011     Section: Blog
• 
  SharePoint 2010 Your Backup Is From A Different Version Of Microsoft SharePoint Foundation

  Restoring a SharePoint site collection can be a pretty easy task. If your interested in how to do that check this blog ( Backup and Restore SharePoint 2010 Site Collection With PowerShell ) where I explain the process. Unfortunately this is not always a f

  Author:  BradSchacht     Date: 1/4/2012     Section: Blog
• 
  Upcoming SQL Lunch Webcasts

  First, I would like to thank all that have attended and supported the SQL Lunch during our first year. We are continuing on and have some great Lunches scheduled for May and June. In May I will be presenting Configuring, Deploying and Scheduling SSIS Pack

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

  tags : Speaking, SQL Lunch
• 
  The local farm is not accessible. Cmdlets with FeatureDependencyId are not registered.

  You may fire up the SharePoint 2010 Management Shell (which allows you to run PowerShell commands to do cool SharePoint stuff, very technical… I know) and get the following error: The local farm is not accessible. Cmdlets with FeatureDependencyId a

  Author:  BradSchacht     Date: 1/5/2012     Section: Blog