Sites anglophones


T-SQL Decommenter Part I

Publié le 8 novembre 2018 sur sqlservercentral.com
 

Introduction to a T-SQL query that remove comments from T-SQL code

Help Redgate improve Data Masker for SQL Server?

Publié le 8 novembre 2018 sur sqlservercentral.com
 

Redgate are looking for people to help them get a deep understanding of compliance and SQL Server data masking requirements in order to ensure they can provide a world class solution. In return for your feedback you’ll have early access to new re …

Azure EA Financial Reporting and Granular Access to Data Through the Enterprise

Publié le 8 novembre 2018 sur sqlservercentral.com
 

With the billing data from your Azure Enterprise Agreement collected into one database, it is still necessary to break down the costs and provide access to the correct departments and individuals. This is important for chargeback and further analysis. …

SQL SERVER – AlwaysOn – Queries Waiting for HADR_AR_CRITICAL_SECTION_ENTRY

Publié le 8 novembre 2018 sur journey to sqlauthority
 

In the past few days, I am being contacted by clients for AlwaysOn related issue. I have been writing a blog about them. In this blog, we would learn about how to fix wait for HADR_AR_CRITICAL_SECTION_ENTRY. THE SITUATION My client was using SQL Server …

PASS Summit 2018 Keynote Day 1: Live Blog

Publié le 7 novembre 2018 sur brentozar.com
 

Today is the opening day of the 2018 PASS Summit, the largest annual gathering of Microsoft data professionals. Every year, thousands of us gather at the Seattle Convention Center to connect, learn, and share. On this first day of the conference, all t …

What’s New in SQL Server 2019 CTP 2.1: Faster Functions

Publié le 7 novembre 2018 sur brentozar.com
 

A while back, we talked you through a public whitepaper about how Microsoft was working on making user-defined functions go faster. Now that the next preview (CTP2.1) of SQL Server 2019 is out, you can start getting your hands on Froid, the performance …

Simple way to Import XML Data into SQL Server with T-SQL

Publié le 7 novembre 2018 sur sqlservercentral.com
 

In this tip we look at a simple way to import a simple XML document into a SQL Server table. How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new article, Simple-Talk editor Tony Davis explains step-by-step how to find and fix the r …

SQL SERVER – Cluster Resource ‘AGName’ of type ‘SQL Server Availability Group’ in Clustered Role ‘AGName’ Failed

Publié le 7 novembre 2018 sur journey to sqlauthority
 

I never leave my customers alone when they are having an issue with something which I helped them. Typically, I help customers in creating POC and deploying AlwaysOn Availability Groups. Just the other day while doing the Comprehensive Database Pe …

Query Store Performance Overhead: What you need to know

Publié le 6 novembre 2018 sur SQLSkills.com - Erin Stellato
 

“What is the performance overhead of enabling Query Store?”I get asked this question almost every time I present on a topic related to Query Store.  What people are really asking is “Does enabling Query Store affect the performan …

Caution about Restoring via SSMS v17

Publié le 6 novembre 2018 sur sqlservercentral.com
 

A default value has changed in the SSMS v7 restore wizard, and the consequences can be severe.

SQL Clone V3: New features heighten visibility and manageability of clones and images.

Publié le 6 novembre 2018 sur sqlservercentral.com
 

With a brand new dashboard, activity feed and search functionality there is a lot happening in the SQL Clone v3 release. Check out the full breakdown of the update and get onto the latest version.

How Big is Your Transaction Log?

Publié le 6 novembre 2018 sur sqlservercentral.com
 

If you are not managing the transaction log space used by a database, the transaction log might grow uncontrollably. With SQL Server 2017 there is a new dynamic management function (DMF) that exposes statistical information about a database transaction …

SQL SERVER – Script level upgrade for database ‘master’ failed because upgrade step msdb110_upgrade.sql encountered error 926, state 1, severity 25

Publié le 6 novembre 2018 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 which can break SQL Server upgrade. In this blog we would learn about fixing error Script level upgrade for database ‘master’ fai …

Picking #PASSsummit Sessions to Attend

Publié le 5 novembre 2018 sur brentozar.com
 

So you’re going to the PASS Summit in Seattle this week, and you’re overwhelmed with the number of session choices. You’re not alone – it overwhelms me too. There are some slots where I wish I could clone myself and attend sever …

Import flat files to SQL Server on Linux using Azure Data Studio

Publié le 5 novembre 2018 sur sqlservercentral.com
 

Have you ever wonder how to import flat files to SQL Server on Linux? In this article, I will share my experience loading data to a Linux SQL Server instance using the new Azure Data Studio data import extension from macOS.


Pages :