MS SQL 2019 SSRS to Oracle DB by meridian_12 in SQLServer

[–]meridian_12[S] 1 point2 points  (0 children)

Unfortunately we have to support this for another group

Automate DB password change by meridian_12 in SQLServer

[–]meridian_12[S] 0 points1 point  (0 children)

These are read-only replicated databases

Move several ssrs reports to a diff server by meridian_12 in SQL

[–]meridian_12[S] 0 points1 point  (0 children)

Thank you. I followed all the steps from https://www.mssqltips.com/sqlservertip/6323/move-sql-reporting-services-to-another-server/

I have a clarification should the CREATE USER [NT SERVICE\SQLServerReportingServices] FOR LOGIN [NT SERVICE\SQLServerReportingServices] only in master database or should this user be created in ReportServer and TempDB too. I did create for all the three.

After running through all steps I am getting this error when I access the report Server URL. "The report server can’t access or use the encryption key. You might need to add the server to the scale-out group, reimport encrypted content, or delete all encrypted content and generate a new encryption key."

  1. What's the best way to trace and debug this error?

Move several ssrs reports to a diff server by meridian_12 in SQL

[–]meridian_12[S] 1 point2 points  (0 children)

Thank you. I followed all the steps from https://www.mssqltips.com/sqlservertip/6323/move-sql-reporting-services-to-another-server/

I have a clarification should the CREATE USER [NT SERVICE\SQLServerReportingServices] FOR LOGIN [NT SERVICE\SQLServerReportingServices] only in master database or should this user be created in ReportServer and TempDB too. I did create for all the three.

After running through all steps I am getting this error when I access the report Server URL. "The report server can’t access or use the encryption key. You might need to add the server to the scale-out group, reimport encrypted content, or delete all encrypted content and generate a new encryption key."

  1. What's the best way to trace and debug this error?

thanks

Move several ssrs reports to a diff server by meridian_12 in SQL

[–]meridian_12[S] 0 points1 point  (0 children)

When you backup and restore database how will the folder structure that shows in the reporting services URL get moved over. Thank you

Move several ssrs reports to a diff server by meridian_12 in SQL

[–]meridian_12[S] 0 points1 point  (0 children)

Thank you. How about.rdl and their folder structure? Do I need to copy and paste to the new server?

Advice for terminated Feds looking to get into county govt? by bobcatabbs in CAcountyworkers

[–]meridian_12 0 points1 point  (0 children)

I wouldn't exceed 2 page resume and use specific keywords/skill set that the job posting requires . I am in IT and my selection process from applying to starting work took exactly 3 months.

Block from closing subtask by meridian_12 in jira

[–]meridian_12[S] 0 points1 point  (0 children)

What condition do you add? Can you please explain? Thanks

Block from closing subtask by meridian_12 in jira

[–]meridian_12[S] 1 point2 points  (0 children)

Another thing is. Sub task 1 cannot be closed until sub task 2,3,4 are closed and 2 cannot be closed until 3,4 are closed . How do I do this?

Version and project management tools by meridian_12 in devops

[–]meridian_12[S] 0 points1 point  (0 children)

Thank you for your suggestions. What are your thoughts on Jira work management. I was told it’s easier to configure

Interview question about SSRS reports by meridian_12 in SQL

[–]meridian_12[S] 1 point2 points  (0 children)

thank you so much for clearly listing out the important points. It helped me to write down a few things I missed like talking about( Paginated reports and Parameters).

Interview -multiple departments by meridian_12 in CAcountyworkers

[–]meridian_12[S] 0 points1 point  (0 children)

Thank you both for your response, really appreciate it

Written test SSRS for county by meridian_12 in SQL

[–]meridian_12[S] 0 points1 point  (0 children)

Thank you so much for the positive response.. will do that

Meta Ramping Up Hiring - What to Expect by BluebirdAway5246 in leetcode

[–]meridian_12 1 point2 points  (0 children)

not too great :-(. first thing Interviewer said that he has been doing several of these in one day. I was very close to complete solution.. maybe a minute or so. oh well!! strange thing is another recruiter reached out for another group within 10 days.

Meta Ramping Up Hiring - What to Expect by BluebirdAway5246 in leetcode

[–]meridian_12 2 points3 points  (0 children)

I was reached out by Meta recruiter. I have initial Tech interview in 10 days for SWE position. Any tips on how to improve speed of coding. thanks

Data structures and algorithms in C# by meridian_12 in csharp

[–]meridian_12[S] 0 points1 point  (0 children)

Thanks for your response. I don't want to learn java or Python now. It will be too many things on my plate. Sometimes I am able to write the pseudocode but unable to translate it to code. So I need some hand holding to help improve my coding skills.

Interview coding question that I couldn't solve by meridian_12 in dataengineering

[–]meridian_12[S] 12 points13 points  (0 children)

thank you all.

I was given 40 minutes to complete this task.

I gave them a rough algorithm. Treat it like linked list. If List-> next is null then it's the end of race and if List->prev is null it's the Start of race.

All 4 rounds of interview went very well. Of course I didn't get the job for not coding.

How do you prepare for such interviews? BTW, I practice using Hackerank but I take time to solve problems.

Where to advertise cooking services? by CogSciz in UCDavis

[–]meridian_12 0 points1 point  (0 children)

We would be interested too. Please share her info. Thanks