Microsoft Office, MS Open XML detect macros

Do MS Open XML files need the vbaData.xml file and events declarations with the <wne:docEvents> tag and child <wne:eventDoc(Open|New|Close...)> for a macro in the embedded project vbaProject.bin to run correctly using a <wne:mcd wne: macroName...> tag

or

if this xml code <wne:eventDoc> is not present and that the source code VBA, the Execode or the P-Code contains the procedure for the macro in vbaProject.bin and only <wne:mcd wne: macroName...> xml it is still executed ?

I did some analysis and it seems that this tag is required but there may be other conditions where this is not the case, do you have an idea ? thank you.

Can one use a certificate directly from Microsoft Azure Key Vault for LDAP/S?

The only method I can seem to find to add a certificate for secure LDAP (LDAP/S) for Azure Active Directory Domain Services is to upload the certificate from my local computer. This seems like a very poor key management solution when Microsoft Azure Key Vaults is available for creating and storing key pairs and certificates. Am I missing something? Is there a way to directly use a certificate and key pair from a Key Vault or must I download these from a Key Vault and then upload them for LDAP/S? Best PKI practices dictate that I never access the private key directly.

Transferring Microsoft SmartScreen reputation to renewed certificate

I know that even a software signed with a new code signing certificate triggers Microsoft SmartScreen warning (“Windows Defender SmartScreen prevented an unrecognized app from starting”), until the certificate builds a reputation:
Smart-Screen filter still complains, despite I signed the executable, why?

But we are signing our software (WinSCP) with DigiCert code signing certificate for years. It is a plain certificate, no EV.

As our certificate is expiring soon, we have renewed it. But now, our software signed with the renewed certificate triggers the Microsoft SmartScreen warning.

Is that expected? Is the reputation really not transferred to the renewed certificate? If not, what does it take to build the reputation again? The new version of our software (signed with the renewed certificate) is out for few days already, has tens of thousands of installations, but still triggers the warning. Or is there a way to help the reputation to transfer somehow?

Microsoft Word Security Warning for Signed VBA Project

I am attempting to setup signed VBA Projects so that I can find the right balance between security and useability.

Currently my end users are instructed to just hit “Enable Content” on Microsoft Office to allow running of the Macro’s.

enter image description here

Obviously this is a security issue as it’s a blind approval, they should in fact be told to never hit “Enable Content” and the goal is that Word will automatically run the documents because the VBA Projects are digitally signed.

I have made a cert using “SelfCert.exe”. Imported it into the “Trusted Root”. It shows as trused. I opened VB Edited and applied this to my document, changed Word Trust Security Center settings to “Disable all except digitally Signed”. But, I still get the warning and can’t figure it out. Is this a glitch? Am I doing something wrong? Looking for help from somebody with experience with this issue.

enter image description here enter image description here

What is the impact of starting Microsoft SharePoint Foundation Web Application Service in Application Server?

I have a SharePoint 2013 server farm with 4 SharePoint servers (2 web front end and 2 application servers) + 1 SQL server.

I have a custom SharePoint solution which can be deployed globally. When I deploy this solution using either Central Admin or STSADM.EXE or Powershell, I am seeing that the solution is being in “Deploying” state for some time and then it is changed to “Not Deployed” state.

When I open the solution from Central Administration, it says that solution is successfully deployed to 3 servers and fourth server (one of the application servers) is not listed there and there is no error message.

“Microsoft SharePoint Foundation Web Application” service is not running in both the Application Servers but the solution is being deployed to one of the application servers.

Can I start “Microsoft SharePoint Foundation Web Application” service in both the Application Servers? What is the impact of running this service in application servers?

or is there anything else that I can do without starting this service in application servers?

Thanks in Advance.

¿Como eliminar las tablas que no le pertenezcan a una base de datos en un TreeView? c# Windows Forms, Microsoft SQL Server

Resulta que tengo un TreeView que me muestra todas las bases de datos que hay con sus respectivas tablas. El problema como verán es que me aparecen tablas a las que le pertenecen a una base de datos pero que tambien les aparecen en otras, lo cual está mal.

introducir la descripción de la imagen aquí

Y lo que quiero es que me muestren nomas las tablas a las que les pertenecen la base de datos únicamente.

       TreeNode node;     TreeNode hijo;     private void Form1_Load(object sender, EventArgs e)     {         DataTable tabla = new DataTable();         DataTable tablas = new DataTable();          ReglasDeNegocios.OperacionesBD operaciones = new ReglasDeNegocios.OperacionesBD();         if (operaciones.BaseDatos(sUsuario, sPassword, ref tabla))         {               foreach (DataRow dr in tabla.Rows)             {                 node = new TreeNode(dr["name"].ToString());                 string hijos = Convert.ToString(dr["name"].ToString());                 if (operaciones.BaseDatos(sUsuario, sPassword, hijos, ref tablas))                 {                     foreach (DataRow dr2 in tablas.Rows)                     {                          hijo = new TreeNode(dr2["Tabla"].ToString());                         node.Nodes.Add(hijo);                     }                     treeView1.Nodes.Add(node);                 }              }             }         else         {              MessageBox.Show("Ocurrio un error: " + operaciones.sLastError);         }     } 

Asi mando a llamar la BaseDatos:

  public Boolean BaseDatos(String sUsuario, String sPassword, String BD, ref DataTable Tabla)     {         Boolean bAllOk = false;         using (SqlConnection conexion = new SqlConnection())         {             try             {                  conexion.ConnectionString = $  "Server=ROBERTODIAZ; User Id={sUsuario}; Password={sPassword}";                 conexion.Open();                 SqlCommand comando = new SqlCommand($  "use {BD} select sc.name+'.'+tb.name AS Tabla from sys.tables tb inner join sys.schemas sc on tb.schema_id = sc.schema_id order by Tabla ASC", conexion);                 SqlDataAdapter adapter = new SqlDataAdapter(comando);                 adapter.Fill(Tabla);                   bAllOk = true;              }             catch (Exception ex)             {                 sLastError = ex.Message;             }             finally             {                 conexion.Close();             }         }         return bAllOk;     } 

¿Como solucionarían esto?

Microsoft Surface Laptop – will keyboard support be added to Ubuntu?

My apologies for my lack of knowledge on how hardware support gets added to distros and the kernal.

I have a first gen MS Surface laptop (actual ‘Laptop’ not pro or go, etc.). When I run the Ubuntu live everything works, as far as I can tell, except the built in keyboard. Since this laptop is several years old I was wondering if this will ever work? I’ve installed various linux systems on laptops and have had things like cameras not work but I’ve never had something as basic as the keyboard not work.

I’ve seen the jakeday kernal work but because I lack this level of system build knowledge I’m worried about things like security and also what that means for future upgrades. Again… this is more on me than jakeday’s work.

So long question shortened… for my Surface Laptop keyboard to work.. Be Patient or stay with windows/buy new laptop?

Thank you

Using Enterprise keywords in a Microsoft Word Content Type template

Is it possible to add the Enterprise keywords field to your Word template so a user can fill in keywords during initial creation of his Word document?

I’ve created a document library and added extra property fields. I’ve also added custom content types (Word documents). And in those documents I’ve added my custom fields through “Insert > Quick Parts > Document property” so that a user can complete these fields inside the document. This works for all custom fields except for the enterprise keywords. I can complete the field in Word. But after saving this field doesn’t get synced to the library and the results are not visible in SharePoint.

Please ask if you require more information.