Viewing 15 posts - 661 through 675 (of 1,932 total)
It's best to stop using INFORMATION_SCHEMA views. They can contain inaccuracies (on ownership) and are incomplete now.
Stick to sys.columns and the other MS standard views.
I'm not familiar with sys.columns....
September 5, 2019 at 6:00 pm
The user needs "view definition" permissions on the database
Do we view the user "view definitions" permissions on just the view, or the whole database?
September 5, 2019 at 5:58 pm
20 years! WOW! I have had an opportunity to play around with SQL Compare as a trial product, and did like it very much. As a developer I'm not one...
September 4, 2019 at 1:39 pm
I hear ya, Ray. I also struggle with modifying other people's code, unless they've asked me to or I've been assigned to do it. Anyway, one of my coworkers absolutely...
August 26, 2019 at 7:44 pm
Boy, I see this a lot. In fact, I think I see IT and developer people relying solely on their experience much more often than trying anything new. It's very...
August 26, 2019 at 2:44 pm
I appreciate this post/article, Steve. You've been talking about GDPR for over a year now. I consider it appropriate and hope that something like it comes to the US, where...
August 22, 2019 at 2:57 pm
I agree with you, Steve. Unfortunately, I also see some systems which make changing data extremely hard. I've spoken about it here before. I'm pleased to say that it has...
August 21, 2019 at 2:15 pm
Very interesting article. I never thought of automating the production of sample or test data. We never made sample/test data at my old job. In my current job, the creation...
August 14, 2019 at 4:00 pm
I wasn't familiar with the term runbook, so I looked it up.
August 12, 2019 at 3:00 pm
At home I've got an old desktop, with two 1-TB HD's. It is what I do much of my training on. This is at least 5 years old and is...
August 9, 2019 at 2:38 pm
Most phishing scams are automated and impersonal, while other scams hit closer to home. For example, last year my grandmother got a call from a guy pretending to be...
August 9, 2019 at 1:10 am
I get some amazingly creative ones from HR services, though luckily none have hit the right one we use at Redgate. I also get a few great ones that...
August 9, 2019 at 1:08 am
The large state government agency I work for is often under phishing attacks as well as other penetration attacks. We've got a good security team (kudos to them!) who work...
August 8, 2019 at 3:19 pm
Those are good points, Steve. And perhaps I'm being too harsh on the network folks. With networking a major portion of it is out of our control. We use CenturyLink...
August 5, 2019 at 3:39 pm
Great topic, Steve. I'm with you, I'd had to develop a monitoring system, because I now know the system being monitored would likely change. Who wants to constantly upgrading your...
August 5, 2019 at 2:59 pm
Viewing 15 posts - 661 through 675 (of 1,932 total)