Sites anglophones


A Plunge Into TOP

Publié le 4 juin 2019 sur sqlservercentral.com
 

Introduction TOP is one of the many syntactical operators available in T-SQL and at a first view, it could seem very simple and not particularly interesting. According to the official documentation, it “limits the rows returned in a query result …

SQL Clone for Unit Testing Databases

Publié le 4 juin 2019 sur sqlservercentral.com
 

The post SQL Clone for Unit Testing Databases appeared first on SQLServerCentral.

SQL Server Common Table Expression vs Temp Table

Publié le 4 juin 2019 sur sqlservercentral.com
 

The post SQL Server Common Table Expression vs Temp Table appeared first on SQLServerCentral.

SQL Server Diagnostic Information Queries for June 2019

Publié le 3 juin 2019 sur sqlskills.com - glen berry
 

This month, I have added some new columns in some of the queries in most of the query sets. I have also been working on the Azure SQL Database version of the queries some more lately.I have a T-SQL script that you can use to check whether your instance …

Why That “DBA” Job Posting Sounds So Terrible

Publié le 3 juin 2019 sur brentozar.com
 

What follows are just some of the highlights from an actual job posting. I’m not including the job description, just the requirements that an applicant has to have in order to even throw their hat in the ring: Requires Bachelor’s degree or …

SQL SERVER – FIX: Msg 15274 – Access to the Remote Server is Denied Because the Current Security Context is not Trusted

Publié le 3 juin 2019 sur journey to sqlauthority
 

While working with a client, I encountered few errors while using linked server and I am going to share my solutions via a few blog posts. In this blog we would talk about fixing error 15274 – Access to the remote server is denied because the cur …

Create and deploy Azure Resource Manager templates by using the Azure portal

Publié le 3 juin 2019 sur sqlservercentral.com
 

 This article will explain and help to create and deploy ARM templates using the Azure portal. When Azure was first created, Azure resources were managed using the Azure service management (ASM), which is also known as “Classic”. Now t …

How to List All Memory Optimized Tables in SQL Server? – Interview Question of the Week #228

Publié le 2 juin 2019 sur journey to sqlauthority
 

Question: How to List All Memory Optimized Tables in SQL Server?Answer: When I go to Comprehensive Database Performance Health Check engagement, besides looking for the opportunity to drop the indexes, I also look for the opportunity to implement In-Me …

SQL SERVER – Error: 5173 – One or More Files do Not Match the Primary File of the Database

Publié le 1 juin 2019 sur journey to sqlauthority
 

I was recently helping my client to SQL recovery from a hardware failure. I have implemented a good backup strategy for them, and things were easy. I saw a few interesting errors and I am writing a blog on them from the past few days. In this blog, we …

Honored to receive a Patriot Award

Publié le 31 mai 2019 sur sqlskills.com - paul randall
 

This morning I had the great honor to be presented with a Patriot Award for supporting the U.S. Army Reserve activities of Sergeant First Class Jonathan Kehayias. It’s an award for me as I’m Jonathan’s supervisor; and for SQLskills as …

SQL SERVER – REBUILDDATABASE Error: 0x84CF0004 – While updating permission setting for folder The Permission Setting Update Failed for File

Publié le 31 mai 2019 sur journey to sqlauthority
 

This blog would be useful for those who are recovering from a disaster and are trying to rebuild system databases for SQL Server. In this blog, we would learn how to fix permission related error which I observed during the rebuild of system databases u …

SQL Server String Manipulation using Substring Function in T-SQL, R and Python

Publié le 31 mai 2019 sur sqlservercentral.com
 

The post SQL Server String Manipulation using Substring Function in T-SQL, R and Python appeared first on SQLServerCentral.

Set your team up for valued software delivery with Unit Testing

Publié le 31 mai 2019 sur sqlservercentral.com
 

The post Set your team up for valued software delivery with Unit Testing appeared first on SQLServerCentral.

The Curious Case of… very long failover times with a large ad hoc workload

Publié le 30 mai 2019 sur sqlskills.com - paul randall
 

(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more frequent. It covers something interesting one of us encountered when working …

Reporting Services Basics: Creating Your First Report

Publié le 30 mai 2019 sur simple-talk.com
 

The series so far: Reporting Services Basics: Overview and Installation Reporting Services Basics: Creating Your First Report In the previous article in the series, I explained a bit about the history and architecture of SSRS and helped you get a devel …


Pages :