Monthly Archives: August 2018

The Best Days

I recently asked about the worst days in your career, so today let’s turn it around. What are the best days of your career? If you can give us a list of 2 or 3 days, projects, accomplishments, etc., it might … Continue reading

Posted in Editorial | Tagged | 1 Comment

Format a Partial Script with #SQLPrompt

SQL Prompt is amazing and it’s my favorite tool. It’s actually what many people want first from Redgate because it makes coding much easier. One of the most used features is the reformat feature (CTRL+K,Y), since formatting really matters to … Continue reading

Posted in Blog | Tagged , , | Leave a comment

Getting the Role Permissions–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. If you are wondering what permissions a role has, and don’t want to spend time searching and digging through … Continue reading

Posted in Blog | Tagged , , | Leave a comment

What Data is Really Needed?

The GDPR took effect in May of this year, at least with regards to enforcement. A few days after the May 25 date, a German court ruled against ICANN, the company that registers domain names on the Internet and manages … Continue reading

Posted in Editorial | Tagged , | Leave a comment

Maintain Your Trustworthiness

Many of us that are DBAs and/or sysadmins find ourselves with privileged access to many systems. We can often read the data that’s stored in these systems, whether that’s a relational database, a NoSQL store, or even a mail system. … Continue reading

Posted in Editorial | Tagged | 2 Comments

The Master of the Schema

“The database … should be the master of the schema”. It’s not often I see an application developer talk about the importance of the database, or at least that the database (and data) are very important to the success of … Continue reading

Posted in Editorial | Tagged , | Leave a comment

Another Brick in the Wall–T-SQL Tuesday #105

It’s that time again, and this month we have a good topic from Wayne Sheffield. We’re asked about getting stuck, about being blocked, about encountering a brick wall. I have to say that I don’t think I encounter these very … Continue reading

Posted in Blog | Tagged , | 4 Comments

The New SQL Provision Dashboard

As much as I liked the ability to quickly and easily build development and test databases with SQL Provision, I thought the dashboard of cloned databases was hideous. It left a lot to be desired, and frankly, the dark theme … Continue reading

Posted in Blog | Tagged , , | Leave a comment

The Worst Day

I challenged people to write about their daily work a few weeks ago. I haven’t see a lot of posts, but I am still hopeful some of you will document your day, as Iris Classon has done a few times. It’s not that I expect … Continue reading

Posted in Editorial | Tagged | 1 Comment

Granting CONTROL on a database–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I wanted to grant a login the CONTROL permission on a database. This wasn’t a simple as I expected. … Continue reading

Posted in Blog | Tagged , | 2 Comments