Sites anglophones

Compliant Database DevOps for SQL Server using Redgate Tools

Publié le 4 février 2019 sur

In this article Stephanie Herr looks at the Redgate tools that give you an end-to-end compliant Database DevOps Solution

Getting Started with Database containers

Publié le 4 février 2019 sur

A beginning look at containers in Windows.

Feb 2019 Updates – Webcast, SQLBits, SQL Saturday and Performance Tuning of Your System

Publié le 4 février 2019 sur journey to sqlauthority

As February starts, just thought of dropping a note to let you know where you can find me in the upcoming months. Do scroll down all the way to read the change in offering in SQL Server Performance Tuning Workshop. Optimize Server Performance by Reduci …

Does Parallel Threads Process Equal Rows? – Interview Question of the Week #211

Publié le 3 février 2019 sur journey to sqlauthority

Question: Does Parallel Threads Process Equal Rows? Answer: No. (Well usually no). I received the same question during the Comprehensive Database Performance Health Check. Here is the simple proof running the following query: SELECT [SalesOrderID] …

SQL SERVER – Msg 2555: Cannot Move All Contents of File to Other Places to Complete the Emptyfile Operation

Publié le 2 février 2019 sur journey to sqlauthority

Once upon a time, I was trying to remove TempDB database additional files, but it was not working. In this blog I would explain the steps needed fix Msg 2555: Cannot move all contents of the file to other places to complete the emptyfile operation. THE …

SQL Server Diagnostic Information Queries for February 2019

Publié le 1 février 2019 sur - glen berry

This month, I have just made some minor improvements to most of the query sets, mainly in the comments and documentation. I have a T-SQL script that you can use to check whether your instance of SQL Server has been patched to mitigate against the Spect …

[Video] Getting Started with the Consultant Toolkit

Publié le 1 février 2019 sur

You’re a consultant who needs to figure out why your clients’ SQL Servers are slow and unreliable. You’ve collected a bunch of diagnostic queries over the years, but they have a lot of holes, and you don’t really have the time t …

Database Continuous Integration with SQL Clone and SQL Change Automation

Publié le 1 février 2019 sur

Uses SCA to build the database and SQL Clone to distribute the finished database to the various team-based servers who require the latest build.

SQL SERVER – Patch Failure – Unable to Retrieve the Cluster Service

Publié le 1 février 2019 sur journey to sqlauthority

Few of my clients are still running older versions of SQL Server and they have their own reasons to not to move to the new SQL version. In this blog, we would learn about the fix of an error for which my client contacted me. My client was trying to app …

10 Database Tasks That Sound Easy, But Aren’t

Publié le 31 janvier 2019 sur

All of these are doable with scripts, tools, and/or elbow grease, mind you – they’re just not as easy as they sound at first glance until you know about the existence of those scripts, tools, and/or free people waiting around with …

Build and fill a database using JSON and SQL Change Automation

Publié le 31 janvier 2019 sur

Storing your data for development work as JSON confers several advantages. You can exchange data with any application or service that can consume JSON data, you can edit the data easily in a JSON editor, use lightning fast data masking that doesn …

Cyber Insecurity in Pakistan

Publié le 31 janvier 2019 sur

Journalist Alamzeb Khan discusses recent security breaches in Pakistan that have affected millions of people and accounts.

SQL SERVER – Error 1051: A Stop Control Has Been Sent to a Service that Other Running Services are Dependent On

Publié le 31 janvier 2019 sur journey to sqlauthority

Sometimes there are some random unexpected errors and it’s always fun to find the cause of them. In this blog we would learn about an error 1051 (A stop control has been sent to a service that other running services are dependent on) which I rece …

Changing the SSH port for a RHEL Azure VM

Publié le 30 janvier 2019 sur - paul randall

I’m working with Red Hat Enterprise Linux (RHEL) VMs on Azure and one of the best practices that Microsoft recommends is to change the default SSH port from 22 to something else. I was looking for a consolidated set of instructions to do this and …

Improve the Performance of Your Azure SQL Database (and Save Money!) with Automatic Tuning

Publié le 30 janvier 2019 sur

Azure can create sticker shock for some companies as they venture into the cloud. As a database administrator, it is your job to fine-tune your environment to mitigate those costs the best you can. Azure SQL Database Purchasing Models Microsoft gives y …

Pages :