Category: Tech and Learning

Quick Tip: Navigating to a UNC within SQLPS

Post author By Jen McCown
Post date May 6, 2013
Categories In Powershell, sqlserverpedia-syndication, SSC, Tech and Learning, Tips
1 Comment on Quick Tip: Navigating to a UNC within SQLPS

I’ve been getting a funky error with a new Powershell script, running as a SQL Agent job step. Let’s pretend for the moment that the script is simply “cd \\backup\SQL; dir *.bak” The error information returned by PowerShell is: ‘Cannot find path ‘\\backup\SQL’ because it does not exist. The script I have runs fine manually in Powershell, […]

Quick Tip: Where’s my SQL Server Job History?

Post author By Jen McCown
Post date April 29, 2013
Categories In Admin, sqlserverpedia-syndication, SSC, Tech and Learning, Tips
1 Comment on Quick Tip: Where’s my SQL Server Job History?

Here’s a quick mystery. You have a SQL Server with several jobs that appear to be running properly and on schedule, but many of them show no history. You look around, and there doesn’t seem to be a nightly job history purge (you’re looking for something with “sp_purge_jobhistory“). So where is the record of these […]

T-SQL Tuesday #40 Roundup: Files and Filegroups

Post author By Jen McCown
Post date March 18, 2013
Categories In Admin, Powershell, sqlserverpedia-syndication, SSC, Tech and Learning
2 Comments on T-SQL Tuesday #40 Roundup: Files and Filegroups

Good day all, and happy T-SQL Tuesday #40! Yes, this event has officially hit middle age now. I fully expect it’ll go get itself a fast car in the upcoming months. We had a great turnout for this month. “Files and Filegroups” is an open enough topic that I got exactly what I wanted: A nice variety […]