How to Restore a SQL Server Database into Azure SQL DB Managed Instances
You’ve built your first Managed Instance, and now you wanna play around with real live data. You’re going to need a backup in the cloud to do it – SSMS doesn’t have a drag-and-drop option. Big picture, here’s what we …
How to Deploy Your First Azure SQL DB Managed Instance Preview
The Azure SQL DB Managed Instance public preview is open, although it may take a week or two for new applications to get their new VMs. To start your application process now, go into your Azure portal and Create an Azure SQL Managed Instance. There are …
Take the SQL Estate Data Mapping Survey and help shape Redgate’s products
Help Redgate to learn more about how SQL Server teams keep on top of sensitive data. If you’re planning, or are already implementing, an information audit or data-mapping exercise for your SQL Server estate, please complete our short survey.
Data Encryption Using Always Encrypted in SQL Server
The key challenge for application developers is to build a foolproof system to ensure data security. This is not only more intense, but more complex these days, as many organizations are planning to move their applications to the cloud. Read on to lear …
SQL SERVER – Creating Temporary and Global Temporary Stored Procedures
During recent Comprehensive Database Performance Health Check, I had a very interesting situation I encountered where we found a stored procedure which was a root cause of the slowness. What we needed to do is to change the code and test if our ne …
Why sp_prepare Isn’t as “Good” as sp_executesql for Performance
sp_prepare For Mediocre You may remember me from movies like Optimize for… Mediocre? and Why You’re Tuning Stored Procedures Wrong (the Problem with Local Variables)! Great posts, Kendra! Following the same theme, we found this issue …
Extending DevOps to the database with Redgate: the role of automated testing
This webinar will show you how to use Redgate’s SQL Test to include automated testing as part of a database DevOps workflow. There will be a walk-through of an automated build and deployment process with DLM Automation in VSTS, and plenty of time to as …
SharePoint Disaster Recovery Plan
Hot standby disaster recovery process where SharePoint farm will become available in minutes
What is the ROI of a SQL Server Monitoring Tool?
The increasing size of SQL Server databases, alongside the growing complexity of SQL Server estates, is making more organizations realize the need for a tool that enables proactive monitoring. Let us try to answer a question – What is the RO …
How to Use Conditional SQL Agent Job Flows with AlwaysOn Availability Groups
To most effectively leverage high-availability capabilities, database administrators must have an understanding of the key issues involved with working with SQL Server Agent and AlwaysOn Availability Groups. Here’s what you need to know (including code …
My #AWSsummit keynote liveblog
The company I work for, Perion, chose Amazon Web Services as a main cloud provider for managing and operating our applications. These days I am learning how to manage databases and data related flows in the AWS cloud. Which is the reason I have attende …
“Full Stack” Means “Part Time” – or Why DBAs Might Wanna Learn DevOps
Long before the “full stack developer” phrase became fashionable, us early developers did exactly that. We didn’t do any of these full time, mind you – full stack doesn’t mean full time. Here’s a grid I use to e …
Stairway to U-SQL Level 20: Querying External Data with U-SQL
Did you know you can query SQL Server data with U-SQL? It’s true! Find out how in this latest stairway step.
SQL SERVER – Database Attach Failure – Msg 2571 – User ‘guest’ Does Not Have Permission to Run DBCC Checkprimaryfile.
One of my clients was trying to recover from a disaster and wanted to attach the MDF and LDF files. While trying to do that, they encountered an error. In this blog we would learn about how to fix the error – User ‘guest’ does not hav …
SQL Server Diagnostic Information Queries for March 2018
This month, there are more minor updates to the all of the versions of the queries, primarily in the comments and documentation. I have made the most changes to the SQL Server 2017 version this month. I have also developed a T-SQL script that you can u …