Subscribe to this blog
The Voice of the DBA
Archives: August 2018
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 developers.
One of the neat features of SQL Prompt is… Read more
0 comments, 152 reads
Posted in The Voice of the DBA on 17 August 2018
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 often, usually because I try to be effective, even… Read more
4 comments, 231 reads
Posted in The Voice of the DBA on 14 August 2018
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 is annoying to me. Here’s my old dashboard.
I… Read more
0 comments, 254 reads
Posted in The Voice of the DBA on 13 August 2018
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. I had a login (JoeDev) with no user mappings… Read more
2 comments, 202 reads
Posted in The Voice of the DBA on 9 August 2018
Flipping Sides in SQL Operations Studio
I’ve been starting to use SQL Operations Studio (SOS) a bit more. This is a small, lightweight editor that is based on Visual Studio Code. It’s fairly limited, though it’s still in preview. You can download it and give it a try.
One of the things that I like is… Read more
2 comments, 283 reads
Posted in The Voice of the DBA on 8 August 2018