A Pattern Based Approach to Masking Errors
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
The post SQL Monitor Roadtrip: Preparation appeared first on SQLServerCentral.
Creating or Altering an Objects with a Single Statement
The post Creating or Altering an Objects with a Single Statement appeared first on SQLServerCentral.
[Video] Can You Tell When a Rollback Will Finish?
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?
The post What Percent Complete Is That Index Build? appeared first on SQLServerCentral.
A Set-based Solution for the Bin Packing Problem
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
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?
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
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
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
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
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!
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.
“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
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 …