Sites anglophones


Build and fill a SQL Server Database using SQL Compare CLI and a Batch Script

Publié le 19 mars 2020 sur sqlservercentral.com
 

The post Build and fill a SQL Server Database using SQL Compare CLI and a Batch Script appeared first on SQLServerCentral.

Restore SQL Server database using data management provider REST API

Publié le 19 mars 2020 sur sqlservercentral.com
 

The more SQL Server instances we need to manage, the easier it gets relying on third-party tools to complete our daily tasks. However, this brings another problem, that is, integrating with any application through the interfaces they provide. A ve …

Free Fundamentals of Query Tuning Week: Part 3, How Parameters Influence Cached Plans

Publié le 18 mars 2020 sur brentozar.com
 

While you practice physical distancing (words I never thought I’d daisy-chain together), I’m giving away free SQL Server training. So far, we’ve covered building a query plan and how to find the right queries to tune. Make sure to kee …

SQL SERVER – Why Server Authentication is Disabled? What Mode is SQL Server Using Currently?

Publié le 18 mars 2020 sur journey to sqlauthority
 

Sometimes I see weird issues with SQL Servers, and it helps me in understanding how the software works. In this blog, I would share my learning about the cause of Server Authentication mode disabled. If it is disabled, how would you know what mode is u …

Never Create Columns with ANSI_PADDING set to OFF

Publié le 18 mars 2020 sur sqlservercentral.com
 

The post Never Create Columns with ANSI_PADDING set to OFF appeared first on SQLServerCentral.

Securely Manage Database Credentials Using Visual Studio Manage User Secrets

Publié le 18 mars 2020 sur sqlservercentral.com
 

The post Securely Manage Database Credentials Using Visual Studio Manage User Secrets appeared first on SQLServerCentral.

The Staging Phase of Deployment

Publié le 17 mars 2020 sur simple-talk.com
 

Staging is a vital part of doing the deployment of any application, particularly a database quickly, efficiently, and with minimum risk. Though vital, it only gets noticed by the wider public when things go horribly wrong. On 2nd February 1988, We …

Free Fundamentals of Query Tuning Week: Part 2, How to Find the Right Queries to Tune

Publié le 17 mars 2020 sur brentozar.com
 

Well, it turns out that toilet paper doesn’t cure the coronavirus, so during the quarantines, I’m giving away free training. Yesterday, I kicked off the Fundamentals of Query Tuning class with the first module, building a query plan. Make s …

SQL SERVER – LogonUserExEx Fails for User & GetToken – Logging on as the CNO Failed With Error 1326

Publié le 17 mars 2020 sur journey to sqlauthority
 

SQL Always-On feature is so tied to cluster that sometimes you would need to look at various logs to fix a failure. In this blog I would share my learning about fixing error LogonUserExEx fails for user & GetToken – Logging on as the CNO fail …

Fetch Web Data in Power BI

Publié le 17 mars 2020 sur sqlservercentral.com
 

Introduction Reporting on web data has been a fascinating part of developing any dashboard or reports in Power BI. Often this data is available either free that can be consumed anonymously or by using some kind of authentication mechanism. In this arti …

Spring discount on health checks for new clients

Publié le 16 mars 2020 sur sqlskills.com - paul randall
 

  It’s Spring on Saturday so it’s a perfect time to ensure your SQL Server instances are configured correctly and performing well. For all new clients, we’re dropping the price of our signature health check down to US$2,495 …

Working From Home…with Kids

Publié le 16 mars 2020 sur SQLSkills.com - Erin Stellato
 

Before I worked for SQLskills, I worked for a software company, Hyland Software.  One of the best things about working at Hyland was the Child Enrichment Center (CEC).  It was a day care until the kids were about 3, and then it was Montessori …

Free Fundamentals of Query Tuning Week: Part 1, Building a Query Plan

Publié le 16 mars 2020 sur brentozar.com
 

Well, that escalated quickly, huh? Just a few short months ago, we were all making plans about what we wanted to learn in 2020. We sketched out our goals, our conference plans, maybe even how we wanted to do our first user group presentations or SQL Sa …

SQL SERVER – PolyBase Error Msg 46530 – External Data Sources Are Not Supported With Type GENERIC

Publié le 16 mars 2020 sur journey to sqlauthority
 

While trying to try PolyBase on my laptop, I was getting an error. When I looked further, the solution was so different and the error message has no relation to it. In this blog, I would share my findings of error Msg 46530 – External data source …

Overview of Azure Cache for Redis

Publié le 16 mars 2020 sur sqlservercentral.com
 

The post Overview of Azure Cache for Redis appeared first on SQLServerCentral.


Pages :