Statistics in SQL: Pearson’s Correlation
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
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
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
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
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
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.
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
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
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
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.
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
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
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
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
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 …