0

Monday Coffee 2016-11-14

Communication in the workplace.

With the release of Microsoft Teams we now have a dazzlingly array of software designed to increase communication between workers and departments in the workplace. There’s the old staple that is email, instant messengers such as Skype for Business and now relatively new systems such as Teams, Yammer or Slack.

I have to admit that I’m kinda on the Slack fanboy bandwagon. I find it a much better tool than Skype for Business mainly due to the fact that I find it less intrusive in my daily work. When someone sends me a message on Skype I find that I’m obliged to respond immediately whereas with Slack I feel I have the option to finish what I’m doing and then get back to whoever messaged me. Anyone else feel like that or am I on my own in that way of thinking?

Another feature that’s helped me out a lot is the ability to send messages to an entire channel. Before I would send an email to a certain department’s group address and wait for a response but now I can post in a channel and (hopefully) someone will get back to me.

Slack’s big problem will be Teams. A lot of companies will already be paying for Office 365 which Teams will come with, so why pay extra for Slack? I’ve had a brief look at Teams and the functionality that’s there is pretty much exactly the same as Slack so I think it’s a no-brainer that companies will prefer using Teams. Or…will they though? Slack’s user interface is a lot better than Teams (what’s with the purple?) and Slack also has the ability for me to be logged into different sites in the same app.

For instance, I have my work’s Slack but I’m also logged into the SQL Server & Irish Tech communities. This has given me access to a huge online tech presence who I can talk to and draw resources from. So I don’t really want to give that up, I guess in the end I’ll end up having email, Slack, Skype for Business and Teams open whilst working. Ah well…could be worse.

0

Friday Reading 2016-11-11

It’s Friday so no releases to Production today (ha!) which means in-between my code reviews, server audits and other tasks I’ll be reading the following…

Speaking? You? Go on.
Rob Sewell talks about why you should be presenting and gives his tips.

Public Speaking: A Primer
Paul Randal with a pretty detailed post on tips for presenting.

Build And Run Your First Docker Windows Server Container
Containers are a hot topic at the moment, this article guides you through creating a docker Windows container on Windows 10 and Windows Server 2016.

Edge running in a VM
Anyone out there actually using Edge? Well, here’s some (oldish) news.

Sega Genesis returns to production — in Brazil
The Sega Genesis (or Mega Drive for us Brits) has apparently been resurrected in Brazil! Bit of a blast from the past.

That’s it from me, have a good weekend.

0

Drag & Drop Table & Column Names in SSMS

I was working with a developer the other day and he was typing out each table name and all the column names he needed when working in Management Studio. He didn’t know that you can drag a table or column from object explorer into the query window and thinking about it, I didn’t know for ages when I first started with SQL.

It seems obvious but if you haven’t seen it before then how would you know that you could do that? Maybe you’d work it out but I thought I’d write this quick post to show anyone out there who wasn’t aware of this. What’s also really cool is that you can drag the columns folder from object explorer into the query window and it’ll drop all the columns from the table. So much better than typing out all the column names (even with intellisense) or using SELECT *

gif4

2

Query shortcuts in SQL Server Management Studio

Tired of typing out the same queries day after day? Well query shortcuts in SSMS are for you!

Following on from my last post Changing connection colours in SSMS I thought I’d write another quick about this cool but also often unused feature in SSMS.

These shortcuts allow you to run pre-determined queries by assigning a hot key within SSMS. To do this in SSMS go to Tools > Options > Environment > Keyboard

queryshortcuts2

From there you can set the query to the hot key you want to use. Nice and easy!

In nearly all of the instances of SQL Server that I look after, I’ve installed Adam Machanic’s excellent sp_whoisactive. By adding the above shortcut into SSMS I can run it quickly and easily in any instance that I’ve connected to. It’s really handy and I’d definitely recommend you install it and set a query shortcut up for it.

Thanks for reading!

4

Changing connection colours in SQL Server Management Studio

A simple but effective setting in SQL Server Management Studio is using custom colours to identify which server you are about to execute a query on. It’s simple to setup but not everyone who uses SSMS is aware of it so I thought I’d quickly run through the steps here.

Open up SSMS, go to View > Registered Servers

regservers

So I’ve got different groups for Staging, Production, Corporate etc. If you haven’t got these setup it’s pretty easy. Right click on Local Server Groups and pick New Server Group. Enter in a group new and hit OK. Then right click on your new group and select New Server Registration:-

newregserver

Fill out the details and then hit the top tab Connection Properties:-

connectionproperties

The custom colour option will allow you to set whatever colour you want when you use that registered server to open a T-SQL window. Typically I use red for production, orange for staging, blue for development and, green for my local instances.

It’s a simple enough setting but it’s stopped my from making god knows how many mistakes!