A Summit Rebirth in 2022 - Who is the winner? (2021-11-10)

SQLServerCentral Newsletter for November 10, 2021 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [Azure Data Studio vs SSMS - Who is the winner?]( - [Idempotent DDL Scripts That Always Achieve The Same Result - Making Changes Only Once: Stairway to Exploring Database Metadata Level 6]( - [Managing Database Documentation during Flyway-based Development]( - [Handling an unknown number of parameters in SQL Server]( - [From the SQL Server Central Blogs - Error [IM002] [Microsoft][ODBC Driver Manager] "Data source name not found and no default driver specified" and who do you trust?]( - [From the SQL Server Central Blogs - Understanding The Basics of SQL Server Security]( Question of the Day - [SqlClient for .NET Protocols]( The Voice of the DBA  Daily Coping Tip Get outside and observe the changes in nature around you 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. A Summit Rebirth in 2022 This year the annual SQL Server and Data Platform community is getting together for the annual Summit virtually. You can [still register and attend today through Friday]( for free. The content is also being recorded, and if you register, you can watch it later, or re-watch it, at your convenience. It's free training for your career across [a wide variety of topics]( so take a moment and fill out the form. There's another good reason to register now. Next year's Summit will be hybrid, with the in-person portion happening back in Seattle next fall. However, there will be a limited number of tickets available for those that want to travel to the event and be in the same room as other professionals. Tickets for the live portion are only going to be available to people registered for this year's event, so make sure you head over to [the site and register today](. You can also read about the announcement on [the Redgate blog](. I am thrilled that there will be a live conference next year. I have missed the chance to get together with others now that I'm vaccinated. I was lucky to attend a couple of events this year and am looking forward to SQL Server and Azure SQL Conference in December. I am hoping to get to [SQL Bits]( in the spring in London, and I am very excited to go to next year's Summit and spend time with the #sqlfamily that have made the last two decades a joy. I relish the chance to talk live with others, get inspired by their knowledge and stories, and bond over meals. It's been invaluable in my career and brought many smiles to my face. I am also glad that next year's event will be hybrid, allowing those that can't travel, or don't feel comfortable, to still access content and interact with others. I know that this is important, and I hope we find ways to provide additional hybrid options in the future. While I do think the pandemic will recede, some of the concerns will remain over large crowds and event safety. I think we should accommodate those that are not attending conferences live, and I expect we will find ways to do this better in the years ahead. The annual Summit has been a large part of my career for over 20 years. It has been a time and place where most of the best, brightest, and more generous Data Platform professionals from inside and outside of Microsoft gather to share information and help each other grow our industry. I look forward to the rebirth of this amazing experience in a hybrid form next year, with changes and ideas to make the event even more invigorating. Note: The deadline [to register]( and be eligible for a ticket next year is Friday morning, before the Community keynote, presented by Brent Ozar. Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums](   Featured Contents [SQLServerCentral Article]( [Azure Data Studio vs SSMS - Who is the winner?]( Daniel Calbimonte from SQLServerCentral Introduction I have to admit that I love SSMS. It is a great tool, and I felt furious when a colleague mentioned that Azure Data Studio will replace SSMS in the long run. In this new article, we will talk about the main differences between Azure Data Studio and SSMS. We will see if my […] [Stairway to Exploring Database Metadata]( [Idempotent DDL Scripts That Always Achieve The Same Result - Making Changes Only Once: Stairway to Exploring Database Metadata Level 6]( Phil Factor from SQLServerCentral.com Idempotence is the property of certain operations in mathematics and computer science, that can be applied multiple times without changing the result beyond the first time they are run. When you are making changes to a database to deploy a new version, you need to be sure that certain changes aren’t made twice, or in the wrong order. [External Article]( [Managing Database Documentation during Flyway-based Development]( Additional Articles from Redgate Learn how to create and maintain a 'data dictionary' for your databases, in JSON format, which you can then use to add and update the table descriptions, whenever you build a new version using Flyway. [External Article]( [Handling an unknown number of parameters in SQL Server]( Additional Articles from MSSQLTips.com In this article we compare performance differences when splitting comma separated strings using TVPs, TVFs, openjson, string_split and more. From the SQL Server Central Blogs - [Error [IM002] [Microsoft][ODBC Driver Manager] "Data source name not found and no default driver specified" and who do you trust?]( Rayis Imayev from Data Adventures (2021-Oct-31) A very short blog post, just a reminder to myself, but if you have ever tried to connect to a PostgreSQL database using ODBC interface (I know, it already... [Blog Post]( From the SQL Server Central Blogs - [Understanding The Basics of SQL Server Security]( Sheldon Hull from Sheldon Hull Confusing As I’ve worked with folks using other database engines, I’ve realized that Microsoft SQL Server has some terminology and handling that is a bit confusing. Here’s my attempt to clarify...   Question of the Day Today's question (by Steve Jones - SSC Editor):  SqlClient for .NET Protocols What can I do to control the order in which protocols are tried for the .NET SqlClient? 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) Dropping the Aggregate What are the minimum permissions I need to drop an aggregate from a SQL Server 2019 database? (choose 2) Answer: CONTROL on the aggregate, ALTER on the schema Explanation: The minimum permissions needed are ALTER on the schema or CONTROL on the aggregate. If you owned the aggregate, you could also delete it. Ref: DROP AGGREGATE - [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 2016 - Administration [TLS 1.2 communication problem]( - I'm trying to get 2 servers to communicate using TLS 1.2. On the calling web sever I have disabled TLS 1.0 and TLS 1.1 - leaving TLS 1.2 enabled. On the SQL Server TLS 1.0, 1.1 and 1.2 are all enabled. I have installed MSOLEDBSQL driver on both servers. The database server is running SQL […] [Automate loading data to SQL Server 2016 from Oracle DB]( - Hi SQL Server Mentors, We have a table in SQL Server 2016 that is frequently feeded up with data from an Oracle DB table based on a Query. I do it manually thru SQL Server import and export wizard. However I need to automate it as a batch process or stored procedure. Please advise me […] SQL Server 2016 - Development and T-SQL [How To Re-Insert a Row with Identity Value]( - I have accidentally deleted a record which originally looked like this:  But now looks like the following: As you can see row, 515 13 DriverId has been deleted. I want to re-insert the row with ColumnID 515, however because ColumnID is an Identity value i.e. Auto-Increments I can only enter a row with ColumnID […] Administration - SQL Server 2014 [security related question]( - Hi All, Have a question regarding database roles in SQL Server. While assigning the database role for a database user, we have roles like db_datareader & db_writer roles. Similarly, we have db_denydatareader & db_denydatawriter roles. My question is, what is the use of these 2 deny roles. If I don't want to a user to […] Development - SQL Server 2014 [Bulk Insert - Only Half the Records]( - I am having a hard time with this. I am trying to load a *.txt file using BULK INSERT, but no matter what I do, it seems to only load about 50% of the records. Our *.txt file has two rows of "header" data, and one row of "footer / trailer" data. Unfortunately, this is […] SQL 2012 - General [How to get Feature Name and Feature Value separated by $ for table AllData ?]( - I work on SQL server 2012 I face issue I can't get Feature Name and Feature Value for Table All Data From table Part Attributes Feature Name and Feature Value exist on table Part Attributes full sql structure and query found here UPDATE Codes SET Proceed=0 DECLARE @Code VARCHAR(20) DECLARE @ZPID INT DECLARE @Sql […] SQL Server 2012 - T-SQL [Query runs slow sometimes and sometimes runs superfast (2 minutes vs 2 seconds)]( - This query runs very slow at times and very fast at time. What could cause this behavior? i checked the slowness is coming from auditLog table. Its a big table as it stores audit records. But still cant figure out why its very slow at times.  select * from ( SELECT coitem.[ship_site] ,custaddr.[name] ,coitem.[co_num] […] SQL Server 2019 - Administration [Permissions Error Running DTEXEC on SQL Agent job]( - For "reasons," our corporate office is requiring us to move all our SSIS packages to the SAN share on our servers and call the package with a Command Operating System task. It's incredibly frustrating but we've done it before on SQL 2005, so it's not unknown to us. Unfortunately, SSIS now requires administrator access to […] [Monitoring system]( - We are setting up Idera SQL DM system to monitor our SQL Server's. So we have availability group setup for the repositories at database level. Looking for option to see if anyone has done application HA? If yes, could you please shed some light on the application clustering for Idera SQLDM tool. Thanks in Advance! SQL Server 2019 - Development [How to retrieve a number in range that matches another number]( - Ive got a lookup table with a set of values . this is as follows DROP TABLE IF EXISTS [dbo].[SIData_NTILE_Test_20211012_6months_MainLevelData_TableRecordCounts] CREATE TABLE [dbo].[SIData_NTILE_Test_20211012_6months_MainLevelData_TableRecordCounts]( [ID] [int] NULL, [NumbeOfRecords] [decimal](15, 6) NULL, [NumberOfGroups] [int] NULL, [TimeInterval] [decimal](15, 6) NULL ) ON [PRIMARY] GO INSERT [dbo].[SIData_NTILE_Test_20211012_6months_MainLevelData_TableRecordCounts] ([ID], [NumbeOfRecords], [NumberOfGroups], [TimeInterval]) VALUES (1, CAST(1555201.000000 AS Decimal(15, 6)), 1944, CAST(8000.000000 […] [SQL Server Job Agent - The workgroup file is missing]( - Hi firstly im sorry if this is in the wrong place, i couldnt find a ssis forum. I have been working with a mariadb, trying to get the data into sql server. A very long way around it maybe but i found one solution to create a linked table in access and then import the […] Azure Data Factory [Pass a list in a stored procedure in ADF]( - Hi there i m stuck in how I can pass a list of parameters using the copy data on Adf is it a limitation with the tool ? does anyone know ? my sp is running as exec sp1 @var1 when u declare and save the values in that variable it runs fine any pointers […] SSRS 2016 [SSRS: Possible Transition to PowerBI?]( - Hello, All: I was wondering if anybody has made a full transition from SSRS (2016) to PowerBI? Are there any difficulties involved with converting SSRS reports to PowerBI? Are there tools that can already do this, or will it be a slog of rebuilding them Report-By-Agonizing-Report (with apologies to Jeff Moden)? Thank you in Advance! […] General [How to learn SQL?]( - Hi everyone, I would like to learn MySQL, and can anyone share some tutorials with me? I have been googling but I decided to join a community and ask the experts for the advice Integration Services [Help Converting Query For Hierarchical Data]( - I have a working query within MySQL based on (Managing Hierarchical Data in MySQL - . The problem I have is that I need to implement the same functionality on another piece of software which uses MSSQL. The two issues I am facing is that it doesn't seem possible to group/order within subqueries in MSSQL, as it […]   [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -