Sites anglophones


SQL SERVER – Installation Error: 25641- For target, “package0.event_file”, the parameter “filename” passed is invalid. Target parameter at index 0 is invalid

Publié le 9 octobre 2019 sur journey to sqlauthority
 

While installing SQL Server 2012 in a client environment, they faced an interesting error about for target. Here is the information that is taken from SQL Server ERRORLOG. If you don’t know how to find Errorlog, please refer to my earlier blog. S …

Getting Started with SQL Server Azure Container Instances ACI

Publié le 9 octobre 2019 sur sqlservercentral.com
 

The post Getting Started with SQL Server Azure Container Instances ACI appeared first on SQLServerCentral.

SQL Compare 14 now available on Linux

Publié le 9 octobre 2019 sur sqlservercentral.com
 

The post SQL Compare 14 now available on Linux appeared first on SQLServerCentral.

T-SQL Tuesday #119 Changing Your Mind

Publié le 8 octobre 2019 sur sqlskills.com - glen berry
 

This post is a response to this month’s T-SQL Tuesday #119 prompt by Alex Yates.  T-SQL Tuesday is a way for the SQL Server Community to share ideas about different database and professional topics every month. This month’s topic asks …

Establishing a DevOps Organisation

Publié le 8 octobre 2019 sur simple-talk.com
 

The radical pace of development promised with DevOps can make some people nervous, especially if they have spent years with the waterfall development model. The very first question that comes to mind is: How do you expedite your development withou …

SQL SERVER Tools I Use and Recommend (Updated: October 2019)

Publié le 8 octobre 2019 sur journey to sqlauthority
 

I just returned from the long road trip to teach 21 SQL Server Performance Tuning Scripts Course. One of the most popular questions, I had received what tools I use personally when I work with SQL Server. Though I had answered them during the training …

Integrating SQL Server Tools into SQL Change Automation Deployments

Publié le 8 octobre 2019 sur sqlservercentral.com
 

The post Integrating SQL Server Tools into SQL Change Automation Deployments appeared first on SQLServerCentral.

Implementing SQL Server Integration Services with Azure Data Factory

Publié le 8 octobre 2019 sur sqlservercentral.com
 

The post Implementing SQL Server Integration Services with Azure Data Factory appeared first on SQLServerCentral.

How to Think Like the SQL Server Engine

Publié le 7 octobre 2019 sur brentozar.com
 

You’re a developer or a DBA, and you’re comfortable writing queries to get the data you need. You’re much less comfortable trying to design the right indexes for your database server. In the next several posts, you’ll learn: The …

SQL and Scope

Publié le 7 octobre 2019 sur simple-talk.com
 

One of the first successful programming languages was a relatively simple one named FORTRAN. This was short for “FORmula TRANSlator,” and it attempted to look as much like algebra as it could. The first version of this language had only two …

SQL SERVER – Modifying Table Used In SCHEMABINDING View

Publié le 7 octobre 2019 sur journey to sqlauthority
 

While I enjoy working on the Comprehensive Database Performance Health Check, I often love answering the question about blog posts as well. Just earlier I posted about What is SCHEMABINDING in SQL Server Views? and I received a very interesting questio …

How to Use Parameters in PowerShell

Publié le 7 octobre 2019 sur sqlservercentral.com
 

The post How to Use Parameters in PowerShell appeared first on SQLServerCentral.

6 steps to a more secure SQL database

Publié le 7 octobre 2019 sur sqlservercentral.com
 

Security is often something people think about only after they have had a problem. Given that the average cost of a data breach is $3.92 million (SecurityIntelligence 2019) and ransomware attacks have increased 97% over the past 2 years (PhishMe 2019), …

DevOps Self-Service for Databases with SQL Clone

Publié le 7 octobre 2019 sur sqlservercentral.com
 

The post DevOps Self-Service for Databases with SQL Clone appeared first on SQLServerCentral.

What is SCHEMABINDING in SQL Server Views? – Interview Question of the Week #245

Publié le 6 octobre 2019 sur journey to sqlauthority
 

Question: What is SCHEMABINDING in SQL Server Views?Answer: SCHEMABINDING keywords prevent tables used in the views to make any such modifications that can affect the view’s definition.When this keyword is used in the view it binds the view to th …


Pages :