(Vitor Pombeiro) In the previous article we manage to import into Azure SQL Database a certificate so we could improve the security of our system.

(Siddharth Mehta) SQL Server 2017 supports execution of R scripts from T-SQL as part of In-Database Machine Learning Services. R is an open-source statistical programming language. R has a very wide community of statistical, mathematical and data science professionals who develop custom R packages a

(Arun Sirpal) A very common requirement which can be satisfied by various tools. Personally I like using Visual Studio 2017 Community Edition and I thought I would do a quick overview of it.

(Denny Cherry) I’ll be honest, when I first learned about SQL Server on Linux, I didn’t get it. It took like an hour for it to make sense to me. After a week of talking to customers, a lot of whom were super interested in deploying SQL Server on Linux or SQL Server in Docker it just makes even more

(Marcin Policht) Azure SQL Database provides a number of benefits that leverage resiliency and redundancy built into the underlying cloud infrastructure. You can take advantage of this functionality in order to perform backup, restore, and failover tasks, which help you recover from human errors, se

(Pinal Dave) I was engaged with a client for an AlwaysOn project and they had some follow-up questions. I took some time to find the answers and encountered an interesting error. I am sharing them here so that others can get benefited. They informed me that they are not able to see and modify listen

(Manvendra Singh) In a previous tip, I explained how to install SQL Server vNext on Red Hat Linux. In this tip, I will explain how to install SQL Server Agent on a Linux server, so we can create SQL Server jobs to schedule repetitive work.

(Pinal Dave) Unique key on a column is used to identify a particular row easily. It is created either by explicitly mentioning it either part of the definition or when defined as Primary key (By default it is unique and not null). Let us learn about special stored procedure sp_special_columns today.

(Kenneth Fisher) I told you not to use NOLOCK even though I use it sometimes.

(CliveW) In my first post on parsing we looked for Eventlog data and parsed the info to get User names from with data in the Event log. Sometimes we want to work with a list of values such as User or Computer names and look for these in the data. Jon once again asked for a little help with an […]