This month’s (#127) T-SQL Tuesday is brought by B | T ) and he asked about Non SQL Tips and tricks.

As a Windows user I know there are lots of shortcuts and small hacks, that I love, which make my life much easier! Here is my small contribution:

Windows tips & tricks and shortcuts

• WIN + X -> to access a lot of management stuff in a quick way
• WIN + V -> If you looking for a clipboard manager (keep multiple entries) since Windows 10 (build 1809) we can have it natively. However, I keep using ClipX .
• WIN + [0-9] -> The number is linked to the position of the apps on your taskbar.
• WIN + . -> Big fan of emoticons? Select one from this list
• Open PowerShell (or cmd) console from a windows explorer window. How many times have you wanted to jump to the PowerShell console already on a specific folder that you have already open on the windows explorer? Just type on the address bar “PowerShell” and a new PowerShell session will open right on that location.

Open “Add or Remove programs”

A way to open the “Add or Remove programs” menu quicker, you can SHIFT + DEL on the shortcut (example: Docker Desktop) on desktop and the prompt popup will have there a link to this option.

Continue reading

This month’s T-SQL Tuesday is brought by Steve Jones ( b | t ) and he wants to know if triggers causes headaches or happiness to us.

This is the 106nd edition of TSQL2sDay - an Adam Machanic ( b | t ) brainchild.

  Triggers are those kind of database objects that sometimes are the best bet but most of the times they will strike back.

Continue reading

This month’s T-SQL Tuesday is brought to us by Riley Major‏ ( b | t ) and he encourage us to talk about how we are helping by giving back to our community.

This is the 102nd edition of TSQL2sDay - an Adam Machanic’s ( b | t ) brainchild.

“Let’s go back for a moment:”

I have heard about SQL Server the first time back in 2003 when I was on the high school and I had a database class. Was a slow start and, at that moment I haven’t imagined that would follow that path professionally.

Continue reading

This month’s T-SQL Tuesday is brought to us by Ewald Cress ( blog  |  twitter ) and is all about “folks who have made a difference” in our careers.

Thank you, Ewald! This is a great topic!

Here is my short list

Paulo Silva ( in )

He was my first boss in the IT world! I was his apprentice when I started my internship. He was going to move to a manager position and I  had to continue his work. He was responsible for the beginning of my career with SQL Server 2000 and VB6.

Continue reading

This month’s T-SQL Tuesday is brought to us by my good friend Rob Sewell ( b | t ). Together “Let’s get all Posh – What are you going to automate today?”

I have written some blog posts on how I use PowerShell to automate mundane tasks or some other more complex scenarios like:   Find and fix SQL Server databases with empty owner property using dbatools PowerShell module  or Have you backed up your SQL Logins today?   or even using ReportingServicesTools module for deploy reports - SSRS Report Deployment Made Easy – 700 times Faster .

Continue reading