Sites anglophones

Masking Your Data with SQL Server 2016

Publié le 29 septembre 2016 sur

There are times when you want some users to see part of a column value but not the whole thing, but you want other users to see the complete column value without any masking. The new SQL Server 2016 Dynamic Data Masking feature will allow you to define …

New Redgate SQL Compare 12 has landed!

Publié le 29 septembre 2016 sur

SQL Compare 12 has landed with a brand new user interface, support for SQL Server 2016, and a wealth of fixes and improvements. Check out this blog post from Redgate’s Carly Meichen to hear more about what’s new, why the team have built it, and h …

Installing R packages in SQL Server R Services

Publié le 29 septembre 2016 sur

This article shows four ways you can use when installing missing R packages for Microsoft R Services.

SQL SERVER – SSMS Trick – Switching Columns in Grid Output

Publié le 29 septembre 2016 sur journey to sqlauthority

Yesterday when I wrote about what I learnt from Vinod’s session at the SQL Server User Group meeting, one of my friends wrote back asking what else was discussed. Though I knew some of the tips and tricks he showed as part of the sessions, t …

The HPE Superdome X Gen9 Provides Significant Performance Boost over Predecessor

Publié le 28 septembre 2016 sur

HPE designed the Superdome X line as an enterprise-class server platform from the get-go, and the company has continued to evolve the system ever since. For example, the new Gen 9-based Superdome X provides significant performance increases over the Ge …

Are You Load Testing for Best Case Scenario, or Worst Case?

Publié le 28 septembre 2016 sur

In preparation for a recent load testing engagement, we started talking about the company’s goals. The DBA said something really insightful: “We want to get to 1,000 page requests per second, which is around 5,000 batch requests per second. …

Faster DBCC CHECKDB with SQL Server 2016

Publié le 28 septembre 2016 sur

DBCC CHECKDB is a built-in SQL Server command that allows you to check database integrity and consistency in one simple command, but running it on large databases can be a nightmare. In this article, Ahmad Yaseen explains how you can enhance the comman …

Stairway to Exploring Database Metadata Level 3: Exploring Indexes

Publié le 28 septembre 2016 sur

This level of the Stairway to Exploring Database Metadata focuses on indexes and all the information you can gather about them.

SQL SERVER – Hidden SSMS Gem: Find Dialog’s Unknown Functionality

Publié le 28 septembre 2016 sur journey to sqlauthority

I have an eye for details and I try to keep looking for something new to some of the tasks I have been doing for years together. This exploration and quest to learn new techniques is what has made me survive longer in this industry I suppose. So let me …

SQLintersection Fall 2016

Publié le 27 septembre 2016 sur - paul randall

As we head into our 8th SQLintersection next month, I’m excited to say that it’s our most diverse, complete, and information-packed show yet! We have 3 precon days at the show and with our postcon day, there are 10  …

What To Do If sp_BlitzFirst Warns About High Compilations

Publié le 27 septembre 2016 sur

Compiles Aren’t The Same As Recompiles If you’re seeing high RECOMPILES, this post isn’t for you. We’ll talk about the differences between compiles and recompiles, but not how to troubleshoot recompiles. Recompiles mean one of t …

PowerShell Solutions – Several tips for daily tasks

Publié le 27 septembre 2016 sur

In this tip, we will talk about PowerShell and SQL Server Log and Data Files.

PowerShell Desired State Configuration: DSC Resources

Publié le 27 septembre 2016 sur

Desired State Configuration (DSC) allows you to automate the way that you manage configuration data for software services as well as the environment in which these services run. DSC uses a set of built-in and custom ‘resources’ as the building blocks f …

SQL SERVER – How to Find Out When Your SQL Login Will Expire?

Publié le 27 septembre 2016 sur journey to sqlauthority

If you are a SQLDBA, you must have created a login and you must have known about enforcing password policy to SQL Logins. Once of my client asked to provide script to find expiry details about SQL Login.  It was an easy task. I went to books …

PASS Summit – Free Thursday NIght

Publié le 26 septembre 2016 sur

It was recently pointed out that there is no official event scheduled for Thursday night the week of the PASS Summit this year. I am fine with that. By the time Thursday rolls around, I might want to use that time to catch up on sleep. 🙂 Seriously, t …

Pages :