Sites anglophones


Detecting Problems on Databases that use Snapshot-based Transaction Isolation

Publié le 26 avril 2018 sur sqlservercentral.com
 

If you’re using SQL Server’s Read Committed Snapshot Isolation level (RCSI) to avoid long waits for a blocked resource, then you’ll want to monitor for possible side effects. This article describes one way to monitor for such problems …

PowerShell – Get Maximum Memory of Server with dbatools

Publié le 26 avril 2018 sur journey to sqlauthority
 

Yesterday I blogged about the very famous Powershell free community tool dbatools. After writing this blog post, I received some interesting emails. I think lots of people confused this with native PowerShell. Well, actually dbatools is build using Pow …

Concurrency Week: How Entity Framework and NHibernate Can Cause Poison RESOURCE_SEMAPHORE Waits

Publié le 25 avril 2018 sur brentozar.com
 

I’ve already blogged about my dislike for ORMs from a production DBA performance tuning standpoint only. I get that they’re useful to developers. I get it. But I’m focused on performance. A quick recap of what I don’t like about …

Shift LEFT magazine: Issue 3

Publié le 25 avril 2018 sur sqlservercentral.com
 

The latest issue of Redgate’s Database DevOps magazine explores the benefits of DevOps for CEOs, CIOs, and IT Managers, and takes a comprehensive look at the new General Data Protection Regulation, providing a valuable insight into how organizati …

PowerShell – How to Install dbatools?

Publié le 25 avril 2018 sur journey to sqlauthority
 

One of the most popular questions any PowerShell expert would receive is how to install the most popular dbatools based on Powershell scripts? Well, first of all, I was never a PowerShell fan, to begin with as I believed it as a totally different …

Concurrency Week: Can SELECTs Win Deadlocks?

Publié le 24 avril 2018 sur brentozar.com
 

Yes, especially when they’re part of a larger transaction. In this example, I’m going to use a database in Read Committed Snapshot Isolation (RCSI), my favorite isolation level for building new applications from the ground up. Optimistic co …

Approaches to masking email addresses

Publié le 24 avril 2018 sur sqlservercentral.com
 

There are several ways to to anonymize / pseudonymize email addresses. This post discusses a few frequently used approaches, as well as how you can use Redgate Data Masker for SQL Server to achieve realistic masking of email columns.

Alerts and Notfications for SQL Server Login, Database User and Role Membership Changes

Publié le 24 avril 2018 sur sqlservercentral.com
 

Check out these scripts to create SQL Server jobs and Alerts when a login is created or dropped, a database user is added or dropped and when logins are added or removed from server roles or users are added or removed from database roles.

SQL SERVER – Script – Transaction Log Backups Based on Growth / Size

Publié le 24 avril 2018 sur journey to sqlauthority
 

While doing a comprehensive health check of the SQL Server, one of the things I check is the backup plan for the production databases. Many times, I have run into a situation where a customer says “Transaction log file of the database has grown m …

SQL Server Graph Databases – Part 4: Working with hierarchical data in a graph database

Publié le 23 avril 2018 sur simple-talk.com
 

The series so far: SQL Server Graph Databases – Part 1: Introduction SQL Server Graph Databases – Part 2: Querying Data in a Graph Database SQL Server Graph Databases – Part 3: Modifying Data in a Graph Database SQL Server Graph Databases …

Building SQL ConstantCare®: Why We Avoided Graphs

Publié le 23 avril 2018 sur brentozar.com
 

When we started building SQL ConstantCare®, one of my early decisions was to focus on a text-based interface. I wanted to just simply tell you what I’d do in your shoes. If users wanted to see more evidence behind the recommendation …

Cancelling DBCC SHRINKFILE with EMPTYFILE

Publié le 23 avril 2018 sur sqlservercentral.com
 

A fun experiment using DBCC SHRINKFILE to rebalance data.

Custom Metrics for Detecting Problems with Ad-hoc Queries

Publié le 23 avril 2018 sur sqlservercentral.com
 

A common SQL Server crime is the unnecessary overuse of ad-hoc queries by applications. In this article, Phil Factor shares some custom queries for monitoring problems that can be caused by this.

Spring into the Latest Features at the Luxemborg User Group

Publié le 23 avril 2018 sur sqlservercentral.com
 

The next meeting of the Luxemborg SQL Server User Group has some great sessions planned.

SQL SERVER – SharePoint not Working After Failover to Another Node

Publié le 23 avril 2018 sur journey to sqlauthority
 

Anything that can go wrong will go wrong while Murphy is out of town. While I was onsite to help a client, one such issue had cropped up in their SharePoint environment where SQL Server was used as backend and was a part of Windows failover cluster. Wh …


Pages :