DEV Community: randysims

SQL Server Set Operators: UNION, INTERSECT, and EXCEPT

randysims — Wed, 12 Sep 2018 20:40:20 +0000

Did you know you can do set-based math with SQL Server? With the UNION, INTERSECT, and EXCEPT set operators, you can compare one result set to another and add or subtract results, called a compound query. This can be a handy tool for your toolbox… Continue reading SQL Server Set Operators: UNION, INTERSECT, and EXCEPT

Review: SQL Operations Studio (Preview) for SQL Server

randysims — Tue, 04 Sep 2018 14:49:46 +0000

As someone who develops on SQL Server every day, I wanted to try it out the latest gizmo, SQL Operations Studio, or SQLOps. I hoped it was going to be my new favorite toy with all those extensions. In the end, I’m fine with it. There is one problem and a couple of missing features, however, that will keep ETL developers using SSMS. Continue reading Review: SQL Operations Studio (Preview) for SQL Server

What are the post reactions?

randysims — Tue, 28 Aug 2018 10:26:29 +0000

I'm new. What does a unicorn mean? And what is the reaction on the right? I read a post that already exists but it didn't mention the tag on the right.

SQL Server 2016’s STRING_SPLIT

randysims — Mon, 27 Aug 2018 15:02:51 +0000

I found a pretty cool little function as I was perusing the SQL Server functions documentation the other day. (What, doesn’t everyone do that?) I just read the name of this function and thought, well, no need to create that function with a loop any longer! Finally, SPLIT has come to SQL Server! What is … Continue reading SQL Server 2016’s STRING_SPLIT

SQL Server’s [N]VARCHAR(MAX) and How to Wield It

randysims — Fri, 24 Aug 2018 16:06:45 +0000

[N]VARCHAR(MAX) is a data type that was created to replace [N]TEXT. Depending on how many characters you store in this data type, it will react differently to its surroundings. It might be just what you needed or it might be your worst nightmare, so choose wisely. Here’s a run down on this data type. What … Continue reading SQL Server’s [N]VARCHAR(MAX) and How to Wield It

SSIS: Change Encryption on a Project and Packages

randysims — Tue, 29 Nov 2016 19:01:47 +0000

When creating packages, the default security protection level is set as EncryptSensitiveWithUserKey. The user key mentioned is created off of the login of the user who created the project. If a developer other than the one who originally created the project or package opens it, they will receive the following warnings: Warning loading project_name.dtproj: Warning: … Continue reading SSIS: Change Encryption on a Project and Packages