Sites anglophones

A Sudoku Solver for Ordinary folk

Publié le 21 février 2019 sur

Solving Sudoku in smaller, simpler steps How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new article, Simple-Talk editor Tony Davis explains step-by-step how to find and fix the root causes of disk I/O bottlenecks, including gather …

Gartner’s 2018 Market Guide for Data Masking available to download complimentary of Redgate

Publié le 21 février 2019 sur

With the introduction of GDPR in 2018, new data privacy acts appearing around the globe and a striking rise in high-profile data breaches, data masking is a popular topic from IT floor to the board room. Gartner released their 2018 Market Guide for Dat …

SQL SERVER – Query Listing All the Indexes Key Column with Included Column

Publié le 21 février 2019 sur journey to sqlauthority

Today’s blog post is directly inspired by the conversation I had during my Comprehensive Database Performance Health Check. During the consulting engagement, we identified the customers had too many indexes on tables. The goal was to consoli …

The Curious Case of… copying FILESTREAM files between tables

Publié le 20 février 2019 sur - paul randall

(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more frequent. It covers something interesting one of us encountered when working with a cli …

The BI Journey: The Expert’s Advice – Part 1

Publié le 20 février 2019 sur

The series so far: The BI Journey: The Analyst The BI Journey: The Expert’s Advice – Part 1 When Ruthie started her internship at AdventureWorks, the famous bicycle and accessories seller, she sparked off a business intelligence solution th …

Updated First Responder Kit and Consultant Toolkit for February 2019

Publié le 20 février 2019 sur

I hereby christen this the Rich Benner Memorial Release. He’s still alive, it’s just that we’ll always remember him for the work he put into this month’s version. (I’m kidding, of course. We won’t remember him. (I …

Stairway to MDX – Level 14: Basic Set Functions: The Head() Function

Publié le 20 février 2019 sur

SSAS Maestro, SQL Server MVP and Business Intelligence Architect Bill Pearson introduces the MDX Head() function, which allows us to return, in order, a specified number of elements within a set.

On Quickly Investigating a SQL Monitor Custom Security Alert

Publié le 20 février 2019 sur

Phil Factor offers a clever way to report on an intrusion, with a query that shows a full ‘narrative’ description of all the changes that have been detected by SQL Monitor. Using the results, the DBA can very quickly investigate the sequenc …

Azure Data Lake Analytics using U-SQL Queries

Publié le 20 février 2019 sur

This article will help with gaining confidence and familiarity with Microsoft Azure’s Data Lake Analytics offering to process large datasets quickly while demonstrating the potential and capabilities of U-SQL to aggregate and process big data files.

Why is SQL Server Consolidation Better Than Having a Scattered Environment?

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

Having a scattered Microsoft SQL Server database platform is cumbersome to maintain, as you continue to accumulate waste capacity to your database servers. Therefore, you should consider consolidating your platform to make it more manageable. Let …

What does Azure SQL DB Automatic Index Tuning actually do, and when?

Publié le 19 février 2019 sur

Azure SQL DB’s Automatic Tuning will create and drop indexes based on your workloads. It’s easy to enable – just go into your database in the Azure portal, Automatic Tuning, and then turn “on” for create and drop …

Top 10 Databases for 2019

Publié le 19 février 2019 sur

A look at ten top databases fighting for mind-share in 2019.

Learning about DML Triggers

Publié le 19 février 2019 sur

Triggers can be confusing and complex for many developers new to SQL. Steve Jones gives a few ideas for learning more about this construct as well as practicing writing them.

Picking over the Bones of a SQL Injection Attack

Publié le 19 février 2019 sur

The best way to learn how to protect your databases from SQL Injection is to see it in action. In this article, we attack a vulnerable SQL Server REST interface, explain how the attack unfolds, the mistakes that made it possible, and SQL Monitor’s vita …

SQL SERVER – How to Invoke SSMS Help From Command Prompt?

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

This particular question I just received in my recent SQL Server Performance Tuning Practical Workshop. It was a very interesting question and hence I am going to blog about it. The question which I received was – How to Invoke SSMS Hel …

Pages :