Forum Replies Created

Viewing 15 posts - 661 through 675 (of 1,932 total)

  • Reply To: Could there be some sort of permissions issues with EF and INFORMATION_SCHEMA?

    ScottPletcher wrote:

    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....

  • Reply To: Could there be some sort of permissions issues with EF and INFORMATION_SCHEMA?

    Michael L John wrote:

    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?

  • Reply To: 20 Years of Compare

    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...

  • Reply To: Growing and Changing

    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...

  • Reply To: Growing and Changing

    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...

  • Reply To: Don't Get On This Page

    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...

  • Reply To: The First Rule

    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...

  • Reply To: Demo Data for Everyone

    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...

  • Reply To: Upgrades are Hard

    I wasn't familiar with the term runbook, so I looked it up.

  • Reply To: The 2019 Home Lab

    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...

  • Reply To: Timing is Everything

    Eric M Russell wrote:

    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...

  • Reply To: Timing is Everything

    Steve Jones - SSC Editor wrote:

    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...

  • Reply To: Timing is Everything

    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...

  • Reply To: The Aware DBA

    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...

  • Reply To: The Aware DBA

    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...

Viewing 15 posts - 661 through 675 (of 1,932 total)