Sites anglophones

Identifying the right Service tier for Azure Database

Publié le 20 septembre 2018 sur

Determining the number of DTUs which will help in deciding the service tier for Azure SQL.

Pseudonymizing a Database with Realistic Data for Development Work

Publié le 20 septembre 2018 sur

In this article Phil Factor shows us how to surgically alter data from an entire database that can identify individuals but leave everything else intact.

Encryption Key Management for Microsoft SQL Server 2008-2016

Publié le 20 septembre 2018 sur

Organizations continue to experience damaging losses due to data breaches, including legal costs, costs to reimburse customer and employees, lost stakeholder value, and reduction of goodwill. In recognizing the importance of proper key management for

SQL SERVER – Simple Method to Find FIRST and LAST Day of Current Date

Publié le 20 septembre 2018 sur journey to sqlauthority

In my very old post SQL SERVER – Query to Find First and Last Day of Current Month – Date Function, I had explained how to find the first day and last day of the current date. The method I showed you in the old posted uses CONVERT function …

A Simple Stored Procedure Pattern To Avoid

Publié le 19 septembre 2018 sur

Get Yourself Together This is one of the most common patterns that I see in stored procedures. I’m going to simplify things a bit, but hopefully you’ll get enough to identify it when you’re looking at your own code. Here’s the s …

The Changing Role of SQL Server Monitoring

Publié le 19 septembre 2018 sur

As SQL Server estates continue to grow quickly, and change in nature, due to the ease with which new cloud-based, containerized or virtual machine-based SQL Servers can be provisioned, so too the role of the monitoring tool changes.

Stairway to Biml Level 8 – Using the Relational Database Metadata to Build Packages

Publié le 19 septembre 2018 sur

In this next level of the Stairway to Biml, we will examine how you can use the information stored in your RDBMS to build packages.

Free eBook: SQL Server Transaction Log Management

Publié le 19 septembre 2018 sur

When a SQL Server database is operating smoothly and performing well, there is no need to be particularly aware of the transaction log, beyond ensuring that every database has an appropriate backup regime and restore plan in place. When things go wrong …

SQL SERVER – Remove Duplicate Rows Using UNION Operator

Publié le 19 septembre 2018 sur journey to sqlauthority

In my earlier post on SQL SERVER – Delete Duplicate Rows, I showed you a method of removing duplicate rows with the help of ROW_NUMBER() function and COMMON TABLE EXPRESSION. In this post, I am going to show you a tricky method of removing duplic …

One Hundred Percent CPU

Publié le 18 septembre 2018 sur

Raise Your Hand If You’ve ever wanted to play a prank on your co-workers, but just didn’t have a any ideas that didn’t involve exploding Hot Pockets. Now you have something even less safe than molten cheese squirts! A stored procedure …

Loading CSV Files Using Dynamic SQL

Publié le 18 septembre 2018 sur

In this article, we will see of a quick way to load CSV files from a directory on your computer. 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 t …

Azure SQL Database High Availability

Publié le 18 septembre 2018 sur

Site-wide or region-wide disasters, while undoubtedly more impactful, happen considerably less frequently than downtime resulting from scheduled maintenance events or isolated hardware and software faults. This article provides an overview of the high …

SQL SERVER – How to Fix log_reuse_wait_desc – AVAILABILITY_REPLICA?

Publié le 18 septembre 2018 sur journey to sqlauthority

Earlier this week I had multiple engagements of Comprehensive Database Performance Health Check. While working with one of the customers we realized that when we query sys.databases for one of the databases, we always see column log_reuse_wai …

Power BI Introduction: Publishing Reports to the Power BI Service — Part 8

Publié le 17 septembre 2018 sur

The series so far: Power BI Introduction: Tour of Power BI — Part 1 Power BI Introduction: Working with Power BI Desktop — Part 2 Power BI Introduction: Working with R Scripts in Power BI Desktop — Part 3 Power BI Introduction: Workin …

Free Training Classes for Those Who Give Back: Announcing our 2019 Scholarships

Publié le 17 septembre 2018 sur

You work at a charity or non-profit, helping them make a difference with data. Maybe you write reports to help fundraisers do a better job of raising money to find a cure for a disease. Or maybe you’re a developer at a non-government organization …

Pages :