SQL, PowerShell, and more from a SQL Server DBA
On 29th September we will have SQL Saturday Porto and I’m proud to announce that I will be speaking! I will be speaking about dbachecks PowerShell module - dbachecks - Checking SQL Server environments with PowerShell. The event will be held at ISEP, Rua Dr. António Bernardino de Almeida, 431, 4249-015 Porto, Portugal and you … Continue reading I will be speaking @ SQLSaturday #795 Porto
Almost all the applications we use have a lot of options. And, sometimes we even stumble across them by accident. Who's ever heard something like "Normal user don't even use 5% of Excel capabilities!"? Other options, we know they exist but because the default value it’s ok (so far) we tend to forget it. It … Continue reading Don’t cutoff yourself with dates in T-SQL – Did you know…
I'm working on a project where I need to convert Firebird SQL code into T-SQL code. No schema, just the modules. There are more than 1000 objects between stored procedures, views, triggers, user-defined data types, etc. First - the pain... While checking the Firebird reference manuals I saw a lot of different concepts (Selectable Stored … Continue reading Leveraging on SQL Server metadata
Starting on 19th of July and during 3 days the Tuga IT 2018 Summer Edition will be happening in Lisbon! This edition will have: 4 full-day workshops 38 breakout sessions (1 hour) 5 deep dive sessions (2 hours) That is over 72 hours of content delivered by 44 awesome speakers, many of them recognized industry … Continue reading I will be speaking @ Tuga IT 2018
If you have been reading my last blog posts, you know that I’m currently working on a SQL code migration from Firebird to SQL Server. The client provided the scripts with all modules (Stored Procedures, functions, etc) and the steps I'm following (roughly speaking) for converting are: Open new query window Copy and paste de … Continue reading Did you know…you can change the default file encoding for new query on SSMS?
In less than two weeks (on 16th June) it's time for SQL Saturday Athens and I'm proud to announce that I will be speaking! This will be my first SQL Saturday ever both as speaker and attendee outside Portugal so I'm especially thrilled and excited to be part of it! I will be presenting my … Continue reading SQL Saturday #731 Athens 2018
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 … Continue reading Learn, Evolve and Giving Back – TSQL Tuesday #102
I'm converting some Firebird database code to T-SQL and I'm seeing a lot of code that doesn't work in the same way that SQL Server. No surprise - I already expected that but for those that still say that "all engines/databases are equal"..."is SQL right?" here is another proof that is not true. On Firebird … Continue reading Using CAST() function with User-Defined Data Types…Did you know…
On one of the last clients I have worked, I have implemented dbachecks in order to get the state of art and know how cool or bad the environments are before start knocking down the bad practices. This client has seven different environments with more than 100 instances and more than 2000 databases. Serial execution … Continue reading dbachecks – Going parallel – Cut off your execution times
dbachecks has seen the light about two months ago. As I'm writing this blog post, the module counts with more than 2600 downloads just from the PowerShell gallery. The module has about 110 configurable checks that make our live easier! Today I will write about an option that I think users still do not realize … Continue reading dbachecks – Setting temporary configuration values
