SQL Server Join Example
What are all of the JOIN options in SQL Server? What is the significance of each of the options? How does the syntax work? Jeremy Kadlec answers these questions and more. How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new article, …
How to Move a Table to a Different File Group
There may be a time when you want to move a table from one file group to another. It’s easy if it contains a clustered index. Read on to learn more.
Small benchmark for Tabular and Power BI formula engine (FE) #ssas #tabular #powerbi
If you run SSAS Tabular or Power BI, please help me in gathering some performance data for a study I’m doing about Formula Engine performance following these steps: 1) Copy the PowerShell code below in a script Benchmark.ps1, modifying serverName, …
SQL Azure Database – Msg 40197, Level 20 – The Service has Encountered an Error Processing Your Request. Please Try Again. Error Code 40549
While trying to help one of my clients, I was shown below error which was received using bulk insert command. The command was used to move data from Azure Blob Storage to SQL Azure Database. Let us see how to fix the error processing request. Msg 40197 …
SQLskills SQL101: Query plans based on what’s in memory
As Kimberly blogged about recently, SQLskills is embarking on a new initiative to blog about basic topics, which we’re calling SQL101. We’ll all be blogging about things that we often see done incorrectly, technologies used t …
Visual Studio Code
Visual Studio Code is a free, relatively new (late 2016), open source, cross platform tool for editing code. I like the Git integration. It doesn’t right out of the box support SQL, but it’s easy to add it as shown below. It’s really …
Free Webinar: Enterprise SSIS, Biml, and DILM
Enterprise Data & Analytics present Enterprise SSIS, Biml, and DILM – a free webinar 11 Jul 2017 at 1:00 PM. Register today! In case you missed it, the recording for our last free webinar – Designing an SSIS Framework – is available. :{ …
Anatomy Of An Adaptive Join
I don’t like it unless it’s brand new When new features drop, not everyone has time to jump on top of them and start looking at stuff. That’s what consultants with nothing better to do are for. I’ve been excited about this featu …
Build Dynamic Backup Locations with Minion Backup
See how Minionware Backup gives you the ability to customize backup files and locations.
Why is my clone so small?
Using very few megabytes and taking very little time, SQL Clone can quickly creates multiple copies of very large databases. How? It might sound like magic, but it’s not; in this blog post Redgate developer Chris Hurley goes into the details of how the …
Stairway to DAX and Power BI – Level 7: Function / Iterator Function Pairs: The DAX AVERAGE() and AVERAGEX() Functions
Business Intelligence architect, Analysis Services Maestro, and author Bill Pearson explores the DAX AVERAGE() and AVERAGEX() functions, comparing and contrasting the two. He then provides some hands-on exposure to the use of each, particularly in comb …
SQL SERVER – Database Mirroring Login Attempt Failed With Error: ‘Connection Handshake Failed. There is No Compatible Encryption Algorithm. State 22
One of my client was trying to convert database mirroring to the AlwaysOn availability group. They had a mirroring configure where the principal server was going to become a primary replica. When they attempted to join the AG, it was failing with an er …
UPDATED: Use Amazon’s Alexa to Create a Copy of a Database Using Redgate SQL Clone…
Please help: If you commented below please email me by clicking the Email link and sending me an email. Redgate wants to notify the winners! Thank you, Andy …and win an Amazon Echo Dot and one lucky winner will score a free SQL Clone license! Ab …
The Recording for Designing an SSIS Framework is Now Available
Kent Bradshaw and I had a great crowd, lots of awesome questions, and delivered good demonstrations at the Designing an SSIS Framework webinar. You can now view the webinar for free (although registration is required) here . In the webinar Kent and I d …
Presenting Intelligent Data Integration Precon at SQL Saturday–Louisville!
I am honored to present Intelligent Data Integration – a day-long precon at SQL Saturday #643 in Louisville Kentucky 4 Aug 2017! Synopsis : What is Intelligent Data Integration? SSIS packages developed using tried and true design patterns, built …