Sites anglophones

Representing XML data in SQL Server

Publié le 7 août 2018 sur

In this article, we will see how to use the FOR XML statement in SQL Server to represent the result of queries in XML format.

Steps to Migrate Oracle Database to Azure SQL Database

Publié le 7 août 2018 sur

In the world of paradigm shifts, many organizations are looking at the prospect of a technology migration, where capabilities are moved to a new set of technologies, supporting and enabling the business for the future. On other hand, a technology or pl …

Join Redgate’s SQL data catalog early access program

Publié le 7 août 2018 sur

Redgate wants your help to develop a product for SQL Server data classification that meets today’s compliance and DevOps needs. If you’re interested in taking part in research and providing feedback on new releases, please register for the …

SQL SERVER – Setting ARITHABORT ON for All Connecting .Net Applications

Publié le 7 août 2018 sur journey to sqlauthority

Readers of this blog post are aware of SQL Server Expert Tim Cartwright, who has previously written an enhanced version of How to Generate Random Password script. Here is another very interesting find by Tim on the subject of ARITHABORT ON se …

Two Important Differences Between SQL Server and PostgreSQL

Publié le 6 août 2018 sur

SQL ConstantCare® uses PostgreSQL as a back end – specifically, AWS RDS Aurora – so I’ve spent a lot of time writing Postgres queries lately. Here are some of the things I’ve noticed that are different. CTEs are optimiz …

The ‘Right to be Forgotten’ and Data Masker for SQL Server

Publié le 6 août 2018 sur

The right to be forgotten is one of the main features of new data protection legislation across the globe. Under Article 17 of one such piece of legislation in Europe, the GDPR, individuals have the right to have personal data erased from all systems a …

SQL Server Data Table as CRM Data Source on VBA Form

Publié le 6 août 2018 sur

Using SQL SERVER Database as Data Source FOR MS Access VBA Switchboard and Data Entry Form. I am presenting, once again, a method of connecting and upgrading a SQL data source into a VBA presentation process.

How to Successfully Deliver IT Projects in a Not-so-Agile Organization

Publié le 6 août 2018 sur

Agile methodology for software delivery is accepted at many organizations but is not used everywhere. In this article, Mohammad Rizvi gives advice on how to successfully implement a software project in a non-Agile environment. How to fix SQL Server dis …

SQL SERVER – Unable to Load User-Specified Certificate [Cert Hash(sha1) “”]. The Server Will Not Accept a Connection

Publié le 6 août 2018 sur journey to sqlauthority

While preparing for a security demo, I broke my SQL Server and was unable to start it. In this blog, we would lean about fixing error Unable to load user-specified certificate. Whenever I run into SQL startup trouble, I always start from SQL Server ERR …

[Video] Office Hours 2018/8/1 (With Transcriptions)

Publié le 5 août 2018 sur

This week, Erik and Richie discuss monitoring tools, finding all unused tables across databases, query tuning, deleting vs hanging on to indexes, sharding databases, query editors, aggressively-locked indexes, why a plan would not be in the plan cache, …

How to Identify Process ID for SQL Server Services? – Interview Question of the Week #185

Publié le 5 août 2018 sur journey to sqlauthority

Question: How to Identify Process ID for SQL Server Services? Answer: I was recently asked this question during the Comprehensive Database Performance Health Check. Let us see a quick script which returns the process id for SQL Server Services. SE …

SQL SERVER – ERROR: Failed to verify the Authenticode signature of FileName

Publié le 4 août 2018 sur journey to sqlauthority

Sometimes there is some malware which would do changes on the machine which is impossible to track. Most of the time, based on my interactions with various clients, we need to format and rebuild the OS because you never know what data is getting compro …

The Crimes of Chicago: Working with Data in MongoDB

Publié le 3 août 2018 sur

Why bother with MongoDB? Although MongoDB is not yet, to my eye, an obvious choice for processing enterprise-level data, it has a useful role in the enterprise. It can be a powerful tool for automating the process of getting hold of data and transformi …

Azure SQL Database Managed Instance: Easing the Move from On Premise to Cloud

Publié le 3 août 2018 sur

Azure SQL Database Managed Instance promises to fill a significant gap for customers looking to lift and shift applications backed by SQL Server from on premise to cloud.

How to Check Performance on a New SQL Server

Publié le 3 août 2018 sur

So you just built a brand new SQL Server, and before you go live, you wanna check to see if it’s going to perform as well as your existing server. The easy way: test your maintenance jobs I’m just asking for the chance to test it, that …

Pages :