Viewing 15 posts - 1 through 15 (of 189 total)
As someone who spent nearly a year with one support case dealing with missing records from dropped messages, the problem Service Broker is much bigger than education.
From a support perspective,...
October 19, 2014 at 7:28 am
Learn Powershell in a Month of Lunches by Don Jones and Jeffery Hicks is a good a book for the beginner. The book teaches a "think in Powershell" approach with...
July 28, 2013 at 6:39 am
An assumption around always keeping at least 20% free space on NTFS volumes.
May 2, 2013 at 5:31 am
I haven't looked at the code in a while, but I think you're right on the view.
January 25, 2013 at 4:54 pm
sqlfriends (1/24/2013)
When I schedule the job, because it will run using SQL agent service account, it won't work because it cannot login to other computers using that...
January 25, 2013 at 5:44 am
narayanaswamy (10/18/2012)
In SQL Server 2008 instance i have created spacedm database and created all objects tables,views,sp's
I've executed this command prompt .\write-dbspacetodb.ps1 'instancename' spacedm
I am getting below...
October 18, 2012 at 9:23 am
Not sure why SystemName would be null. Let's try forcing the systemname. Replace the existing Get-Vol function with this version:
#######################
function Get-Vol
{
param($computerName)
Get-WmiObject -computername...
October 4, 2012 at 8:20 am
Take a look at the $dt variable and make sure server_name property has a value.
October 3, 2012 at 5:21 pm
You got it. Sometimes I'll just recreate the table definition to match the column order in order to avoid mappings.
If you go that route you'll need to look at the...
August 17, 2012 at 12:59 pm
It could be done in VBScript or Perl. Here's an old Perl script. I can't find old VBScript:
#Perl Script based on
#http://www.sqlservercentral.com/scripts/contributions/1467.asp
use strict;
use Getopt::Std;
use Win32::OLE;
use Win32::OLE::Const("Microsoft SQLDMO");
my (%args, $args, $serverfile,...
September 28, 2011 at 9:47 am
As mentioned, Dump SQL Permissions relies on deprecated SQL-DMO library. I've release a 2000 and higher tool that uses SMO library here http://www.codeplex.com/SQLPSX. The project is more complex/featured...
June 14, 2011 at 5:06 pm
Its possible, but you would need to modify the report and have the dates default to calculated dates i.e. getdate() minus 30.
May 24, 2011 at 6:04 am
If you mean keep appending output to a CSV file, the export-csv cmdlet doesn't directly support this, however you could use the convertto-csv cmdlt and remove the header row as...
May 20, 2011 at 2:35 pm
PowerShell V2 (released in October 2009 after this article was written), does have try/catch. In addition you may want to look at your $erroractionpreference setting. The default setting continue, should...
March 7, 2011 at 4:28 pm
Phil Factor (3/7/2011)
Why do I need Powershell, when I can do all the stuff in GUI using SSIS? Powershell is another geek tool.
Well, it certainly is a geek tool in...
March 7, 2011 at 7:15 am
Viewing 15 posts - 1 through 15 (of 189 total)