Sites anglophones


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 …

Database Normalization in SQL with Examples

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

Introduction As a database developer, we might often come across terms like normalization and denormalization of a database. Database normalization is a technique that helps to efficiently organize data in a given database. Essentially, it is a systema …

General Purpose Tier for Azure SQL Database

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

The post General Purpose Tier for Azure SQL Database appeared first on SQLServerCentral.

Recommended SQL Server Books, 2020 Edition

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

If you’re the kind of person who likes to read books, here are some that I think would expand your horizons. These links are Amazon affiliate links, so I make a few cents when you buy through ’em. It’s your way of tipping me for the b …

SQL SERVER – Stream Aggregate and Hash Aggregate

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

SQL Server Performance tuning is an amazing subject, it never stops to amaze me. Every single day, I take only one Comprehensive Database Performance Health Check and keep the rest of the time open for either learning new stuff or helping people with O …

Handling Aggregations on a Poorly Designed Database

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

Problem A few weeks back, I got a chance to work on a legacy application for one of my old clients. They had this desktop application setup that used SQL views to display the data and aggregations while Stored Procedures were used to directly interact …

Using SQL Server RAND Function Deep Dive

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

The post Using SQL Server RAND Function Deep Dive appeared first on SQLServerCentral.

How to Measure Resource Status on Azure? – Interview Question of the Week #264

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

Question: How to Measure Resource Status on Azure?Answer: While I work on Comprehensive Database Performance Health Check, I get to work on on-premises SQL Server deployments as well as Microsoft Azure. Every single time when I start working with Azure …

MySQL – Download Sample Database – Sakila, World, Employee

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

Just like SQL Server, I do consult with MySQL, PostgreSQL, and MariaDB. One of the most popular questions, I often receive during my consulting engagement is that where can one download the sample database for various databases. While we should always …

Beginner Guide to In-Memory Optimized Tables in SQL Server

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

Sometimes when I try to learn about a concept my brain blocks out everything about it. Talking about anything that uses the In-Memory concept tends to do this to me on occasion. It’s important to note that In-Memory is a marketing term for a seri …

Creating Time-Intelligence Functions in DAX

Publié le 14 février 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 …


Pages :