How to use Jupyter Notebook in VSCode (2024-07-22)

SQLServerCentral Newsletter for July 22, 2024 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [How to use Jupyter Notebook in VSCode]( - [Using Query Store to Identify CPU Intensive SQL Queries and Creating Proper Indexes]( - [From the SQL Server Central Blogs - Identify Tables With Dropped Columns]( - [From the SQL Server Central Blogs - Set a Runtime Variable in an Azure DevOps Pipeline]( - [Deciphering Data Architectures]( Question of the Day - [The Last DBCC Date]( The Voice of the DBA  The Biggest Database Professional Challenges Today Today I have a question for you: What are the three biggest challenges you face today as a database professional? I was asked this recently, and I had some ideas, but I wonder if my challenges are the same ones you face. I don't want to influence you, but I'm wondering what things cause you stress, headaches, difficulties, or somehow lower the enjoyment of your job. Or maybe these are the things that challenge and motivate you to do more. It's up to you to decide what is a challenge to you as a database professional. I think about the challenges I have faced (and would face today) as someone working with data in a few ways. First, there are the actual challenges of working in an organization and dealing with other people/groups/management. Next, I think about technology challenges as well, with how we architect systems, pick tools, and make choices. Lastly, I also think about this in terms of my career and what difficulties I face there. How do I keep my career moving forward? There are several ways to look at this. In a general sense with a high-level view or with specific challenges in dealing with technology/people/etc., such as HA latency. Maybe you think about long-term issues or acute firefighting that you are dealing with every week. There are many ways to view the impediments to an endless progression of smooth, quiet, easy workdays. Spend a few minutes thinking about what challenges you have and let us know today what those are. Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums](   Featured Contents [SQLServerCentral Article]( [How to use Jupyter Notebook in VSCode]( Daniel Calbimonte from SQLServerCentral Learn how you can create and use a Jupyter Notebook in VS Code. [External Article]( [Using Query Store to Identify CPU Intensive SQL Queries and Creating Proper Indexes]( Additional Articles from MSSQLTips.com Learn how to use SQL Server Query Store to identify what resources are using CPU to help fine-tune queries and reduce the processing load. [Blog Post]( From the SQL Server Central Blogs - [Identify Tables With Dropped Columns]( Cláudio Silva from Cláudio Silva On my last article - What happens when we drop a column on a SQL Server table? Where’s my space? - I have shown what happens when we drop... [Blog Post]( From the SQL Server Central Blogs - [Set a Runtime Variable in an Azure DevOps Pipeline]( Steve Jones - SSC Editor from The Voice of the DBA Note: I DO NOT recommend this. Any changes to a pipeline should be in code and through a PR. That being said, I know this information is out there... [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):  The Last DBCC Date How can I easily get the last DBCC CheckDB date from T-SQL in SQL Server 2022? 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) Synapse Analytics History I Before Synapse Analytics was a service in Azure, what was the name of the analytic data warehouse platform in the Azure cloud? Answer: Azure SQL Data Warehouse Explanation: The name in the Azure cloud was Azure SQL Data Warehouse before it evolved into Synapse Analyics. Ref: What's the difference between Azure Synapse (formerly SQL DW) and Azure Synapse Analytics Workspace - [( [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 [what are the software' required for sqlserver dba in laptop to install]( - HI Team, what are the software's required for sqlserver dba in laptop to install in new company can you list out things where i dont have access need to reach access team to install , i need to provide the list of software's required  SQL Server 2016 - Administration [log shipping switchover and switchback]( - I have log shipping in my environment. Could you please let me know steps to switchover and switchback for doing DR drill SQL Server 2019 - Development [needing to insert 2 sets of numbers to a table to use as ranges for a query]( - the ranges (a lot) need to have a preset spacing between each set of numbers. value1, value2 -999999999,-998999999 -998999998,-997999999 -997999998,-996999999 and so on until i reach the limits of +999999999 not a gap/island thing have a query for between those ranges, don't care how long it takes to add the ranges or query the ranges. [UPSERT question for performance and efficiency]( - Hello SSC! First, I would like to thank everyone for responding to my posts. It is greatly appreciated! I have a question about an UPSERT proc that I am in the process of writing. I have a table with over 200 columns that I basically need to perform a MERGE on. The DELETEs are already […] Reporting Services [Is this format of reporting possible in SSRS]( - Hi All, I am trying to mimic an excel report in SSRS using VS. Please see the below screen shot. Can I exactly mimic this in SSRS? Will it be a tabular or matrix and how can I get the Qtr1 Qtr2 Qtr3 and Qtr4 fields. I have a date field in the dataset. Your […] [Calculated Field expression is not showing]( - Hi All, I have created few calculated fields like Quarter, month and few others. I have saved the report. This I created using VB Studio. When I logged back in I can see the calculated fields but I do not see the "fx" expression editor. Any idea what might have happened? Thanks General [Add custom toolbar to SSMS]( - Hi all  I'm fairly certain I've done this before but can't figure it out.....  99% certain of our work is in SSMS. We do, however, use a couple of PowerShell scripts and it's getting annoying to have to go to the scripts and run them outside of SSMS. I want to add a […] [Add custom toolbar to SSMS]( - Hi all  I'm fairly certain I've done this before but can't figure it out.....  99% of our work is in SSMS. We do, however, use a couple of PowerShell scripts and it's getting annoying to have to go to the scripts and run them outside of SSMS. I want to add a custom […] Powershell [Pase keywords in text string]( - I've been trying to find an example to parse a record that looks for a Beginning keyword then based on that finds another keyword on the same line then pulls the next x values that are quoted. example: $data = @" this is a sample cstsums record with Values('xxxx','ppppp','45gheeet','pperere') $data = @" this is a […] Integration Services [Buffer failed]( - I am fairly new to SSIS and working on executing the existing package which is very complex. The last step of this package executes a child package, which reads the data from the source, adds some logic, and gets the data into the staging. All the steps are running fine except when the last step […] SQL Saturday and User Group Organizers [SQL Saturday Pittsburgh 2024 (#1094) - Call for speakers and other event details]( - Please see the following link. Note that the "Call for Speakers" is in-progress and ends on 31 July 2024. (See the clickable link on the page above. With some luck, one of the sessions I submitted will be selected and I'll "make the trip" to Pittsburgh! Events [SQL Saturday Pittsburgh 2024 (#1094) - Call for speakers and other event details]( - Please see the following link. Note that the "Call for Speakers" is in-progress and ends on 31 July 2024. (See the clickable link on the page above. With some luck, one of the sessions I submitted will be selected and I'll "make the trip" to Pittsburgh! SQL Server 2022 - Development [Updated Table Not Displaying Data]( - I have a table that contains data only to Financial Year/FY 2024: CREATE TABLE [Prod].[IMETA - Calendar Days Data_Table_Temp]([Date] [datetime] NULL,[FY] [nvarchar](255) NULL,[Period] [nvarchar](255) NULL,[Quarter] [nvarchar](255) NULL,[Day] [float] NULL,[Month] [float] NULL,[Year] [float] NULL,[Loaddate] [datetime] NULL) ON [PRIMARY]GO  New table: CREATE TABLE [Prod].[IMETA - Calendar Days Data_Table_Other]( [Date] [datetime] NULL, [FY] [nvarchar](255) NULL, [Period] [nvarchar](255) […] [TSQL Help, Possible a recursive CTE]( - Hi I have 2 tables Table A JoiningID, MainID 1010619, 646703 991840, 238649 991840, 577578 991840, 222063 991840, 564824 991840, 223543 Table B MainID, JoiningID 646703, 991840 675515, 1010619 These tables are obviously a lot bigger with lots of sets of IDs, this is just one example of where there is a relationship and the […] [Calendar & Fiscal Year Table]( - I have a Calendar table that need to be displaying Fiscal Start and End Date as in below: The Calendar is currently have data for years 2023 - 2028: -- Calculate the number of days per year in the IMETA_Calendar table SELECT YEAR([Date]) AS [Year], COUNT(*) AS [NumberOfDays] FROM [Prod].[IMETA_Calendar] GROUP BY YEAR([Date]) ORDER BY […]   [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -