Sites anglophones


SQL SERVER – Script Level Upgrade for Database ‘master’ Failed – The Server Principal Owns One or More Availability Group(s) and Cannot be Dropped

Publié le 14 janvier 2020 sur journey to sqlauthority
 

I have helped many clients in upgrade failures via my On-Demand consulting and I am amazed to see various ways that can break SQL Server upgrade. In this blog we would learn about fixing error Script level upgrade for database ‘master’ fail …

Re-oiling the gears for the data dictionary or catalog

Publié le 14 janvier 2020 sur sqlservercentral.com
 

Back in 2011 I wrote Oiling the gears for the data dictionary It describes a means of simplifying the addition of comments to SQL Server objects used by a number of database documentation tools.  These produce information that is up-to-date, consi …

The Need for a Data Catalog

Publié le 14 janvier 2020 sur sqlservercentral.com
 

The post The Need for a Data Catalog appeared first on SQLServerCentral.

Going Serverless with Azure SQL Database

Publié le 14 janvier 2020 sur sqlservercentral.com
 

The post Going Serverless with Azure SQL Database appeared first on SQLServerCentral.

Building SQL ConstantCare®: Which Recommendations Do People Mute?

Publié le 13 janvier 2020 sur brentozar.com
 

Our SQL ConstantCare® service sends you daily recommendations for specific tasks that will improve your SQL Server’s health and performance. Next to each recommendation, there’s a Mute link that you can click on to either mute the recom …

SQL SERVER 2019 – Still Getting String or Binary Data Would be Truncated

Publié le 13 janvier 2020 sur journey to sqlauthority
 

If you have read release notes of SQL Server 2019, you might have been aware of the fact that Microsoft has finally made an enhancement to error 8152 – String or binary data would be truncated. I often get a question about this topic in my Compre …

Dynamically process SSAS Cube from SSIS package

Publié le 13 janvier 2020 sur sqlservercentral.com
 

Problem A few months back, I was working on an OLAP cube for a client who was looking to deploy these cubes for each of the end customers so that they can use the cube and complete their reporting requirements. Initially, the requirements were pretty s …

Insert and Delete SQL Server Data with Views

Publié le 13 janvier 2020 sur sqlservercentral.com
 

The post Insert and Delete SQL Server Data with Views appeared first on SQLServerCentral.

What is TempDB Spill in SQL Server? – Interview Question of the Week #259

Publié le 12 janvier 2020 sur journey to sqlauthority
 

Question: What is TempDB Spill in SQL Server?Answer: When SQL Server poorly (incorrectly) estimates the number of rows that will be returned from any operator, it requests an incorrect amount of memory grant from the SQL Server engine, which leads to a …

SQL SERVER – Patch Failure – Disk Full: There is Not Enough Disk Space On the Volume

Publié le 11 janvier 2020 sur journey to sqlauthority
 

Few of my clients are still running older versions of SQL Server and they have their own reasons to not to move to the new SQL version. In this blog, I would share my findings of how I identified the cause of failure “Disk full: There is not enou …

SQL SERVER – Log Shipping Job Error: Failed to Connect to Server

Publié le 10 janvier 2020 sur journey to sqlauthority
 

A few days ago, I wrote a blog about log shipping job failure due to missing permission. In this blog, I would share my experience with another log shipping error “Connection Timeout Expired” for which my client contacted me via Comprehensi …

SQL SERVER – Log Shipping Error: Only Members of the Sysadmin Fixed Server Role Can Perform this Operation

Publié le 9 janvier 2020 sur journey to sqlauthority
 

Even though there are many disaster recovery solutions available in SQL Server as of today, few of my clients Still go with log shipping. In this blog, I would share my learning about one of the errors which I observed with one of my clients. In this b …

Use Polybase to consume Oracle data from SQL Server on Linux 2019

Publié le 9 janvier 2020 sur sqlservercentral.com
 

SQL Server on Linux only allows you to create a linked server to another SQL Server instance, so you need to use the Polybase feature to consume data from Oracle. Note, however, that this feature is only available in the 2019 version; for the 2017 vers …

Replace Model SQL Server Database with a User Database

Publié le 9 janvier 2020 sur sqlservercentral.com
 

The post Replace Model SQL Server Database with a User Database appeared first on SQLServerCentral.

But the Database Worked in Development! Preventing Broken Constraints

Publié le 8 janvier 2020 sur simple-talk.com
 

You’re working in development, releasing a new version of the application. You’ve temporarily disabled constraints in the new version of the database, you’ve imported the current data, your hand is poised to enable constraints. Is it …


Pages :