Copilot Reminded Me How To Find a File Handle
SQLServerCentral Blog
by Steve Jones - SSC Editor
3h ago
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 had this folder locked. I know there are ways to do this, but I decided to ask Copilot how to do this. I did this in the Edge browser, since that’s the easy thing. Note: I was actually on Windows 10, not 11. I got this response. I then hit Ctrl+Shift+Esc and got the Task Manager. From there, I can see Resource Monitor at the bottom of the Performance tab. I opened this and it started in the CPU tab. I typed in the name of my folder ..read more
Visit website
Planview Portfolios REST API with ADF – Retrieving Actual Data
SQLServerCentral Blog
by Koen Verbeeck
1d ago
In the introduction of this blog post series, I explained the use case: extracting data from the Planview Portfolios REST API using Azure Data Factory. Any tool that can send HTTPS requests can work with the REST API, but our focus here is ADF (which can also be Synapse Pipelines or Fabric Pipelines). In the previous parts, I fetched the list of project IDs from an OData feed in the Lookup Activity and I fetched the access token with a Web Activity. In this last part, we’re going to look over the project IDs and for each ID, we’re going to fetch the related work from a REST API endpoint using ..read more
Visit website
Planview Portfolios REST API with ADF – Fetching the Access Token
SQLServerCentral Blog
by Koen Verbeeck
1d ago
In the introduction of this blog post series, I explained the use case: extracting data from the Planview Portfolios RESET API using Azure Data Factory. Any tool that can send HTTPS requests can work with the REST API, but our focus here is ADF (which can also be Synapse Pipelines or Fabric Pipelines). In the second part, I explained how to access the OData service of Planview Portfolios, which returns a list of the projects and their IDs. In this part, we’ll focus on fetching the OAuth access token needed for authentication. The swagger page gives us the following information about the OAuth ..read more
Visit website
Planview Portfolios REST API with ADF – The OData Feed
SQLServerCentral Blog
by Koen Verbeeck
1d ago
In the introduction, I explained the setup of the use case and why we need to use the OData feed: to get the list of Project IDs, because the REST API doesn’t have an endpoint for this. Weird, right? In this part of the series, we’ll dive into the Lookup activity, which uses the OData feed to get the list we need. First, we need to create a new Linked Service: The URL of the OData feed takes the following format: https://myaccount.pvcloud.com/odataservice/odataservice.svc The tricky part is accessing the OData feed. There are two options for authentication: You either have a username and ..read more
Visit website
Extracting Data from the Planview Portfolios REST API using ADF – Introduction
SQLServerCentral Blog
by Koen Verbeeck
1d ago
I have a client using Planview Portfolios to manage their PMO. As part of the data warehouse, we want to extract the project data from the Planview REST API. There are other methods to get data, such as using OData (which is used in the Power BI connector), SOAP Web Services (2005 called) and a query engine. A bit more info on the last option: Planview runs on a SQL Server database (not sure what kind and what version) and it’s possible for people with the correct permissions to write queries and extract the results. In our case, we decided to try the REST API. It is fairly well documented (yo ..read more
Visit website
How important is having great soft skills as a Software Engineer for personal growth and career…
SQLServerCentral Blog
by Adetokunbo Ige
2d ago
How important is having great soft skills as a Software Engineer for personal growth and career success As an Engineer, I would like to understand what I need to do to ensure that my soft skills are equally as good as my technical skills. Technical skills are the fundamental requirements for engineers; however, soft skills also plays a vital role in the career success, advancement and effectiveness in a working environment. In the modern workspace having adequate soft skills is becoming very vital for career success and personal growth. Soft skills are now becoming a distinguishing fact ..read more
Visit website
Master Advanced SQL: 2 Essential Courses for Every Data Analyst
SQLServerCentral Blog
by Tracy McKibben
2d ago
If you're a data analyst, you already know that SQL isn't just a nice-to-have skill – it's the bedrock of your work. But let's face it, SQL isn't a "learn it once and you're done" kind of language. It's constantly evolving, and so are the challenges we face with data. That's where continuing education comes in. And I'm not talking about those generic SQL tutorials; I'm talking about courses that take you deep into the advanced techniques that make data sing. So, what are the best advanced SQL courses out there, specifically designed for data analysts who are ready to level up? Let's dive into ..read more
Visit website
A New Word: Insoucism
SQLServerCentral Blog
by Steve Jones - SSC Editor
2d ago
insoucism – n. the inability to decide how much sympathy your situation really deserves, knowing that so many people have it far worse and others far better, that some people would need years of therapy to overcome what you have, while others would barely think to mention it in their diary that day. I really struggle to think I deserve sympathy for the challenges I might face in life. I know that I am very lucky and blessed in life, without many of the struggles that people who have less than I experience. I know that most of the time I have #firstworldproblems, which aren’t really problems, b ..read more
Visit website
ERD Your Existing Databases
SQLServerCentral Blog
by hellosqlkitty
4d ago
Photo by Hanna Morris on Unsplash There are several tools out there to make your life easier by creating an ERD for your existing db. Everything works pretty well when you have a small number of tables with FKs mapped, but when the number gets bigger, the diagram naturally gets a lot messier. Here are some of the ones I tried. Table of Contents Free Tools SQL Server Management Studio (SSMS) Azure Data Studio (ADS) Web Based Tools Lucid draw.io Other web ones that didn’t work well Tools That Aren’t Free Dataedo dbForge DBeaver Free Tools SQL Server Management Studio (SSMS) It’s qu ..read more
Visit website
AI World
SQLServerCentral Blog
by Vinay Thankur
5d ago
this month is the big month and a month to remember their are so many announcements has been done in this month – May -2024 . As this is NVIDIA era of AI revolution has done due to high speed … The post AI World appeared first on SQLServerCentral ..read more
Visit website

Follow SQLServerCentral Blog on FeedSpot

Continue with Google
Continue with Apple
OR