Sites anglophones


SQL Server MERGE statement usage and examples

Publié le 26 septembre 2018 sur sqlservercentral.com
 

In this tip we look at how to use MERGE compared to running separate INSERT and UPDATE statements.

Connecting – Level 4 of the Stairway to Azure SQL Database

Publié le 26 septembre 2018 sur sqlservercentral.com
 

Learn how to configure connectivity and firewall rules for your Azure SQL Database

SQL SERVER – Database Performance Analyzer – Table Tuning Advisors

Publié le 26 septembre 2018 sur journey to sqlauthority
 

I am a SQL Server Performance Tuning Expert who acts as a consultant for many organizations across the world who have performance tuning issues. I am often showed one or more of the tables of the system and asked to tune the system around those tables. …

Backup Checksum Feature in SSMS 18.0 Preview 4

Publié le 25 septembre 2018 sur sqlskills.com - glen berry
 

I was pleasantly surprised to see a new “Backup checksum” checkbox in the Server Properties, Database Settings dialog page (as shown in Figure 1). This was something that I had been asking for for quite awhile, so I appreciate that it has b …

SQL Server Diagnostic Information Queries for September 2018

Publié le 25 septembre 2018 sur sqlskills.com - glen berry
 

This month, I have added a separate set of queries for SQL Server 2019. I have also added two new queries to the SQL Server 2012 through SQL Server 2017 sets of queries. I have a T-SQL script that you can use to check whether your instance of SQL Serve …

New Class Week: Performance Tuning in 21 Demos

Publié le 25 septembre 2018 sur brentozar.com
 

We first unveiled this class for the PASS Summit, but due to high demand, we’re doing an online version, too. You’re a developer or DBA who wants to tune indexes and queries to make your application go faster. You don’t like learning …

Renaming a Schema in SQL Server

Publié le 25 septembre 2018 sur sqlservercentral.com
 

If you have a schema you want to retire, here’s a method for moving all objects inside that schema to a new one.

Adaptive Query Processing in SQL Server

Publié le 25 septembre 2018 sur sqlservercentral.com
 

Adaptive query processing is the latest query processing feature introduced in the SQL Server database engine, available in SQL Server (starting with SQL Server 2017 (14.x)) and Azure SQL Database. Read on to learn more.

SQL Authority News – Microsoft Released SQL Server 2019 Preview

Publié le 25 septembre 2018 sur journey to sqlauthority
 

The wait is over. Microsoft has just announced SQL Server 2019 Preview in the Ignite conference. Lots of people were wondering if there is going to be any SQL Server 2018. The answer is Microsoft is going to skip this year as a release for SQL Server a …

What’s New in SQL Server 2019 System Tables

Publié le 24 septembre 2018 sur brentozar.com
 

The free SQL Server 2019 preview download is out, and here are quite a few things to check out that aren’t documented yet: New System Objects Starting with new stored procedures: sys.sp_add_feature_restriction sys.sp_autoindex_cancel_dta sys.sp_a …

What’s New in SQL Server 2019’s sys.messages: More Unannounced Features

Publié le 24 septembre 2018 sur brentozar.com
 

The system table sys.messages holds error messages that SQL Server needs to return to end users. When a new build comes out, I love checking this table to see what features Microsoft has coded, but isn’t quite ready to announce yet. When SQL Serv …

What’s New in SQL Server 2019: Faster Table Variables (And New Parameter Sniffing Issues)

Publié le 24 septembre 2018 sur brentozar.com
 

For over a decade, SQL Server’s handling of table variables has been legendarily bad. I’ve long used this Stack Overflow query from Sam Saffron to illustrate terrible cardinality estimation:declare @VoteStats table (PostId int, up int, …

What’s New in SQL Server 2019: Adaptive Memory Grants

Publié le 24 septembre 2018 sur brentozar.com
 

When you run a query, SQL Server guesses how much memory you’re going to need for things like sorts and joins. As your query starts, it gets an allocation of workspace memory, then starts work. Sometimes SQL Server underestimates the work you …

Questions About HIPAA That You Were Too Shy to Ask

Publié le 24 septembre 2018 sur sqlservercentral.com
 

As a data professional or developer, you will likely have questions about how HIPAA impacts you and your day to day responsibilities. Rebecca Edwards answers common questions about HIPAA that you were too shy to ask.

Uploading On-Premise data to Azure Blob Storage using SSIS

Publié le 24 septembre 2018 sur sqlservercentral.com
 

Azure SSIS Feature pack can be used to upload the data over to Azure Storage account. In this article, Supriya Pande will describe how you can upload the data to Azure Blob Storage using SSIS task.


Pages :