Did you know…you can change the default file encoding for new query on SSMS?
If you have been reading my last blog posts, you know that I’m currently working on a SQL code migration...
2018-06-05
486 reads
Cláudio Silva
Did you know...you can change the default file encoding for new query on SSMS?
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...
2018-06-05
166 reads
SQL Saturday #731 Athens 2018
In less than two weeks (on 16th June) it’s time for SQL Saturday Athens and I’m proud to announce that...
2018-06-04
301 reads
SQL Saturday #731 Athens 2018
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...
2018-06-04
7 reads
Learn, Evolve and Giving Back – TSQL Tuesday #102
This month’s T-SQL Tuesday is brought to us by Riley Major? (b | t) and he encourage us to talk about...
2018-05-08
360 reads
Learn, Evolve and Giving Back - TSQL Tuesday #102
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...
2018-05-08
9 reads
Using CAST() function with User-Defined Data Types…Did you know…
I’m converting some Firebird database code to T-SQL and I’m seeing a lot of code that doesn’t work in the...
2018-05-10 (first published: 2018-05-02)
2,906 reads
Using CAST() function with User-Defined Data Types...Did you know...
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...
2018-05-02
71 reads
dbachecks – Going parallel – Cut off your execution times
On one of the last clients I have worked, I have implemented dbachecks in order to get the state of...
2018-04-26
485 reads
dbachecks – Setting temporary configuration values
dbachecks has seen the light about two months ago. As I'm writing this blog post, the module counts with more...
2018-05-03 (first published: 2018-04-24)
1,974 reads
Blogs
SQL Server instance metadata inventory with PowerShell and SMO
By SQLPals
SQL Server instance metadata inventory with PowerShell and SMO The purpose...
5 SQL Tricks Worth Remembering Before You Close the Laptop
Disclosure: this post may contain links to books as an affiliate link. If you...
Claude Context Window
By Arun Sirpal
Every Claude conversation has a context window. It is the total amount of text...
Forums
Celebrating 30 years of PostgreSQL, A Thank you message
Comments posted to this topic are about the item Celebrating 30 years of PostgreSQL,...
provisioning sql server via VMware Cloud Foundation
Hello, has anyone here ever provisioned and actually used an MS SQL Server with...
No More Deadlocks
Comments posted to this topic are about the item No More Deadlocks
Question of the Day
No More Deadlocks
After detecting deadlocks in SQL Server 2025 and lowering the time threshold for detecting future issues, when does the Database Engine return to the 5s default interval?
See possible answers