Sites anglophones


Statistics in SQL: Pearson’s Correlation

Publié le 6 avril 2017 sur simple-talk.com
 

When you have two variables, one of the first questions you’d probably like to ask is, ‘how closely are they related?’ These variables could be attributes whose values come from measurements, scores or other types of quantity. Are you …

Comparing SSIS Catalog Contents Using DBFit Framework

Publié le 6 avril 2017 sur simple-talk.com
 

Unfortunately you can’t easily compare SQL Server Integration Services (SSIS) projects with previous versions of the same projects. Because of this, it is very difficult to detect potential problems with a release before a deployment takes place. …

Announcing Our Summer/Fall Training Schedule and Instant Video Access

Publié le 6 avril 2017 sur brentozar.com
 

I had a great time in San Diego over the last couple of weeks teaching classes. I’d love to be able to have every training class where we can do breakfast & lunch outdoors! Performance Tuning Class, San Diego, March 2017 Buuut, we gotta move …

SQL Server Cluster Automatic Memory Management

Publié le 6 avril 2017 sur sqlservercentral.com
 

Don’t waste memory in a cluster! Learn how to allocate memory between instances. 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 o …

Clean Your Buffers for Accurate Performance Testing

Publié le 6 avril 2017 sur sqlservercentral.com
 

In order to do accurate performance testing between multiple runs of a SQL Server command or scripts you need to remember to clean the buffer, procedure and system cache between each test run.

SQL SERVER – Script to Audit Login and Role Member Change

Publié le 6 avril 2017 sur journey to sqlauthority
 

Once there was a security breach on my client machine and they wanted to know who made changes to the SysAdmin role. They contacted me and my first question was that, are you are auditing such changes and as expected answer was No. I gave them answer t …

Announcing Our New DBA Job Interview Q&A Course.

Publié le 5 avril 2017 sur brentozar.com
 

Whether you’re applying for a DBA job or getting ready to hire a DBA, you probably don’t know what questions to ask to tell if somebody really knows what they’re doing or not – or what answers to look for. There’s the clas …

Data Warehousing in the cloud – Azure Style

Publié le 5 avril 2017 sur sqlservercentral.com
 

Learn about Azure SQL Data Warehouse and how to get started. 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 bottlenec …

PowerShell Time Saver: Automatic Defaults

Publié le 5 avril 2017 sur sqlservercentral.com
 

Because PowerShell needs to be usable as an immediate scripting language by IT professionals who type in commands at a console, there have to be language devices such as aliases that can make for terseness when appropriate. There are several ways of cu …

SQL SERVER – Msg 3136, Level 16 – This Differential Backup Cannot be Restored Because the Database has not Been Restored to the Correct Earlier State

Publié le 5 avril 2017 sur journey to sqlauthority
 

I was trying to teach copy-only backups to my students and encountered below error related to differential backup. Msg 3136, Level 16, State 1, Line 28 This differential backup cannot be restored because the database has not been restored to correct th …

Announcing Monthly Training Subscriptions and Some Cool Perks.

Publié le 4 avril 2017 sur brentozar.com
 

We’ve been selling training videos for a few years now, and we’ve figured out that we have two kinds of buyers: Price-sensitive short-term customers – who are often paying out of their own pocket because their company won’t pay, …

SQL Clone Trivia Quiz – win a $10 gift card every weekday in April

Publié le 4 avril 2017 sur sqlservercentral.com
 

To celebrate the recent launch of their new database provision tool, Redgate are giving you the chance to win a $10 Amazon or Starbucks gift card every weekday this month. To enter the prize draw, just answer the daily SQL Clone trivia question on the …

Using DBCC CLONEDATABASE and Query Store for Testing

Publié le 4 avril 2017 sur sqlservercentral.com
 

Erin Stellato demonstrates how to use the new DBCC CLONEDATABASE feature, in combination with Query Store, to test index and query changes. How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new article, Simple-Talk editor Tony Davis …

SQL Login Password Audit

Publié le 4 avril 2017 sur sqlservercentral.com
 

Audit your SQL logins to find passwords that have never been changed or that are very weak.

SQL SERVER – Msg 3101, Level 16 – Exclusive Access Could not be Obtained Because the Database is in Use

Publié le 4 avril 2017 sur journey to sqlauthority
 

This error might have seen by DBAs and they know how to fix it. This blog goes in little details about what are the various options available. Here is the simple reproduction of the error message related to exclusive access. USE master GO CREATE DATABA …


Pages :