Azure DWH part 26: Creating your ASDW in Cloud Shell using PowerShell
In this article, we will show how to create an ASDW in PowerShell using the Cloud Shell.
How to Test SQL Server Functions and Procedures using SQL Prompt
When writing functions or procedures, a common chore is to devise and implement the tests that ensure that the routine always works as expected.
SQL SERVER – Don’t Ignore Warning: Cluster Resource DLL Update Restart Check
This was one of the hard lessons learned, so I am sharing with blog readers. This is about an error in cluster resource DLL. While applying the patch to SQL instance, I cluster, sometimes we get warning “Cluster Resource DLL Update Restart Check. …
How to Suck at Database Admininstration
This isn’t about having a sucky job, this is about you sucking at your job. There’s a big difference. You could be sucking at your job because you hate your job and just don’t care. I get that. In that case though, you know better but …
Calculating DTU’s for Azure SQL Database
This calculator will help you determine the number of DTUs for your existing SQL Server database(s) as well as a recommendation of the minimum performance level and service tier that you need before you migrate to Azure SQL Database.
Solving SQL Server Performance Issues Caused by Problematic SQL Queries – The Tools You’ll Need
Date: Wednesday, March 21, 2018Time: 12:00 PM Eastern Daylight TimeDuration: 1 hour The added time it takes to process problematic SQL queries costs significant money. So does the effort to resolve and improve those queries unless you use effective t
SQL SERVER – Unable to Connect to SQL Server in Azure Virtual Machine from SSMS on On-Premise Machine
From past few months, I am seeing a few of my client moving their development workload to Cloud. When I asked the reason, it was mostly cost reduction in terms of hardware lifetime, licensing and connectivity advantage and their developer can work from …
T-SQL Tuesday #99: Home Brewing
It is T-SQL Tuesday time for February 2018, which is being hosted by Aaron Bertrand. One of the choices that Aaron offered was to write about something you are passionate about, outside of the SQL Server or tech community. T-SQL Tuesday Making Beer at …
#TSQL2sday: What I’m Passionate About – Sas Christian’s Art
For this month’s T-SQLTuesday, Aaron Bertrand asked what we’re passionate about – but outside of the tech community, and asked for pictures. Seems like a great way to get to know about us. From my personal blog and my Instagram feed, …
How to monitor the impact of patching on SQL Server performance
In this article, Redgate use the Spectre/Meltdown bugs as means to demonstrate how you can use a tool like SQL Monitor to assess the impact of patching on your SQL Server estate. How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new …
Restore a Database with CDC Enabled
In this post, I’m going to talk about an issue that I found while restoring a backup of CDC enabled database to different SQL instance. You may receive below warning message that includes information about the cause of the warning, which can help …
Updating an expired SQL Server TDE certificate
Simon Liew explains how to generate a new TDE certificate to replace the previous, and also looks at the steps needed if the database is in an Availability Group.
SQL SERVER – Script Level Upgrade for Database ‘master’ Failed Because Upgrade Step ‘sqlagent100_msdb_upgrade.sql’ – Error: 5041: MODIFY FILE Failed
I have helped many clients in upgrade failures via my On-Demand consulting and I am amazed to see various ways which can break SQL Server upgrade. In this blog we would learn about fixing error Script level upgrade for database ‘master’ fai …
Attending our SQLBits Pre-Con? Prepare Your Laptop Now.
If you’re joining Erik & I at our SQLBits precon, Expert Performance Tuning for SQL Server 2016 & 2017, you’ll be able to follow along with the demos on your laptop. We’re going to be showing you some common and not-so-common …
Baselining a ReadyRoll project from an existing database
When creating a new ReadyRoll project, the schema of your production environment can also be imported as a baseline. Further work can be built on top of the baseline in a sandbox development environment and, when you’re happy with the changes, th …