Sites anglophones

Developing product recommendations on WideWorldImporters using SQL Graph

Publié le 9 février 2018 sur

SQL Server has always provided tools to manage hierarchies and relationships, facilitating query execution on hierarchical data, but sometimes relationships can become complex. Think about many-to-many relationships, relational databases don’t have a n …

The Annals of Hilariously Bad Code, Part 2

Publié le 9 février 2018 sur

You’re Crazy In Part 1, I showed you code that I think has some anti-patterns in it. In case you didn’t recognize it, it’s actually code that Microsoft wrote. It’s from sp_delete_backuphistory, and it is plum awful. I have …

Bringing DevOps to the database. Part 2: Continuous delivery

Publié le 9 février 2018 sur

Many application developers already use continuous integration to automatically test their code, and release management tools to automate application deployment. Database developers can join them.

Azure Cosmos DB Consistency Levels

Publié le 9 février 2018 sur

The majority of traditional database management systems are responsible for making sure that any changes to their data are consistently reflected in the results of subsequent queries. Azure Cosmos DB extends the range of consistency options by providin …

Webinar: How the GDPR will impact your software delivery processes

Publié le 9 février 2018 sur

With the GDPR enforcement date looming, organisations are focusing on how data is used internally. This webinar will explain the principals of data protection, translate the GDPR jargon, and cover the steps you’ll need to consider to ensure compliance …

SQL SERVER – What is Change Pending State of in SQL Server Configuration Manager?

Publié le 9 février 2018 sur journey to sqlauthority

Recently, one of my clients contacted me for an issue about Change Pending State where they were having issues where SQL Server. As soon as I joined the call with them, they showed me below. My next oblivious question was what was done in the SQL Serve …

Filtered Indexes and Forced Parameterization: Can’t we all just get along?

Publié le 8 février 2018 sur bart duncan's sql weblog

We have a database here that stores information about Azure SQLDB health issues; it was chugging along fine for months, then earlier this week it started to struggle. You can see the large increase in steady-state CPU consumption: After asking around, …

Rethink Server Sizing II

Publié le 8 février 2018 sur

The huge disparity between round-trip access to DRAM memory and the CPU clock cycle has been a serious problem for more than ten years. It is simple to demonstrate that even a small amount of pointer chasing code, in which the memory value being access …

Creating Insert Triggers to Silently Ignore Data You Don’t Want

Publié le 8 février 2018 sur

Say you’ve got an application that insists on inserting data into the database, and…you don’t want the data. You want the application to THINK it inserted the data – you don’t want to roll it back or return an error to th …

Introducing database automation with the SQL Toolbelt

Publié le 8 février 2018 sur

In this post, Mary Robbins explains how Absa bank improved development efficiency and minimized risk by implementing SQL Toolbelt.

Adaptive Query Processing – Interleaved Execution

Publié le 8 février 2018 sur

Interleaved Execution allows SQL Server’s query optimizer to get accurate cardinality estimates in places where it couldn’t before. How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new article, Simple-Talk editor Tony Davis explains …

SQL SERVER – Fix – Error – Property MemoryAllocatedToMemoryOptimizedObjectsInKB is not available for Database. This property may not exist for this object, or may not be retrievable due to insufficient access rights.

Publié le 8 février 2018 sur journey to sqlauthority

The other day when I was presenting my popular training SQL Server Performance Tuning Practical Workshop, during the demonstrations, I received following error. It was bit embarrassing for me as I was presenting in front of over 25 extremely smart …

SQL Server Machine Learning Services – Part 5: Generating multiple plots in Python

Publié le 7 février 2018 sur

The series so far: SQL Server Machine Learning Services – Part 1: Python Basics SQL Server Machine Learning Services – Part 2: Python Data Frames SQL Server Machine Learning Services – Part 3: Plotting Data with Python SQL Server Mach …

Using LIKE on Integers Gets You Implicit Conversion

Publié le 7 février 2018 sur

Using the Stack Overflow public export, take these two queries looking for a particular user by Id (the clustering key):SELECT * FROM dbo.Users WHERE Id = 26837; SELECT * FROM dbo.Users WHERE Id LIKE 26837; The first one (=) gets a clustered index seek …

The new Data Modeling for Power BI course

Publié le 7 février 2018 sur

I recently published a new blog post on SQLBI.You can read it at this link:

Pages :