CLOUD SQL 

SQL Server Script to Determine Free Space Prior to SQL Server Backup

By: Eli Leiba   |   Read Comments (2)   |   Related Tips: More > Backup Problem We need to create a simple piece of T-SQL code that will pre-check the free disk drive space and estimate the database backup size to determine if there is enough space to run the BACKUP DATABASE statement for the selected disk drive.  This tool can be used to prevent errors concerning lack of disk space during the backup process and can save time of doing…

Read More
CLOUD SQL 

Create Custom Widget in SQL Server Operations Studio

By: Nisarg Upadhyay   |   Read Comments   |   Related Tips: More > SQL Server Management Studio Problem In this article, I am going to explain how to add a custom widget to SQL Server Operations Studio. Solution SQL Server Operations Studio is a cross platform, open source database management tool. It is platform independent hence it can be installed on Windows, Linux and macOS. It can be used to manage SQL Server running on any OS platform. We can…

Read More
CLOUD SQL 

Script triggers from any database in SQL Server

By: Aaron Bertrand   |   Read Comments   |   Related Tips: More > Triggers Problem There are a few scenarios (such as re-initializing replication) where users need to perform an action on all triggers in a database – disable, enable, or script out for source control. Is there a quick way to do this that is easier than pointing and clicking through the Object Explorer tree in SQL Server Management Studio (SSMS)? Solution Many tasks that you can accomplish…

Read More
CLOUD SQL 

Script for SQL Server Agent Job Issues Across All Instances

By: Pablo Echeverria   |   Read Comments   |   Related Tips: More > SQL Server Agent Problem There’s a chance your SQL Server Agent Jobs that have been running smoothly forever, but suddenly for no apparent reason they fail. And when you have a team supporting multiple servers, there’s no guarantee that all jobs have been set up to notify you on failure. Moreover, there are multiple situations that you want to be aware, not only failures such as: …

Read More
CLOUD SQL 

SQL Server Management Studio 2017 Data Discovery and Categorization

By: Scott Murray   |   Read Comments   |   Related Tips: More > SQL Server 2017 Problem How does the new data discovery and categorization features in SQL Server Management Studio 2017 work? Solution For many years, it seemed that SQL Server Management Studio (SSMS) languished as the basic go to tool for SQL Server querying and management, but very few new features were added. With the recent revision of SSMS 2017, one very beneficial new feature was implemented.…

Read More
CLOUD SQL 

Security Benefits for SQL Server Temporal Tables – Part 2

By: Ameena Lalani   |   Read Comments   |   Related Tips: More > Temporal Tables Problem You may have heard about SQL Server Temporal Tables by now, but do you know all the benefits of using them? In this tip we look at some of the benefits and uses of SQL Server Temporal Tables. Solution In part 1 of this series on benefits of Temporal Tables we discussed recovering data from updates and deletes. We saw how we…

Read More
CLOUD SQL 

How to apply Microsoft SharePoint 2013 Cumulative Updates and Handling Issues

By: Deepak Kumeri   |   Read Comments (1)   |   Related Tips: > Sharepoint Problem In this tip, I will describe the process of applying SharePoint cumulative updates to SharePoint Farms, as well as address common issues. First, what are SharePoint cumulative updates (CUs)? SharePoint CUs contain hotfixes to resolve known issues since the release of SharePoint 2013. They’re applicable to any version of SharePoint. Applying hotfixes keeps your SharePoint farm healthy and free from vulnerabilities. What’s more, Microsoft will…

Read More
CLOUD SQL 

5 Key Content Areas to Focus on During Interview Preparation

By: Erica Woods   |   Read Comments   |   Related Tips: More > Professional Development Interviewing Problem “I absolutely dread interviewing.” “I get nervous and forget everything I wanted to say.” “I struggle with talking about my accomplishments.” “I have so much anxiety that I can’t articulate my skills and answer questions well.” “I go off on tangents because I’m so nervous.” “I feel so insecure in interviews.” During the interview coaching conversations, statements like these are …

Read More
CLOUD SQL 

How to Save Costs on Non-Production SQL Server RDS Instances

By: Sadequl Hussain   |   Read Comments   |   Related Tips: More > Cloud Computing Problem We are trying to streamline our AWS resource expenses. The DBA team says we are running a number of RDS servers in our AWS accounts. Right now, we need those instances, so we can’t delete them. Is there any way we can save costs of those instances? Are there any quick wins we can have? Solution Amazon Relational Database Service (RDS) is a managed…

Read More
CLOUD SQL 

Load data from PDF file into SQL Server 2017 with R

By: Siddharth Mehta   |   Read Comments (1)   |   Related Tips: More > SQL Server 2017 Problem Portable Document Format (PDF) is one of the most prominent office document file formats apart from other formats like Work, Excel and PowerPoint and needs no introduction. Almost everyone who works with office documents would have worked with PDFs at least once. A very common usage pattern is that documents are generally authored in Microsoft Word, then at a certain stage they are…

Read More