Viewing 15 posts - 1 through 15 (of 30 total)
For some reason, I couldn't use the set-azkeyvaultpolicy the way your example did. specifically, I grabbed the identity thus:
$identity = Get-AzSqlServer -ServerName myservernamehere
but I had to use -ObjectId instead of...
July 21, 2022 at 4:38 pm
Putting this here since this was the thread I came upon while trying to find a problem.
We migrated from SQL Server 2012 to SQL Server 2017, and that server's primary...
June 22, 2022 at 2:52 pm
March 27, 2018 at 1:26 pm
I had this happen this morning for what looks like no reason (in the past it was due to database backups causing issues. Fortunately, I have Event Notifications on our...
February 13, 2018 at 7:36 am
Not really - I could just use xp_fixeddrives for that. What I'm trying to do is see what else I can do with WMI/WQL alerting. I've already dug through...
August 4, 2015 at 2:48 pm
Anybody ever figure this out? I'm stuck where I have the alert firing, but I can't find the right token for WMI to expose the DeviceID from TargetInstance. I...
August 3, 2015 at 5:27 pm
Okay, speaking with Eric offline (much appreciated!), I got it compiled and working.
1) there are a couple of typos in the script. Syx.Functions = Sys.Functions and UserDefindedFunctions = UserDefinedFunctions
2)...
May 16, 2014 at 8:49 am
Howdy. Interesting article, but I'm a .Net newbie. I'd been doing my own dynamic pivot, but Jeff's right - it's a pain to do.
I had a...
May 13, 2014 at 2:45 pm
Steve, I just came across an old article by Jonathon Kehayias about Event Notifications (http://www.sqlservercentral.com/articles/Event+Notifications/68831/). IMHO, his seems to cover pretty much everything mine does, and a...
March 10, 2014 at 3:38 pm
Article submitted! Please let me know if it's too short. I can (and do) go on for hours about this, but I figured a basic tryout would be...
March 4, 2014 at 9:33 pm
And since it's 2:30 in the morning and I'm waiting for some UPDATEs to finish - it was a pleasure meeting you in Albuquerque at SQL Saturday. I was...
March 4, 2014 at 1:30 am
I jokingly came over to look, knowing my favorite topic wouldn't be on there. Color me stunned, and color me interested in writing an article!
Let me go through and...
March 4, 2014 at 12:56 am
Paul, how long have you had this for? This looks like exactly what I'm looking for, but curious how well it's been foolproofed - since I can be a...
July 10, 2013 at 11:49 am
Howdy, David. Another question for you: how are you doing the DDL Snapshot? My guess is SMO, but wanted to be sure. Thanks.
October 14, 2012 at 1:50 pm
Viewing 15 posts - 1 through 15 (of 30 total)