Sites anglophones


SQL SERVER – Msg 1842 – The File Size, Max Size Cannot be Greater Than 2147483647 in Units of a Page Size

Publié le 19 mars 2020 sur journey to sqlauthority
 

One of my clients contacted me for assistance with whom I worked earlier to perform a Comprehensive Database Performance Health Check. They were running a job in SQL Agent and it was failing with error – Could not allocate space for object …

Verifying Object Exists and Dropping Object with One Statement

Publié le 19 mars 2020 sur sqlservercentral.com
 

The post Verifying Object Exists and Dropping Object with One Statement appeared first on SQLServerCentral.

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 …


Pages :