This week I had the opportunity to join many of the U.S.-based Redgaters in Austin to talk about 2024 plans, hear from the product teams, and have some much-needed fellowship. One thing was particularly clear as I listened to various leaders and product managers – the customer drives everything we do. And I have to […]
2024-01-20
47 reads
I realize that this isn’t the last Database Weekly editorial of the year – that honor is reserved for Louis Davidson next week. 😊 However, as we approach the end of the year and various holiday celebrations, one of my favorite Christmas carols has been of particular encouragement to me recently. 2023 hasn’t gone exactly […]
2023-12-23
50 reads
I just had my one-year anniversary working for Redgate, and I must tell you, it’s been one of the best years of my professional career of 25 years. People aside (and there are a lot of really great people!), one of the reasons I’ve enjoyed this year so much is that Redgate understands and believes […]
2023-10-28
117 reads
Last Saturday, September 23, was the first day of Fall. Regardless of how much has happened and changed over the last three and a half years, time keeps marching forward. And yet, there's exciting familiarity every time I see November approaching because I know something special is about to happen for those of us in […]
2023-09-30
40 reads
A year ago, I started a monthly blogging event for the PostgreSQL community, inspired by T-SQL Tuesdays. I decided to call it PGSQL Phriday. (Time will tell if my insistence on trying to use a literation was a good idea or not.) Like the event for the SQL Server community, we ask someone to be […]
2023-09-09
82 reads
As I think about heading into the fall conference season (and seeing so many familiar faces!!), I realize that I'm going to be asking myself a set of familiar questions. Who am I? What skills do I need to improve on in the coming year? Who do I look up to in the community and […]
2023-09-02
64 reads
Last week I was able to attend THAT conference in Wisconsin Dells, Wisconsin. It was my first time in the great state of cheese, and the conference lived up to its reputation. As a developer focused conference (rather than a database conference), I didn't have much expectation that my session about automating database changes would […]
2023-08-05
1,820 reads
Two weeks ago, I had the opportunity to hear a keynote by Vik Fearing at Swiss PGDay 2023. He talked about Property Graphs and the Graph Query Language (not to be confused with GraphQL), a recent addition to the SQL:2023 standard. The discussion was mostly theoretical in nature because only Oracle has a current implementation […]
2023-07-08
92 reads
I had to come to the Redgate office in Cambridge this past week for a department onsite. As a result, my wife and I were able to come early for a few days adventuring together, the first trip we've taken by ourselves in nearly seven years. As a large family with six kids, it takes […]
2023-06-17
126 reads
Technology has always been a driving force in shaping our world, propelling us forward into new realms of innovation and progress. One of the most famous concepts in technology is Moore's Law, which suggests that the number of transistors on a microchip doubles approximately every two years, leading to exponential increases in computing power. In […]
2023-04-15
134 reads
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
i see this in the definition of a linked server on our wh sql...
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
Comments posted to this topic are about the item Stairway to Snowflake Level 5...
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers