Stairway to SQLCLR Level 6: Development Tools Intro (2021-03-10)

 SQLServerCentral Newsletter for March 10, 2021 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [Stairway to SQLCLR Level 6: Development Tools Intro]( - [T-SQL Tips and Tricks]( - [Getting Data In and Out of SQL Server Flyway Builds]( - [From the SQL Server Central Blogs - Behavior of numeric data types with ”]( - [From the SQL Server Central Blogs - Microsoft Ignite Announcements 2021]( Question of the Day - [An Empty NumPy Array]( The Voice of the DBA  Daily Coping Tip Notice how you speak to yourself. Try to use kind words I also have [a thread at SQLServerCentral]( dealing with coping mechanisms and resources. Feel free to participate. For many of you out there working in a new way, I'm including a thought of the day on how to cope in this challenging time from [The Action for Happiness Coping Calendar](. My items will be on [my blog](, feel free to share yours. The Ease of Containers I first heard about containers in 2012. I went to a conference on software delivery and talked with a gentleman that was using them in his Java application, mostly because the Java app had version issues and would leak memory. He could run hundreds of instances of the app on each server and handle a load, allowing each to be built, run, and then get destroyed in minutes. Since then, I've come to appreciate containers as a way to isolate workloads of specific applications. They became very popular a few years ago, and many developers and companies were looking at them. Since then, the hype has cooled, but I find that the used of containers is still growing, and certainly my use is growing as well. In the last year, I've experimented with a few different pieces of software in containers. Rather than try to install a number of dependencies on my system, I've downloaded a container, mapped a volume, and been up and running much quicker than I would have been otherwise. My [experiments with Jekyll]( were one of the recent examples. I also got a demo from someone at Redgate recently that included a container file, allowing me to use VS Code, but [develop and run in a container](, avoiding dependencies on my machine. I was up and running with this software in minutes. I was truly impressed with the ease of getting started, and the simplicity for me to actually run and debug code. I still don't see a lot of database container work in production, or even in development. We get requests from customers, but often it's a wish, and they aren't even sure how they'd get started. While I think database development with containers is fantastic, you do need to have a good dataset available that you can use inside the container to keep resource usage low and make this a viable environment. I still expect the future of database development to be in containers, especially as we start to have more and more applications connecting to multiple data sources. That's going to take some time, but I still think learning about, and experimenting with, containers is a great skill for you to have. It's also an impressive topic on which to have a few stories ready for your next interview. Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums](   Featured Contents [Stairway to SQLCLR]( [Stairway to SQLCLR Level 6: Development Tools Intro]( Solomon Rutzky from SQLServerCentral.com This time we look at the commonly used tools for doing SQLCLR development: Visual Studio (VS), SQL Server Data Tools (SSDT), and SQL Server Express LocalDB (LocalDB). [T-SQL Tips and Tricks]( Additional Articles from MSSQLTips.com In this article learn some TSQL tips and tricks working with CTEs, UPDATES, Window Functions, Duplicate Rows, Tally Tables and Concatenating string values in SQL Server [Getting Data In and Out of SQL Server Flyway Builds]( Additional Articles from Redgate Phil Factor provides SQL routines to extract data from and load data into a SQL Server database, using BCP, and then a PowerShell automation script that uses Flyway to automatically build a database, from scratch and then fill it with data, ready for testing. From the SQL Server Central Blogs - [Behavior of numeric data types with ”]( Brahmanand Shukla from SQL Server Carpenter As we all know, there are various numeric data types, such as TINYINT, INT, SMALLINT, BIGINT, NUMERIC, DECIMAL, SMALLMONEY, MONEY and FLOAT. I was working on a SSIS package,... From the SQL Server Central Blogs - [Microsoft Ignite Announcements 2021]( James Serra from James Serra's Blog Microsoft Ignite has always announced many new products and new product features, and this year was no exception. Many exciting announcements, and below I list the major data platform and...   Question of the Day Today's question (by Steve Jones - SSC Editor):  An Empty NumPy Array I have imported the numpy module: import numpy a = numpy.xxxx What replaces the xxxx to get an empty array in the variable, a? Think you know the answer? [Click here]( and find out if you are right.    Yesterday's Question of the Day (by Steve Jones - SSC Editor) Parameters in RAISERROR I want to add a parameter in my RAISERROR code to customize it: RAISERROR(' %s is the current value', 1, 0, @d) What data types can I use for @d? Answer: tinyint, smallint, int, char, varchar, nchar, nvarchar, binary, or varbinary Explanation: You can use these data types: tinyint, smallint, int, char, varchar, nchar, nvarchar, binary, or varbinary. Ref: RAISERROR - [Discuss this question and answer on the forums](    Database Pros Who Need Your Help Here's a few of the new posts today on the forums. To see more, [visit the forums](. --------------------------------------------------------------- SQL Server 2017 - Administration [use functionality enterprise edition]( - Good morning all , I must proceed to migrate an instance of 2008 Enterprise Edition to 2017 standart Edition but I must be sure that in my old instance there is no functionality used from the enterprise edition There is a utility or queries that allows me to tell me if my my instance uses […] SQL Server 2017 - Development [Data Warnings / Ignore Checked Results]( - Not looking for any code, just ideas. I have a series of queries which run regularly, which return data rows which we consider to be potentially incorrect or worthy of being checked. These queries run against any database/table deemed particularly interesting/important. Imagine a scenario where 75 rows of data are identified, across three different queries. […] SQL Server 2016 - Administration [Alert configuration]( - How to set up alerts on long running jobs on sql server ?, pls provide script to configure SQL Server 2016 - Development and T-SQL [Empty Index Statistics object]( - This is a new thread but relates directly to Index statistic is empty - how is this possible? My post in that thread and for background " I too am on SQL2016 CU15 , db in Compatibility mode 2012. In the past four months we have had three occurrences of this problem. We are truncating […] [Transactions]( - Hi, Can you please let me know what is the benefit of using the 'SET IMPLICIT_TRANSACTIONS ON' in the below code when we already have 'BEGIN TRAIN' which can be used to rollback if any error occurs? So, I see IMPLICIT is also being used sometimes, not sure what is the benefit when we already […] Development - SQL Server 2014 [Calling a Function to Update Temp Table]( - Hello, I have created a function that will determine the Distance between 2 sets of Lat and Log Coordinates. The function is working as desired. As a next step, what I would like to do next is record the difference in miles into my temp table. I am attempting is to call the Function within […] [Help with procedure creation and execution]( - I created the procedure below, but the updates do not run, how do I run it all, could you help me? ALTER PROCEDURE [dbo].[pp_updZeravalor] as begin declare @turnoid bigint, @ProdutoID int, @coletaid int, @areaid int, @sequencia int, @prefixo int, @Quantidade int=0, @Contador int=0, @valorUnitario int=0, @creditos int=0, @ValorMotorista int=0, @recebido int=0, @girosPagantes int=0 select top […] SQL 2012 - General [How to get PartId from table #trades that have wrong Code ON Code Value To when]( - How to get PartId from table #trades that have wrong Code ON Code Value To when code type from and code value from Exist ? How to get PartId from table #trades that have wrong Code ON Code Value To when code type from and code value from Exist ? I work on SQL server […] [SSL Security Error]( - Hello, We are trying to connect to another SQL Server database (2012 build 11.0.7001) from SQL Server 2012 database with build 11.0.7507 using SQL Native client. The database server we are trying to connect from does not have TLS 1.2 enabled whereas the database server we are trying to connect to has TLS 1.2 enabled […] SQL Server 2019 - Administration [Importing text file issue]( - Hi, I am trying to import the attached REF_RF1MAS.txt file but am getting numerous bulk load errors. I was given the attached A_spec that is supposedly the import specs but it does not seem correct. I tried the code below. Any ideas on what the issue is? Thanks.  Msg 4863, Level 16, State 1, […] [Question on report server database]( - Hi,  We just installed SQL Server 2019 on a new server and moved everything over. We have two Databases that are named ReportServer$DMP2 and ReportServer$DMP2TempDB. a lot of the tables in these are either empty or has very little in them. We do not use SSRS, which I thought that is what these were used […] [Querystore is very slow]( - I'm working with a 260GB sized production-database here and working a little bit with QueryStore. However it's painfully slow, it takes several minutes to get the result I want to see (25 top resource consumers, last 24 hours, for example) sometimes it even gives me "can't connect to database" after awhile. Should it be like […] SQL Server Newbies [Assistance needed]( - I have the need to pull data using a last touched date. Below ins the query, I highlighted the date I need , it pulls all dates. Please help. SELECT R.DCN,CHK_ML_CLIENT_CODE,CONVERT(VARCHAR(10),R.SCANNED_DATE,101) AS 'SCANNED DATE',R.CHK_ML_CUR_STATUS,R.CHK_ML_QUEUE,R.READ_ONLY_INDICATOR,CONVERT(VARCHAR(10),H.CHK_ML_TIME_STAMP,101)AS 'LAST TOUCH DATE', R.CHK_ML_LAST_TOUCH,CONVERT(VARCHAR(10),R.CHK_ML_LOAD_DATE,101)AS 'LOAD DATE',R.CHK_ML_FACETS_CHK_NO, R.CHK_ML_PROV_NAME,R.CHK_ML_CHECK_AMT,CONVERT(VARCHAR(10),R.CHK_ML_LOCK_BOX_DT,101)AS 'LOCK BOX DATE',R.READ_ONLY_INDICATOR,R.RECLASS_RECD_CHECK_AMT,R.CHK_ML_OPS_CHECK_REASON,R.CHK_ML_PRPR_NAME,R.CHK_ML_PRPR_ADDRESS,CONVERT(VARCHAR(10),R.CHK_ML_RECD_DT,101)AS 'RECEIVED DATE',CONVERT(VARCHAR(10),R.REOPEN_DT,101)AS 'REOPENED DATE',R.REOPEN_USER,CONVERT(VARCHAR(10),R.REOPEN_RQST_DT,101)AS 'REOPEN REQUEST DATE',RIGHT(LEFT(R.DCN,12),2) 'DOCTYPE' FROM dbo.CHK_ML_RECD R […] Amazon AWS and other cloud vendors [move file backup from premise to EC2 instance]( - hello everyone I must proceed to migrate my database from the premises to EC2 instances I'm trying to find out how to transfer my backups to an EC2 machine thenas for you help Reporting Services [shared datasets and cache refresh option]( - hi guys! Problem: 1) Every time I overwrite an existing shared dataset (with a manual upload or using DevOps pipeline) any existing cache gets deleted and doesn't get recreated until the next scheduled refresh or until the first user will request the report. 2) When I upload or deploy new datasets I have to manually […]   [RSS Feed]([Twitter]( This email has been sent to {EMAIL}. To be removed from this list, please click [here](. If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com. This newsletter was sent to you because you signed up at SQLServerCentral.com. ©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -