Sites anglophones


SQL SERVER – Free Performance Tuning Videos

Publié le 21 mars 2020 sur journey to sqlauthority
 

Yesterday I wrote a blog post about COVID-19, Working From Home and Performance Tuning and I have received a lot of email responses to this blog post. Also on twitter, lots of people also reached out to me for further conversation. It is indeed interes …

DevOps is Essential for Analytics

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

The term DevOps was coined in the early 2000s to improve the speed and resiliency of the delivery of features and applications and providing more value to customers. It’s not about any particular technology, methodology, or toolset, but automatio …

Free Fundamentals of Query Tuning Week: Part 5, Common T-SQL Anti-Patterns

Publié le 20 mars 2020 sur brentozar.com
 

While you play Chopped with the ingredients in your cupboard (“Today’s ingredients are rice, beans, and hand sanitizer”), I’m giving away free training. So far, we’ve covered building a query plan, how to find the right qu …

COVID-19, Working From Home and Performance Tuning

Publié le 20 mars 2020 sur journey to sqlauthority
 

I am sure you have enough information about Covid-19 (Coronavirus disease) already by this time after reading various newspapers, watching TV, and engaging in the social media, so I will not bother you more talking about it. However, I would like to qu …

Free Fundamentals of Index Tuning Week: Part 3, Indexing for Joins

Publié le 20 mars 2020 sur sqlservercentral.com
 

The post Free Fundamentals of Index Tuning Week: Part 3, Indexing for Joins appeared first on SQLServerCentral.

What’s New in SQL Monitor 10?

Publié le 20 mars 2020 sur sqlservercentral.com
 

The post What’s New in SQL Monitor 10? appeared first on SQLServerCentral.

Free Fundamentals of Query Tuning Week: Part 4, Improving Cardinality Estimation Accuracy

Publié le 19 mars 2020 sur brentozar.com
 

Before we get to the training in today’s episode, I wanna stop for a second to say thank you. We’re donating 10% of all sales this month to Doctors Without Borders. This morning, I sent in the first donation: so far, you’ve raised $4, …

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.


Pages :