Sites anglophones


SQL SERVER 2019 – How to Turn On or Enable Instant File Initialization?

Publié le 6 janvier 2020 sur journey to sqlauthority
 

Learning never stops with SQL Server. In this blog, we would find new ways to find information. In this blog, we would see the current setting of instant file initialization and how to make the modification. Last year I wrote a few blogs about Instant …

ASP.NET Core with GitOps: Orchestrating Your Containers with Kubernetes

Publié le 6 janvier 2020 sur sqlservercentral.com
 

The post ASP.NET Core with GitOps: Orchestrating Your Containers with Kubernetes appeared first on SQLServerCentral.

Setting up Management Studio for remote SQL Server

Publié le 6 janvier 2020 sur sqlservercentral.com
 

Problem Most of us, developers, love to write SQL code on our local machines not only because they’re executed faster, but also because we have a lot more control over the data as it is used only by us and is not team dependent. This was the case in my …

How to Map Network Drive as Fixed Drive? – Interview Question of the Week #258

Publié le 5 janvier 2020 sur journey to sqlauthority
 

Question: How to Map Network Drive as Fixed Drive in SQL Server?Answer: The command to map any drive as a fixed drive is Windows command and you can run that in the SQL Server with the help of the extended stored procedure. Here is the script for the s …

SQLBits 2020 – SQL Server Performance Tuning Real-World Scenarios – at ExCel London

Publié le 4 janvier 2020 sur journey to sqlauthority
 

I am pretty excited that I will be presenting a day-long training at SQLBits on 31 March 2020 at ExCel London on the topic SQL Server Performance Tuning Real-World Scenarios. I have learned that many of the seats are already booked and now on …

Using Calendars and Dates in Power BI

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

The series so far: Creating Calculated Columns Using DAX Creating Measures Using DAX Using the DAX Calculate and Values Functions Using the FILTER Function in DAX Cracking DAX – the EARLIER and RANKX Functions Using Calendars and Dates in Po …

Fixing A previous restore operation was interrupted and did not complete processing

Publié le 3 janvier 2020 sur sqlskills - jonathan kehayas
 

I recently was working on a customer system where a myriad of bad things had occurred simultaneously that left them in a scenario where their primary database server had corruption of an important database and their DR Log Shipped Secondary server coul …

SQL SERVER – SQL Azure Managed Instance Restore Error – The Database Was Backed Up on a Server Running Version 15.00.2000

Publié le 3 janvier 2020 sur journey to sqlauthority
 

Based on the current trend of moving to the cloud platform, there have been many new learnings for me. One of my clients migrated to SQL Azure Managed Instance and contacted me for an interesting situation. In this blog, I am going to share my findings …

SQL Server Best Practices for Data Quality

Publié le 3 janvier 2020 sur sqlservercentral.com
 

The post SQL Server Best Practices for Data Quality appeared first on SQLServerCentral.

Introduction to Gaps and Islands Analysis

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

One of the most significant challenges we face when analyzing data is pattern recognition. We seek to find ways in which our data deviates from the norm or conforms to a given norm. The goal is to identify tools that can be used to predict future behav …

SQL SERVER – ISNUMERIC Function and Interesting Result

Publié le 2 janvier 2020 sur journey to sqlauthority
 

Today’s blog post is based on a very interesting observation sent to my client of the Comprehensive Database Performance Health Check. While I primarily focus on improving the performance of SQL Server, often I receive question-related to T-SQL a …

Using SQL Change Automation in SSMS to Track Static Data Changes

Publié le 2 janvier 2020 sur sqlservercentral.com
 

The post Using SQL Change Automation in SSMS to Track Static Data Changes appeared first on SQLServerCentral.

Building a Countdown Timer with PowerShell

Publié le 2 janvier 2020 sur sqlservercentral.com
 

The post Building a Countdown Timer with PowerShell appeared first on SQLServerCentral.

Exporting Data with PowerShell

Publié le 2 janvier 2020 sur sqlservercentral.com
 

Recently I had the need to help someone download some data from SQL Server as a part of an automated process. In this case, the person wanted to use PowerShell (PoSh), since they were performing a few other actions with PoSh as well. This article is a …

Why the Database Must be Part of DevOps

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

According to Microsoft, DevOps is “the union of people, process, and products to enable continuous delivery of value to our end users.” The definition doesn’t mention any frameworks or specific tools, and it’s more about communi …


Pages :