Viewing 15 posts - 376 through 390 (of 1,999 total)
syslogins will tell you who can connect - if you go into each database and look at sysusers when you will see individual permissions
but a sysadmin will have ALL permissions...
February 3, 2020 at 11:42 am
how many records in the table ?
February 3, 2020 at 11:33 am
if i'm reading this correctly - just turn it into an inner join
and for code clarity move the disabledflag=0 into the where clause... it has no place in the join
February 3, 2020 at 11:30 am
MVDBA (Mike Vessey) wrote:I'm not sure I agree on this one - cooperation leads to learning. rather than fight them we can mentor them
^^^^^^^^^^^^^^^^
YES!!!!
BEÂ SQL YODA - "hmmmm, set based thinking...
February 3, 2020 at 11:14 am
There's a real skill in finding a way to way "I'm not saying you are wrong, I'm merely offering you an opportunity to be even more right"!
at a "previous...
February 3, 2020 at 11:01 am
I really hate raining on your lovely script, but this has been done 1000 or more times before
personally I use the Redgate tools (compression, encryption etc) but you might want...
February 3, 2020 at 10:47 am
SSRS - ouch - painfully slow
get your web server running some basic MVC code and stick a data grid on screen for failed job history 🙂
if as a DBA...
February 3, 2020 at 9:38 am
SSRS - ouch - painfully slow
get your web server running some basic MVC code and stick a data grid on screen for failed job history 🙂
February 3, 2020 at 9:35 am
Jack's just kinda boring, that's all. It's not "bad", like undrinkable or anything, but it's not interesting either.
Some of the special Jacks are much better. I don't...
February 3, 2020 at 9:31 am
MVDBA,
This part of your post really cleared things up for me about what exactly an instance is. Sounds like each time you install SSMS, that installation is called an...
February 3, 2020 at 9:25 am
I don't think it's as much an attitude issue as it is a domain knowledge issue. I wouldn't try to tell .Net developers how to write C# code,...
February 3, 2020 at 9:05 am
Jack's just kinda boring, that's all. It's not "bad", like undrinkable or anything, but it's not interesting either.
Some of the special Jacks are much better. I don't think...
January 31, 2020 at 4:15 pm
"if it's 1000 servers" -> No, it's only round about 300 servers.
"so script up a job and deploy it everywhere that sends you all the info you need (backups...
January 31, 2020 at 4:08 pm
MVDBA (Mike Vessey) wrote:JEFF Do NOT go all SSIS on me 🙂 we all know it's Bulk insert with a formatfile or openrowset
Jeff's blood pressure just went up a notch 🙂
wait...
January 31, 2020 at 3:56 pm
Viewing 15 posts - 376 through 390 (of 1,999 total)