One of the things that I’ve gotten used to with Snowflake is that it’s just different. Well, today, I’ve got some goodness for y’all – and in a place that you really wouldn’t expect – the INSERT statement. For most of your everyday use, it works exactly as you’d expect. As some would say, it…… Continue reading Insert differently with Snowflake and SQL Server
Author: Kevin
Somehow I like Snowflake more and more
It’s no secret that I like Snowflake. When I say like, I mean that I like some of the different ways that I can find data within other data. For example, see this post from last time. This time, I want to show why one of the many operators are used over another and what…… Continue reading Somehow I like Snowflake more and more
I like Snowflake More and More
With SQL Server, you’ll find that, quite often, when dealing with strings, you’re almost stuck using the like operator to check if items are “like” another string. I don’t know how many times I’ve done something like the following: SELECT * FROM dbo.TableName WHERE Field LIKE ‘%Name%’; Hopefully, many of you get the gist of…… Continue reading I like Snowflake More and More
SELECT Something New in Snowflake
Sometimes you think you have something down. With years of SQL Server experience, you would think you’d know at least the basics of the SELECT statement no matter the relational database. Well, my friends, you’d be wrong. With Snowflake, we could do many different things that we’re not used to seeing with a SELECT statement.…… Continue reading SELECT Something New in Snowflake
Making the SELECT work in Snowflake
With our last blog post, we started discussing Snowflake and the SELECT statement. Now, if you remember, there is this great thing called a semi-colon. The main reason you should use the semicolon is to terminate all of your queries. Snowflake does this great thing by default, letting you run one query at a time.…… Continue reading Making the SELECT work in Snowflake
Checking Out Snowflake
Over the years, I’ve learned a decent amount of things when it comes to Microsoft’s SQL Server. Even with the new SQL Server 2022 which was just announced as being generally available just last week. But, sometimes, you just want to bust out of the old grind and do something a bit different. For me,…… Continue reading Checking Out Snowflake
Counting Down the Emails
Sometimes everyone has to do things outside of a database. One of those times, at least for me, was today. Over the past week, I have been getting emails from a SQL Server that has issues – hence why I was called in to check it out. In my inbox, I had hundreds of emails!…… Continue reading Counting Down the Emails
Error Messages can be Helpful
Sometimes you just run into a situation you have to blog about. This time, I want to talk about the fun error messages that everyone is supposed to be watching out for. Whenever a process errors out, in most corporate environments there is usually one of two things that happen: Someone manually notifies a specified…… Continue reading Error Messages can be Helpful
Transactions should (never) be distributed
For the last few blog posts, we’ve been talking about transactions. If you’ve missed any, be sure to click on the links below: Using Save Points with Transactions to Get BetterHow about we TRY and CATCH some Transactions?Setting up a Friendly TRANSACTION In the version of transactions that we going to discuss today, we’re going…… Continue reading Transactions should (never) be distributed
Using Save Points with Transactions to Get Better
When we last conversed, we talked about the TRY/CATCH block and how it works with transactions. If you somehow missed that, you can read about it here – How about we TRY and CATCH some Transactions? We’ll wait for you… All right, now that everyone’s back with us, we’ll talk more about everyone’s favorite -…… Continue reading Using Save Points with Transactions to Get Better