Viewing 15 posts - 106 through 120 (of 972 total)
robert.sterbal 56890 (8/19/2015)
I do remote support, so I'm guessing I'll have to create the functions on each site.Can I run this from xp_cmdshell?
It depends on how you define "remote support"....
August 22, 2015 at 10:36 am
foreach($item in $sqlServer.JobServer.Jobs)
{
Write-Host $sqlserver $item.name $item.OwnerLoginName $item.IsEnabled $item.LastRunDate $item.LastRunOutcome
writeDiskInfo $ServiceFileName $sqlServer $item.name $item.OwnerLoginName
}
I don't see anywhere in this that you are writing to HTML, also what does...
August 20, 2015 at 11:18 am
If all you are going to do is pull the dataset from SQL Server and then populate a variable, to turn around and just email it to a user, why...
August 15, 2015 at 8:36 am
tl;dr: The missing events may still exist in memory but cannot be displayed because the size of the XML output is limited to 4 MB. Looks like it's the...
July 13, 2015 at 10:40 pm
Not prone to post videos but Jimmy Fallon of the Tonight Show did a hashtag bit on "How I quit" it contains some pretty funny ones.
June 26, 2015 at 6:54 pm
Sorry about that, had it written but slipped my mind to go back and add in the code. Completed and submitted.
June 23, 2015 at 8:28 pm
https://technet.microsoft.com/en-us/virtuallabs
The above URL list numerous virtual labs. The purpose of these virtual labs is not just for you to have a play environment, they are focused on specific features or...
June 17, 2015 at 6:52 am
Open "perfmon /sys" from the run prompt.
Add the
/Process (sqlservr.exe)/% privileged and /% processor
/Processor time for the same objects
It will at least tell you if it is SQL Server.
June 12, 2015 at 8:53 am
Just go download Sp_WhoIsActive and use it.
June 12, 2015 at 8:49 am
What do you want to do via the Control Panel?
Based on that just find the PowerShell cmdlet or module needed.
June 9, 2015 at 3:49 pm
... just keeping in mind that your own company representatives might also be scanning LinkedIn. Depending on how much discretion you want (or how worried are you if...
June 9, 2015 at 3:46 pm
If you are using SSMS to determine size, have you tried using a query to check if it reports the same size?
Have you issued DBCC UPDATEUSAGE (MyDatabase) WIT NO_INFOMSGS for...
June 9, 2015 at 3:32 pm
Recruiters that you previously connected to generally have no problem hearing from folks on inquiring about new opportunities. I have recruiters that keep in touch with me at least 1...
June 8, 2015 at 5:14 pm
I don't think being able to run commands across multiple servers or instances is the greatest feature....at all.
I use it to complete day-to-day tasks, troubleshooting (standalone and cluster), gathering metrics,...
May 24, 2015 at 5:25 pm
Microsoft certifications are no longer lifetime certifications, you will be required to "upgrade" every 2 or 3 years based on which certification you earn. The MCSE Data Platform for instance...
May 23, 2015 at 4:44 pm
Viewing 15 posts - 106 through 120 (of 972 total)