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.

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. “Why?” - You may ask. From my experience triggers are objects that we “tend” to forget are there, and only when we hit a problem and, sometimes, after digging into the problem we end by saying something like

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.

Continue reading

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: 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.

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?

Continue reading

Author's picture

Cláudio Silva

Data Platform Architect and PowerShell lover.

Data Platform Architect

Portugal