Sites anglophones


Why you Should Always Specify Whether a Column Accepts Nulls

Publié le 21 février 2020 sur sqlservercentral.com
 

The post Why you Should Always Specify Whether a Column Accepts Nulls appeared first on SQLServerCentral.

Updated First Responder Kit and Consultant Toolkit for February 2020

Publié le 20 février 2020 sur brentozar.com
 

We spent Valentine’s Day removing the bugs from your chocolates. You’re welcome. To get the new version: Download the updated FirstResponderKit.zip Azure Data Studio users with the First Responder Kit extension: ctrl/command+shift+p, First …

MySQL – Get Last Query Cost Using SHOW STATUS LIKE ‘Last_Query_Cost’

Publié le 20 février 2020 sur journey to sqlauthority
 

During the recent webcast I did for Idera, I had the pleasure of showing quite a lot of new tricks and tips. One of the most appreciated tips was about how to get Last Query Cost in MySQL using the command SHOW STATUS LIKE ‘Last_Query_Cost’ …

DBA Team Mashup

Publié le 20 février 2020 sur sqlservercentral.com
 

Have you ever been the sole DBA at a company from the ground up? Me either. Full control of installations, processes and monitoring is a pipe dream for many. Understanding every aspect of your environment and knowing how to react to specific issues tha …

Using SQL Prompt Code Snippets for Repetitive Tasks

Publié le 20 février 2020 sur sqlservercentral.com
 

The post Using SQL Prompt Code Snippets for Repetitive Tasks appeared first on SQLServerCentral.

Configure SQL Server Transparent Data Encryption with PowerShell

Publié le 20 février 2020 sur sqlservercentral.com
 

The post Configure SQL Server Transparent Data Encryption with PowerShell appeared first on SQLServerCentral.

Interesting Undocumented Tidbits in SQL Server 2019 CU2

Publié le 19 février 2020 sur brentozar.com
 

SQL Server 2019 Cumulative Update 2 is out, and Microsoft snuck in a few things that they didn’t mention in the release notes. Contained Availability Groups continue to get new investments. In the lead-up to SQL Server 2019’s release, we go …

WHERE GETDATE() BETWEEN StartDate AND COALESCE(CancelDate, EndDate) Is Even Harder to Tune.

Publié le 19 février 2020 sur brentozar.com
 

In my last post, we started with a memberships table, and each membership had start & end dates. I’m going to create the table and populate it with everyone having an active membership – their StartDate is the same as their Stack Overfl …

SQL SERVER – Linked Server Error – Msg 3910 – Transaction Context In Use By Another Session

Publié le 19 février 2020 sur journey to sqlauthority
 

One of my clients contacted me for an error that appeared while performing a distributed transaction over a linked server. The interesting part was that the linked server was local SQL Server, this is also called a loopback linked server. In this blog, …

SQL Server CASE Statement Example

Publié le 19 février 2020 sur sqlservercentral.com
 

The post SQL Server CASE Statement Example appeared first on SQLServerCentral.

Quickly Find and Mask all Sensitive Data with Data Masker for SQL Server

Publié le 19 février 2020 sur sqlservercentral.com
 

The post Quickly Find and Mask all Sensitive Data with Data Masker for SQL Server appeared first on SQLServerCentral.

WHERE GETDATE() BETWEEN StartDate AND EndDate Is Hard to Tune.

Publié le 18 février 2020 sur brentozar.com
 

Say you’ve got a memberships (or policies) table, and each membership has start & end dates:USE StackOverflow; GO DROP TABLE IF EXISTS dbo.UsersMemberships; CREATE TABLE dbo.UsersMemberships (Id INT IDENTITY(1,1) PRIMARY KEY CLUSTERED, UserId …

Choosing a Processor for SQL Server

Publié le 18 février 2020 sur journey to sqlauthority
 

Choosing a Processor for SQL Server is always a challenge and I often find DBAs and organizations struggling with the same. I have request SQL Server Expert Glenn Berry (b|t) to help us in selecting the right CPU. I am confident that this blog will hel …

Record responses for the State of Database DevOps report

Publié le 18 février 2020 sur sqlservercentral.com
 

The post Record responses for the State of Database DevOps report appeared first on SQLServerCentral.

Storage 101: Understanding the Hard-Disk Drive

Publié le 18 février 2020 sur simple-talk.com
 

The series so far: Storage 101: Welcome to the Wonderful World of Storage Storage 101: The Language of Storage Storage 101: Understanding the Hard-Disk Drive  The storage solutions used by today’s organizations contain hard disk drives (HDDs …


Pages :