Working with SQL Server in Visual Studio Code (2024-06-17)

SQLServerCentral Newsletter for June 17, 2024 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [Working with SQL Server in Visual Studio Code]( - [The CHECK() Constraint]( - [From the SQL Server Central Blogs - Why the masters and what lies ahead]( - [From the SQL Server Central Blogs - Copilot Reminded Me How To Find a File Handle]( - [Deciphering Data Architectures]( Question of the Day - [A Lack of Memory Grant Feedback Persistence]( The Voice of the DBA  Five Years and Counting I almost called this "chasing a new laptop" since that's what I'm doing, but I decided to add the date because the current laptop I've using was built in March 2019 and got to me in May 2019. I've had an HP Spectre x360, my second HP Spectre, and I've really enjoyed it. I'm also amazed it still runs. On the last few trips, the two rubber strips that run along the bottom (acting as feet) started to peel away. I've never seen that before and I tried to re-attach them a few times, but that didn't work well. Not a big deal, and I can live with that, but then during my Australian tour, the laptop started pausing and freezing a few times. It might be that there is too much software on there and needs a pave-and-reinstall, but I decided to check the age on the machine. That was when I realized it was five years old. It's been a great machine, but I don't think I've ever had a work laptop last that long with daily use. Of course, there was about a year during the pandemic when it was rarely used, so maybe its life lengthened during COVID. In any case, I started looking around for a new one. My initial glance at smaller laptops has me considering these: another [HP Spectre x360]( the [ASUS 14]( the Lenovo [Thinkpad X1 Carbon]( and the [DELL XPS 14](. That's the short list, since I really want a Windows PC that can run SQL Server and tools locally. I've had a Macbook before, and in the past I could run a VM with Windows tools. I can run SQL Server now, but not SSMS, and I like running SSMS. I'm just starting to look at some reviews, and think about what I need. I've had a i7 CPU, 16GB RAM, and a 1TB SSD, which have served me well for the last 5 years. I don't think I need more, though 32GB is tempting for a memory upgrade. I don't do a lot of heavy development, so it's more about having the things I run be snappy in presentations with customers and at conferences. What machines do you use and like? I've appreciated the durability of the last two HPs, so I'm leaning towards another. I do like the pointer on the Lenovo, so that's tempting. I'd like a touch screen as I use it regularly, though I don't need a folding 2-in-1 machine. A normal clamshell is fine. If you have a recommendation, let me know. If you have a dream machine, make me drool over it. Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums](   Featured Contents [SQLServerCentral Article]( [Working with SQL Server in Visual Studio Code]( Daniel Calbimonte from SQLServerCentral Learn how you can work with SQL Server in VS Code. [External Article]( [The CHECK() Constraint]( Additional Articles from SimpleTalk One of the many ways a relational table differs from the file structures used by pre-relational storage systems is that the tables, rows and columns can have constraints on them. This allows you to reduce the types of bad data that can be loaded into your tables. [Blog Post]( From the SQL Server Central Blogs - [Why the masters and what lies ahead]( Diligentdba 46159 from Mala's Data Blog I recently graduated with a Master’s in Strategic Communication from the University of Delaware. Attending the graduation ceremony with my sister made it a truly memorable experience. Here’s a... [Blog Post]( From the SQL Server Central Blogs - [Copilot Reminded Me How To Find a File Handle]( Steve Jones - SSC Editor from The Voice of the DBA Recently I was trying to delete a folder and kept getting the “something is using this, try again” dialog. It was annoying, but I couldn’t figure out what process... [Deciphering Data Architectures]( [Deciphering Data Architectures]( Additional Articles from SQLServerCentral Data fabric, data lakehouse, and data mesh have recently appeared as viable alternatives to the modern data warehouse. These new architectures have solid benefits, but they're also surrounded by a lot of hyperbole and confusion. This practical book provides a guided tour of these architectures to help data professionals understand the pros and cons of each.   Question of the Day Today's question (by Steve Jones - SSC Editor):  A Lack of Memory Grant Feedback Persistence SQL Server has added an Intelligent Query Processing feature called Memory Grant Feedback. In SQL Server 2022, this can be persisted across queries to improve the performance of future executions. In SQL Server 2022, when is memory grant feedback not persisted if the plan is evicted from cache? (choose 2) 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) Sensitivity Ranks I want to use the ADD SENSITIVITY CLASSIFICATION DDL to mark some columns in my SQL Server 2022 database as PII. Can I use this code? ADD SENSITIVITY CLASSIFICATION TO dbo.sales.price, dbo.sales.discount WITH ( LABEL = 'Highly Confidential', INFORMATION_TYPE = 'Financial', RANK = 'INTERNAL ONLY' ); Answer: No, because the RANK is incorrect Explanation: The issue is that the RANK parameter must be one of these values, unquoted as they are considered keywords for this statement: - NONE - LOW - MEDIUM - HIGH - CRITICAL Ref: ADD SENSITIVITY CLASSIFICATION - [ [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 [large transaction log backups]( - Hi All. From last 4-5 days we are seeing log backup file sizes increased from 500 MB's to 100GB files. What does it indicate and what should we checking at? the queries which are running during those times? This is not just happening during weekends (index rebuilds ..) but during weekdays also its the same […] [Schema Execute not working on sproc]( - I am VERY confused. We are switching an application from using a SQL login to using a windows login that is part of a windows security group. So the group has db_datareader, db_datawriter, and execute on schema dbo. There are a couple of db_denydatawriters on other groups, but this proc is not writing to any […] SQL Server 2016 - Administration [SQL Error Log - number of files]( - Hi All, I need some assistance in understanding why my SQL error logs are not being deleted. I initially thought, the Error Log configuration was incorrect, but upon checking, it is set to Maximum 16 files (see below) which is what I wanted. I also setup an "sp_cycle_Errorlog" which created a new file, but history […] SQL 2012 - General [Replication help, please!]( - I cannot get a snapshot to generate for one of my five publications. The snapshot gets to 99% complete and then goes to status: "The process is running and is waiting for a response from the server." Eventually, it restarts from 0% again. I've been playing this game for hours, and now I don't know […] SQL Server 2019 - Administration [Run SSIS package asynchronously from SQL Agent job step]( - I'd like to run an SSIS package asynchronously from a SQL Agent job step through the the [SSISDB].[catalog].[create_execution] and [SSISDB].[catalog].[start_execution] stored procedures. I need the target package to be run by a specific login, so that login has been set as the owner of the SQL Agent job. However, the job step returns the error: […] SQL Server 2019 - Development [odbc and netsuite]( - hi i just got off the phone with netsuite and we discussed their invoice api.  it occurred to me that if that api isnt already limited column wise in what it can return about invoices entered in the last couple of days, it probably will be in the future. in our happy path we scrape […] [Stored Procedure - Error not found when temp table is used in join]( - Dear all, what I learned is that Stored Procedures (SP) are not compiled before they are executed the first time, but a syntax check takes place when creating it. What I don't understand is, that e.g. a wrong table column in a join is not leading to an error message as soon as a temp […] [Index Scan instead of index seek]( - Hello guys, I have the following query: SELECT COUNT(*) FROM "dbo"."STXL" INNER JOIN "dbo"."STXL_RET" ON "STXL_RET"."MANDT" = "STXL"."MANDT" AND "STXL_RET"."RELID" = "STXL"."RELID" AND "STXL_RET"."TDOBJECT" = "STXL"."TDOBJECT" AND "STXL_RET"."TDNAME" = "STXL"."TDNAME" AND "STXL_RET"."TDID" = "STXL"."TDID" AND "STXL_RET"."SRTF2" = "STXL"."SRTF2" AND "STXL_RET"."SPRAS_ISO" = "STXL"."SPRAS_ISO" WHERE "STXL_RET".ProcessName = 'ISAM_EKKO_T1' AND "STXL_RET".BoName = 'MM_EKKO' And the following indexes: STXL_RET […] SQL Azure - Administration [SQL DB migration]( - Hi I am New To Azure Sql.  Can some one please share  If we can migrate sql 2017 db with symmetric key and certificate in it on Prem to Azure SQL database? how to restore db from one azure sql database to another azure awl database? Thanks Azure Data Factory [deploying datafactory using YAML script - Error]( - Hi All, First foray into deploying adf using YAML scripting from Azure Devops from a dev resource to a test resource group..am using boilerplate code YAML code cribbed from the internet. The artifacts have been created correctly so that bit works. Deployment the second half requires creating in my azure project settings a service connection […] General [Flower Delivery Sunshine]( - Are you looking for flower delivery in Sunshine? The stunning bouquets and arrangements that are available from The Flower Shed are suitable for any occasion. These florists guarantee the delivery of fresh, high-quality flowers directly to your door, so you can send flowers to celebrate birthdays, anniversaries, or just to cheer someone up. With choices […] SQL Server 2022 - Administration [Servers being moved go new location - new IP addresses.]( - Hi Our Physical servers are going to be moved to a new location and new IP addresses will need to be assigned to the SQL servers. We use High Availability so will the listener sub net and IP need to be changed? I cant think of any other pain points - am I missing something? […] [Contained Availability Groups - Failover Questions.]( - Hi I am considering creating Contained Availability Groups in my production environment. Thinking I need to drop disabled jobs that live on both servers first? I've searched and read allot of Contained Availability Groups articles but none of them that I can find describe the failover process once the Contained Availability Groups are setup. During […] SQL Server 2022 - Development [Using USE does not set DB context]( - Hi Experts, I have a Sql file with a bunch of DDL statements (Create Tables/Views). I start with a DB then change DB context to another DB followed by 2nd set of DDLs. In Sql file, I have: DECLARE @DB1 NVARCHAR(MAX) = 'DevDB', @DB2 NVARCHAR(MAX) = 'TestDB', @ENV NVARCHAR(MAX) SELECT @ENV = 'USE ' + […] [blocking due to cuncurrency problem.]( - hi, CREATE TABLE [dbo].[bridge]( bridgeid [bigint] NOT NULL, [idpool] bigint NULL, status int null CONSTRAINT [PK_bridge] PRIMARY KEY CLUSTERED ( [bridgeid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] Go bridgeid is pk , and […]   [RSS Feed]( 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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -