Monthly Archives: April 2018

Learning Goals–April Update

Posted on April 30, 2018 by

Here is the update: I did better. Extended Events I did a little more multi-tasking this month, ensuring that if I rode the stationary bike for exercise, I had my tablet and watched some Pluralsight or read some content. Here … Continue reading →

Posted in Blog | Tagged , , | 2 Comments

Replication Gets Some Love

Posted on April 30, 2018 by

I really like replication in SQL Server. At least, I like it as a concept. It solves some hard problems and lets me move data around in a way that can handle larger loads, reduce queries to OLTP servers, and … Continue reading →

Posted in Editorial | Tagged

Taking Shortcuts

Posted on April 28, 2018 by

Many of us work in situations where we feel pressure to get work done at a pace that’s faster than we might like to move. In some sense, this is the nature of life, where customers and clients always want … Continue reading →

Posted in Editorial | Tagged , ,

The CDO

Posted on April 27, 2018 by

One of the cornerstones of GDPR compliance is appointing someone as a data protection officer for your organization. This person is responsible for ensuring that your systems and data are safe and protected, and presumably, complying with the various articles … Continue reading →

Posted in Editorial | Tagged

Securing Test and Dev Environments at the SQL Privacy Summit

Posted on April 26, 2018 by

Redgate Software is putting on a one day SQL Privacy  Summit on May 18 in London at the Grange Tower Bridge. This is a chance to see how you can ensure compliance with the GDPR while keeping up the modern … Continue reading →

Posted in Blog | Tagged , ,

Cloud Snake Oil

Posted on April 24, 2018 by

I’m sure that those of you reading this have a variety of opinions about the “cloud”. Actually, I’d guess that many of us have different definitions of what the cloud actually means. That’s fine, since it’s really an amorphous, marketing … Continue reading →

Posted in Editorial | Tagged

Watching the Sands of Suggestion in #SQLPrompt

Posted on April 24, 2018 by

I enjoy themes, and when I ran across the SQL Prompt Treasure Island, I had to take a few minutes and go through it. I wrote about Code Snippet Code recently, and this post continues to move across the map. … Continue reading →

Posted in Blog | Tagged , , | 3 Comments

New IT Departments

Posted on April 23, 2018 by

I had a friend that used to run an Exchange system. Actually, he was part of a team of four that managed a 50,000+ mailbox system for a very large company. In 2000 or 2001, he told me that his … Continue reading →

Posted in Editorial | Tagged

Checking Tempdb with dbatools

Posted on April 20, 2018 by

I really like the dbatools project. This is a series of PowerShell cmdlets that are built by the community and incredibly useful for migrations between SQL Servers, but also for various administrative actions. I have a short series on these … Continue reading →

Posted in Blog | Tagged , , ,

Keep It All

Posted on April 20, 2018 by

I love this quote, though I’m not sure it’s accurate. From The Future of Data Storage, the piece states: “What’s the most expensive thing you can do with a piece of data? Throw it out.” That’s from a storage vendor, and … Continue reading →

Posted in Editorial | Tagged