Sites anglophones


A Pattern Based Approach to Masking Errors

Publié le 27 avril 2020 sur sqlservercentral.com
 

A few years ago I had a requirement to allow both developers and customers to see rows from a table used to store error information while making sure that any PII, PCI or similar sensitive data was not displayed. The tolerance for “oops” wa …

SQL Monitor Roadtrip: Preparation

Publié le 27 avril 2020 sur sqlservercentral.com
 

The post SQL Monitor Roadtrip: Preparation appeared first on SQLServerCentral.

Creating or Altering an Objects with a Single Statement

Publié le 24 avril 2020 sur sqlservercentral.com
 

The post Creating or Altering an Objects with a Single Statement appeared first on SQLServerCentral.

[Video] Can You Tell When a Rollback Will Finish?

Publié le 23 avril 2020 sur brentozar.com
 

I happened to see this DBA.StackExchange.com question about killing a big delete, and I really felt for the admin involved: Four days ago a user ran the command below on a table with 400,000,000 rows. It’s still running and the log file is increa …

What Percent Complete Is That Index Build?

Publié le 23 avril 2020 sur sqlservercentral.com
 

The post What Percent Complete Is That Index Build? appeared first on SQLServerCentral.

A Set-based Solution for the Bin Packing Problem

Publié le 23 avril 2020 sur sqlservercentral.com
 

Introduction The Bin Packing Problem, in its simplest form, is easy to explain and to understand: imagine that there are a certain number of items, each one with its own value (e.g. a volume, a weight, a length…) and an infinite number of bins i …

Why Ordering Isn’t Guaranteed Without an ORDER BY

Publié le 22 avril 2020 sur brentozar.com
 

If your query doesn’t have an ORDER BY clause, you can’t reliably predict the order of your results over time. Sure, it’s going to look predictable at first, but down the road, as things change – the indexes, the table, the …

What’s changed for database monitoring this year?

Publié le 22 avril 2020 sur sqlservercentral.com
 

The post What’s changed for database monitoring this year? appeared first on SQLServerCentral.

Translating a SQL Server Schema into a Cassandra Table: Part III Many-to-Many, Attribute Closure and Solution Space

Publié le 21 avril 2020 sur simple-talk.com
 

The series so far: Translating a SQL Server Schema into a Cassandra Table: Part I Problem Space and Cassandra Primary Key Translating a SQL Server Schema into a Cassandra Table: Part II Integrity Constraints  Translating a SQL Server Schema into a …

Tempdb – Here’s a Problem You Didn’t Know You Have

Publié le 21 avril 2020 sur simple-talk.com
 

Over the past few years, I’ve worked to maintain and optimize a database environment, and I’ve faced all sorts of problems, but one pain point common in almost all SQL Server environments is tempdb. The usage of tempdb in SQL Server is well …

[Video] Altering Datatypes With (Almost) No Downtime

Publié le 21 avril 2020 sur brentozar.com
 

Sometimes, your INT columns run out of space, and you need to alter them to be a larger datatype, like BIGINT. Usually, when you do this, you’re met with screams of agony from your end users because this will totally lock the table and rewrite th …

Create Custom Functions in Power Query

Publié le 21 avril 2020 sur sqlservercentral.com
 

Introduction Often at times, you may come across situations where you need to calculate a column repeatedly multiple times in the same Power BI report or across multiple reports. Although you can use the calculated columns to some extent, these are not …

Try one of our new candidate screening tests at Kandio!

Publié le 20 avril 2020 sur sqlskills.com - paul randall
 

We’re excited to announce that we have a new partnership! We’ve been involved in a lot of recruiting processes for our clients and realized we could save everyone time and money by pre-screening candidates. To that end, we’ve teamed u …

What’s Your Favorite SQL Server Interview Question? Here’s Mine.

Publié le 20 avril 2020 sur brentozar.com
 

“Out of the stuff on your resume, what are you the proudest of, the most excited about? When I’m interviewing a candidate for one of my clients, I’ll usually start with this question to help understand the resume. See, recruiters seem …

A Data Science Approach in Product Analytics

Publié le 20 avril 2020 sur sqlservercentral.com
 

A significant part of product development is A/B testing. Simply put, this is where companies and product managers test to see a new version of their product versus the older one to make sure it’s worth publishing their features to the entire use …


Pages :