Using Temp Tables in Azure Data Studio Notebooks

tl;dr I want to use temp tables across multiple cells in a Jupyter Notebook to save CPU time on our SQL Server instances.

I’m trying to modernize a bunch of the monitoring queries that I run daily as a DBA. We use a real monitoring tool for almost all of our server level stuff, but we’re a small shop, so monitoring the actual application logs falls on the DBA team as well (we’re trying to fix that). Currently we just have a pile of mostly undocumented stored procedures we run every morning, but I want something a little less arcane, so I am looking into Jupyter Notebooks in Azure SQL Data Studio.

One of our standard practices is take all of the logs from the past day and drop them into a temp table, filtering out all of the noise. After that we run a dozen or so aggregate queries on the filtered temp table to produce meaningful results. I want to do something like this:

Cell 1

Markdown description of the loading process, with details on available variables 

Cell 2

T SQL statements to populate temp table(s) 

Cell 3

Markdown description of next aggregate 

Cell 4

T SQL to produce aggregate 

The problem is that, it seems, each cell is run in an independent session, so the temp tables from cell 2 are all gone by the time I run any later cells (even if I use the “Run cells” button to run everything in order).

I could simply create staging tables in the user database and write my filtered logs there, but eventually I’d like to be able to pass off the notebooks to the dev teams and have them run the monitoring queries themselves. We don’t give write access on any prod reporting replicas, and it would not be feasible to create a separate schema which devs can write to (for several reasons, not the least of which being that I am nowhere near qualified to recreate tempdb in a user database).

Logging to Sharepoint on Premises using C# from Visual Studio Word Addon

Please help. We have Sharepoint on premises 2016. My user is domain user. So I can go there by the web. But I am trying to connect via C#. My code is:

ClientContext context = new ClientContext("https://something.something/prok/Shared%20Documents");  ICredentials credentials = System.Net.CredentialCache.DefaultNetworkCredentials; // orCredentialCache.DefaultCredentials context.Credentials = credentials; System.Net.NetworkCredential("vladislav.zautin", passWord);          context.AuthenticationMode = ClientAuthenticationMode.Default;                 Web web = context.Web;                 context.Load(web);                 context.ExecuteQuery();                 Label label1 = new Label();                 label1.Text = web.Title; 

But I ceep getting error:

System.Net.WebException   HResult=0x80131509   Message=The remote server returned an error: (403) Forbidden. System.Net.WebException: 'The remote server returned an error: (403) Forbidden.'   Source=<Cannot evaluate the exception source>   StackTrace: <Cannot evaluate the exception stack trace>  

Our server has two types of login: 1. AD (which I am trying to use by default login) 2. Security token service.

como puedo migrar mi app a x64 bits en android studio

Como bien ya deben saber Google Play decidio que a partir del 1 de agosto toda app debe ser compatible con dispositivos de 64 bits por lo que si quieres actualizar o publicar una app debe ser compatible, eh ahi mi problema no encuentro la manera de habilitar las librerias a 64bis, al analizar mi app solo me muestra librerias lib/armeabi-v7a y lib/x86.

ya intente agregar a build-gradle la siguiente linea ndk.abiFilters ‘armeabi-v7a’,’arm64-v8a’,’x86′,’x86_64′

pero después de volver a analizar aun me sigue mostrando estas librerias “lib/armeabi-v7a y lib/x86” porfavor agradeceria que puedan ayudarme con este problema, ya que si no logro habilitar las librerias 64bits no podre actualizarlas, si necesitan mas datos con gusto se los facilito.

De antemano muchas gracias.

Canvas doesn’t work on CLIP STUDIO

I’ve installed Clip Studio Paint using both playonlinux and wine, but in both cases i can’t use the pen/eraser tools, as the program won’t recognize them. Other tools like the bucket and line tool work well, but any type of brush doesn’t.

I asked on the wine forum to no avail, and i’m not sure what’s causing this problem. The bug appears to be “fixed” on the bug reports,despite me having encountered it in the latest version.

The tablet seems to work flawlessly on MyPaint.

Error Android Studio no puedo ni debuggear

Estaba haciendo una aplicación usando Retrofit, Room, MVVM y todo un poco. El problema ha estado que en un principio estaba recibiendo un NPE porque no había instanciado el repositorio, y cuando he lo he hecho, la aplicación se queda pillada y por el LogCat muestra una barbaridad de código donde no veo nada claro, os lo paso a ver si os dice algo más:

    at com.example.menunavegacion.ui.fragments.tabs.fragmentpets.viewmodel.PetsViewModel.<init>(PetsViewModel.java:30)         at com.example.menunavegacion.ui.fragments.usecase.LoadJSONUseCase.<init>(LoadJSONUseCase.java:30)         at com.example.menunavegacion.ui.fragments.tabs.PetsRepository.<init>(PetsRepository.java:43)         at com.example.menunavegacion.ui.fragments.tabs.fragmentpets.viewmodel.PetsViewModel.<init>(PetsViewModel.java:30)         at com.example.menunavegacion.ui.fragments.usecase.LoadJSONUseCase.<init>(LoadJSONUseCase.java:30)         at com.example.menunavegacion.ui.fragments.tabs.PetsRepository.<init>(PetsRepository.java:43)         at com.example.menunavegacion.ui.fragments.tabs.fragmentpets.viewmodel.PetsViewModel.<init>(PetsViewModel.java:30)         at com.example.menunavegacion.ui.fragments.usecase.LoadJSONUseCase.<init>(LoadJSONUseCase.java:30)         at com.example.menunavegacion.ui.fragments.tabs.PetsRepository.<init>(PetsRepository.java:43)         at com.example.menunavegacion.ui.fragments.tabs.fragmentpets.viewmodel.PetsViewModel.<init>(PetsViewModel.java:30)         at com.example.menunavegacion.ui.fragments.usecase.LoadJSONUseCase.<init>(LoadJSONUseCase.java:30)         at com.example.menunavegacion.ui.fragments.tabs.PetsRepository.<init>(PetsRepository.java:43)         at com.example.menunavegacion.ui.fragments.tabs.fragmentpets.viewmodel.PetsViewModel.<init>(PetsViewModel.java:30)         at com.example.menunavegacion.ui.fragments.usecase.LoadJSONUseCase.<init>(LoadJSONUseCase.java:30)         at com.example.menunavegacion.ui.fragments.tabs.PetsRepository.<init>(PetsRepository.java:43)         at com.example.menunavegacion.ui.fragments.tabs.fragmentpets.viewmodel.PetsViewModel.<init>(PetsViewModel.java:30)         at com.example.menunavegacion.ui.fragments.usecase.LoadJSONUseCase.<init>(LoadJSONUseCase.java:30)         at com.example.menunavegacion.ui.fragments.tabs.PetsRepository.<init>(PetsRepository.java:43)         at com.example.menunavegacion.ui.fragments.tabs.fragmentpets.viewmodel.PetsViewModel.<init>(PetsViewModel.java:30)         at com.example.menunavegacion.ui.fragments.usecase.LoadJSONUseCase.<init>(LoadJSONUseCase.java:30)         at com.example.menunavegacion.ui.fragments.tabs.PetsRepository.<init>(PetsRepository.java:43)         at com.example.menunavegacion.ui.fragments.tabs.fragmentpets.viewmodel.PetsViewModel.<init>(PetsViewModel.java:30)         at com.example.menunavegacion.ui.fragments.usecase.LoadJSONUseCase.<init>(LoadJSONUseCase.java:30)         at com.example.menunavegacion.ui.fragments.tabs.PetsRepository.<init>(PetsRepository.java:43)         at com.example.menunavegacion.ui.fragments.tabs.fragmentpets.viewmodel.PetsViewModel.<init>(PetsViewModel.java:30)         at com.example.menunavegacion.ui.fragments.usecase.LoadJSONUseCase.<init>(LoadJSONUseCase.java:30)         at com.example.menunavegacion.ui.fragments.tabs.PetsRepository.<init>(PetsRepository.java:43)         at com.example.menunavegacion.ui.fragments.tabs.fragmentpets.viewmodel.PetsViewModel.<init>(PetsViewModel.java:30)         at com.example.menunavegacion.ui.fragments.usecase.LoadJSONUseCase.<init>(LoadJSONUseCase.java:30)         at com.example.menunavegacion.ui.fragments.tabs.PetsRepository.<init>(PetsRepository.java:43)         at com.example.menunavegacion.ui.fragments.tabs.fragmentpets.viewmodel.PetsViewModel.<init>(PetsViewModel.java:30)         at com.example.menunavegacion.ui.fragments.usecase.LoadJSONUseCase.<init>(LoadJSONUseCase.java:30)         at com.example.menunavegacion.ui.fragments.tabs.PetsRepository.<init>(PetsRepository.java:43)         at com.example.menunavegacion.ui.fragments.tabs.fragmentpets.viewmodel.PetsViewModel.<init>(PetsViewModel.java:30)         at com.example.menunavegacion.ui.fragments.usecase.LoadJSONUseCase.<init>(LoadJSONUseCase.java:30) 2019-10-13 14:42:07.743 16797-16797/? E/AndroidRuntime:     at com.example.menunavegacion.ui.fragments.tabs.PetsRepository.<init>(PetsRepository.java:43)         at com.example.menunavegacion.ui.fragments.tabs.fragmentpets.viewmodel.PetsViewModel.<init>(PetsViewModel.java:30)         at com.example.menunavegacion.ui.fragments.usecase.LoadJSONUseCase.<init>(LoadJSONUseCase.java:30)         at com.example.menunavegacion.ui.fragments.tabs.PetsRepository.<init>(PetsRepository.java:43)         at com.example.menunavegacion.ui.fragments.tabs.fragmentpets.viewmodel.PetsViewModel.<init>(PetsViewModel.java:30)         at com.example.menunavegacion.ui.fragments.usecase.LoadJSONUseCase.<init>(LoadJSONUseCase.java:30)         at com.example.menunavegacion.ui.fragments.tabs.PetsRepository.<init>(PetsRepository.java:43)         at com.example.menunavegacion.ui.fragments.tabs.fragmentpets.viewmodel.PetsViewModel.<init>(PetsViewModel.java:30)         at com.example.menunavegacion.ui.fragments.usecase.LoadJSONUseCase.<init>(LoadJSONUseCase.java:30)         at com.example.menunavegacion.ui.fragments.tabs.PetsRepository.<init>(PetsRepository.java:43)         at com.example.menunavegacion.ui.fragments.tabs.fragmentpets.viewmodel.PetsViewModel.<init>(PetsViewModel.java:30)         at com.example.menunavegacion.ui.fragments.usecase.LoadJSONUseCase.<init>(LoadJSONUseCase.java:30)         at com.example.menunavegacion.ui.fragments.tabs.PetsRepository.<init>(PetsRepository.java:43)         at com.example.menunavegacion.ui.fragments.tabs.fragmentpets.viewmodel.PetsViewModel.<init>(PetsViewModel.java:30)         at com.example.menunavegacion.ui.fragments.usecase.LoadJSONUseCase.<init>(LoadJSONUseCase.java:30)         at com.example.menunavegacion.ui.fragments.tabs.PetsRepository.<init>(PetsRepository.java:43)         at com.example.menunavegacion.ui.fragments.tabs.fragmentpets.viewmodel.PetsViewModel.<init>(PetsViewModel.java:30)         at com.example.menunavegacion.ui.fragments.usecase.LoadJSONUseCase.<init>(LoadJSONUseCase.java:30)         at com.example.menunavegacion.ui.fragments.tabs.PetsRepository.<init>(PetsRepository.java:43)         at com.example.menunavegacion.ui.fragments.tabs.fragmentpets.viewmodel.PetsViewModel.<init>(PetsViewModel.java:30)         at com.example.menunavegacion.ui.fragments.usecase.LoadJSONUseCase.<init>(LoadJSONUseCase.java:30)         at com.example.menunavegacion.ui.fragments.tabs.PetsRepository.<init>(PetsRepository.java:43)         at com.example.menunavegacion.ui.fragments.tabs.fragmentpets.viewmodel.PetsViewModel.<init>(PetsViewModel.java:30)         at com.example.menunavegacion.ui.fragments.usecase.LoadJSONUseCase.<init>(LoadJSONUseCase.java:30)         at com.example.menunavegacion.ui.fragments.tabs.PetsRepository.<init>(PetsRepository.java:43)         at com.example.menunavegacion.ui.fragments.tabs.fragmentpets.viewmodel.PetsViewModel.<init>(PetsViewModel.java:30)         at com.example.menunavegacion.ui.fragments.usecase.LoadJSONUseCase.<init>(LoadJSONUseCase.java:30)         at com.example.menunavegacion.ui.fragments.tabs.PetsRepository.<init>(PetsRepository.java:43)         at com.example.menunavegacion.ui.fragments.tabs.fragmentpets.viewmodel.PetsViewModel.<init>(PetsViewModel.java:30)         at com.example.menunavegacion.ui.fragments.usecase.LoadJSONUseCase.<init>(LoadJSONUseCase.java:30)         at com.example.menunavegacion.ui.fragments.tabs.PetsRepository.<init>(PetsRepository.java:43)         at com.example.menunavegacion.ui.fragments.tabs.fragmentpets.viewmodel.PetsViewModel.<init>(PetsViewModel.java:30)         at com.example.menunavegacion.ui.fragments.usecase.LoadJSONUseCase.<init>(LoadJSONUseCase.java:30)         at com.example.menunavegacion.ui.fragments.tabs.PetsRepository.<init>(PetsRepository.java:43)         at com.example.menunavegacion.ui.fragments.tabs.fragmentpets.viewmodel.PetsViewModel.<init>(PetsViewModel.java:30)         at com.example.menunavegacion.ui.fragments.usecase.LoadJSONUseCase.<init>(LoadJSONUseCase.java:30)         at com.example.menunavegacion.ui.fragments.tabs.PetsRepository.<init>(PetsRepository.java:43)         at com.example.menunavegacion.ui.fragments.tabs.fragmentpets.viewmodel.PetsViewModel.<init>(PetsViewModel.java:30) 2019-10-13 14:42:07.743 16797-16797/? E/AndroidRuntime:     at com.example.menunavegacion.ui.fragments.usecase.LoadJSONUseCase.<init>(LoadJSONUseCase.java:30) 

Y así todo el rato en bucle. No paso el extracto completo ya que ni por aquí puedo ya que me salta el limite de caracteres. Si necesitáis algún extracto de código o algo pedídmelo.