Sites anglophones


Glenn’s Tech Insights For April 29, 2019

Publié le 29 avril 2019 sur sqlskills.com - glen berry
 

(Glenn’s Tech Insights… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can get more visibility. It covers interesting new hardware and software developments that are generally releva …

Download SQL Server Management Studio 18.0 (General Availability)

Publié le 29 avril 2019 sur journey to sqlauthority
 

I am really happy that Microsoft has finally announced the general availability of SQL Server Management Studio 18.0. It is the latest version of SSMS available and it works flawlessly with SQL Server 2019 and earlier versions of SQL Server.Here is the …

Call SQL Server Stored Procedures with PowerShell using Parameter Objects

Publié le 29 avril 2019 sur sqlservercentral.com
 

The post Call SQL Server Stored Procedures with PowerShell using Parameter Objects appeared first on SQLServerCentral.

Dos and Don’ts of Dynamic SQL

Publié le 29 avril 2019 sur sqlservercentral.com
 

Dynamic SQL can be an incredibly powerful tool when used properly, however, it can an incredibly large security flaw or a pain to debug if written poorly. The below is a few of Dos (and Don’ts) that I have that may help you in the future when wri …

Processing Data Using Azure Data Lake, Azure Data Analytics, and Microsoft’s Big Data Language U-SQL

Publié le 29 avril 2019 sur sqlservercentral.com
 

The post Processing Data Using Azure Data Lake, Azure Data Analytics, and Microsoft’s Big Data Language U-SQL appeared first on SQLServerCentral.

How I Know If I am DBOWNER or Not in SQL Server? – Interview Question of the Week #222

Publié le 28 avril 2019 sur journey to sqlauthority
 

Question: How I Know If I am DBOWNER or Not in SQL Server?Answer: This question was asked to me during Comprehensive Database Performance Health Check. While I proposed a few changes to my customers to the database, the DBA on the other side was worrie …

Why You Shouldn’t Use an Intel Xeon Silver Processor for SQL Server

Publié le 27 avril 2019 sur sqlskills.com - glen berry
 

IntroductionIntel has four main segments in their Second Generation Intel Xeon Scalable Processor Family. These include Xeon Bronze, Xeon Silver, Xeon Gold, and Xeon Platinum. The reason why there are six boxes in Figure 1 is because Intel further segm …

SQL SERVER – Performance Monitoring Week – Wrap Up

Publié le 27 avril 2019 sur journey to sqlauthority
 

It has been almost 19 years since I started working with SQL Server and for over 14 years I have focused on SQL Server Performance Tuning. I have been fortunate to have seen nearly every single problem in this area. Every single day I meet a new client …

SQL Server Monitoring Week – SQL Plan Warnings

Publié le 26 avril 2019 sur journey to sqlauthority
 

Today I am starting a week-long series where I will be discussing various SQL Server Monitoring Tools. My primary aim is to help people with my consulting workshop Comprehensive Database Performance Health Check. While I help customers with their vario …

Reporting on the Status of Clones During Database Development

Publié le 26 avril 2019 sur sqlservercentral.com
 

The post Reporting on the Status of Clones During Database Development appeared first on SQLServerCentral.

New HP Spectre x360 Laptop

Publié le 25 avril 2019 sur sqlskills.com - glen berry
 

IntroductionEarlier this week, I bought a new HP Spectre x360 13-AP0023DX convertible laptop at Best Buy. I have often criticized Best Buy as a bad place to buy a computer, but in this case I ignored my own advice for some good reasons. First, this was …

SSMS v18 and Azure Data Studio: The Golden Age of SQL Server Tooling

Publié le 25 avril 2019 sur brentozar.com
 

Yesterday, SQL Server Management Studio 18.0 shipped. Here’s the official announcement, the download page, and the release notes. Yes, it’s still free, and yes, they’re still adding features. Yes, they removed database diagrams and th …

SQL Server Monitoring Week – Spotlight Cloud

Publié le 25 avril 2019 sur journey to sqlauthority
 

Today I am starting a week-long series where I will be discussing various SQL Server Monitoring Tools. My primary aim is to help people with my consulting workshop Comprehensive Database Performance Health Check. While I help customers with their vario …

Tracking the number of active sessions on a database using SQL Monitor

Publié le 25 avril 2019 sur sqlservercentral.com
 

The post Tracking the number of active sessions on a database using SQL Monitor appeared first on SQLServerCentral.

Using Backup Encryption with an External Certificate

Publié le 25 avril 2019 sur sqlservercentral.com
 

As security becomes more and more important to data professionals, one of the more basic things a DBA or sysadmin must do is protect the backup files for their databases. SQL Server provides a few ways to encrypt backups, and there are numerous third p …


Pages :