Sites anglophones


SQL SERVER – Fix: 400 – Bad Request Authentication Failed for Account and the Provided Key. Please Provide a Valid Key and Try Again

Publié le 25 janvier 2019 sur journey to sqlauthority
 

While helping a client with Azure environment, I came across an interesting error. I this blog I would explain cause and fix of error “Authentication failed for account sqlauthprembackup and the provided key. Please provide a valid key and try ag …

Important Query Store Fixes – January 2019

Publié le 24 janvier 2019 sur SQLSkills.com - Erin Stellato
 

The latest CUs for SQL Server 2016 and 2017 contain some important Query Store fixes that I thought worth mentioning for those of you on either version or those of you looking to upgrade.  As of this writing, the current CU for SQL Server 2016 SP2 …

Watch Brent Tune Queries: Fixing Nested Functions

Publié le 24 janvier 2019 sur brentozar.com
 

When I do performance tuning for clients, I really pride myself on making as few changes as possible in order to make a tremendous difference. I consider it a failure when I have to tell someone to rewrite a bunch of queries from scratch. However, ther …

Rolling Back CREATE DDL Statements

Publié le 24 janvier 2019 sur sqlservercentral.com
 

There is a myth that DDL statements can’t be rolled back. This article tests and debunks the myth.

New Case Study: Reducing capital by $500,000 with SQL Clone

Publié le 24 janvier 2019 sur sqlservercentral.com
 

When a well-known financial services company was searching for a solution to move data through the development cycle faster and easier, SQL Clone provided impressive results. As well as leading to improved and more in-depth testing processes, SQL Clone …

Getting Started with CQRS – Part 2

Publié le 24 janvier 2019 sur sqlservercentral.com
 

In this second article of the series, Diogo Souza walks you through creating the MongoDB code, the query side of the pattern, to complete the CQRS configuration.

SQL SERVER – Always On Availability Group Listener Missing in SSMS but Working Fine in Failover Cluster Manager

Publié le 24 janvier 2019 sur journey to sqlauthority
 

I have helped many customers to solve complex issues in their environment by Comprehensive Database Performance Health Check. Sometimes, the issue looks very complex but once the solution is found it seems very easy. In this blog, we would learn about …

Tuning Dynamic SQL by Hand with Short Circuits

Publié le 23 janvier 2019 sur brentozar.com
 

When we think about building dynamic SQL, we usually think about a stored procedure like this that takes input parameters, builds a string, and then executes that string. Here’s a simple example:CREATE OR ALTER PROC dbo.usp_SearchUsers @SearchDis …

New Fundamentals of Index Tuning Course

Publié le 23 janvier 2019 sur brentozar.com
 

You’re a developer who needs to make your application go faster, and you don’t want to (or can’t!) change the queries. You’ve never been to an official training class, and your manager isn’t about to spring for travel. In …

SQL Server Reporting Services Report Builder with DAX Query Support

Publié le 23 janvier 2019 sur sqlservercentral.com
 

In this tip we look at how you can use DAX formulas within your SQL Server Reporting Services Report Builder reports.

SQL SERVER – Identify Datatype Using SQL_VARIANT_PROPERTY Function

Publié le 23 janvier 2019 sur journey to sqlauthority
 

One of my client of Comprehensive Database Performance Health Check sent me the following email about SQL_VARIANT_PROPERTY Function. I really love my job as SQL Server consultant as I get to learn most of the new stuff or discover the hidden knowl …

Free Downloads for Powerful SQL Server Management

Publié le 22 janvier 2019 sur brentozar.com
 

You’re responsible for managing and troubleshooting SQL Server. Good news: you’re not alone. The SQL Server community has banded together and built a bunch of cool stuff to help you do your job easier. In a one-hour session this morning for …

Customizing the Default Azure Data Studio Dashboards

Publié le 22 janvier 2019 sur sqlservercentral.com
 

Explore the Azure Data Studio dashboards and see how to customize one of these dashboards to include a new widget.

Creating and using inline table-valued functions

Publié le 22 janvier 2019 sur sqlservercentral.com
 

Inline Table Valued Functions (iTVFs) are one type of user defined function that is available to implement in SQL Server since SQL Server 2000. iTVFs remain a very useful tool in our SQL armoury, so let’s quickly revisit them and the different ways we …

SharePlex – Efficient and High Performance Replication from Oracle to Kafka

Publié le 22 janvier 2019 sur journey to sqlauthority
 

Ask any DBA what is their dream infrastructure and I promise you that they will narrate immediately a story which will be centered around no downtime and amazing performance. However, when you ask them if they know what exactly will make them …


Pages :