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"....
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
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...
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
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...
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
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...
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
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.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
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.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
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...
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
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.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
June 12, 2015 at 8:53 am
Just go download Sp_WhoIsActive and use it.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
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.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
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...
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
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...
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
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...
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
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,...
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
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...
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
May 23, 2015 at 4:44 pm
Viewing 15 posts - 106 through 120 (of 972 total)