In this article, we will explore how to find the SQL Server version details with various methods.
Read more »
Overview of SQL Server Aliases
October 7, 2019This article gives an overview of SQL Server Alias and its usage for connecting with SQL Server.
Read more »
Enforce SSL connections in AWS RDS SQL Server
October 7, 2019This article explores a method to enforce SSL for all connections in AWS RDS SQL Server.
Read more »
How to create and configure a linked server to connect to MySQL in SQL Server Management Studio
October 7, 2019This article will guide you with all the necessary steps to successfully create a linked server in SSMS to connect to the MySQL database.
Read more »
Pseudo-Simple SQL Server Recovery Model
October 7, 2019This article gives an overview of the Pseudo Simple SQL Server Recovery Model. It also explores the conditions in which the database behaves in Pseudo mode.
Read more »
How to rename tables in SQL Server with the sp_rename command
October 7, 2019In this article, we will learn to rename tables in SQL Server. sp_rename is a built-in stored procedure which helps to rename user tables in the SQL Server. During the software development life cycle, we might be faced with various scenarios that required to rename the existing tables in the database. For example, the tables which are created in the SQL Server might be needed to be renamed, because of the software version upgrades, bug fixing or other various development requirements. These and similar reasons can make renaming tables important. So, in this article, we will particularly focus on how to rename the tables in SQL Server.
Read more »
SSIS Connection Managers: OLE DB vs ODBC vs ADO.NET
October 4, 2019In this article, I will first give an overview of the OLE DB, ODBC, and ADO.NET SSIS connection managers. Then I will try to illustrate the difference between them when trying to connect to SQL Server.
Read more »
Encrypted Backup and Restore in AWS RDS SQL Server
October 4, 2019In the article, Recover Data in AWS RDS SQL Server, we explored the process of native backup and restoration for the AWS RDS SQL Server database. It involves the following steps:
Read more »
Database Level DDL Triggers for Views, Procedures and Functions
October 4, 2019In this article, we will un-riddle the ways to make use of the data definition language trigger (DDL Trigger), in order to monitor the progressions made to the database programming objects, View, Procedure or Function with a few real-time examples.
Read more »
SSIS Data types: Change from the Advanced Editor vs Data Conversion Transformations
October 4, 2019In this article, I will first give an overview of SSIS data types and data types conversion methods and then I will illustrate the difference between changing the columns data types from the Source Advanced editor and using Data Conversion Transformation.
Read more »
Piecemeal Database Restores in SQL Server
October 3, 2019This article explores the piecemeal database restore SQL Server feature and its benefits to minimize the database restoration.
Read more »
SQL Server Transaction Log Interview Questions
October 3, 2019In this article, we will discuss some important SQL Server Transaction Log interview questions that you may be asked during a SQL Server administrator or developer technical job interview.
Read more »
SQL Server Auditing Interview Questions
October 3, 2019In this article, we will discuss a number of common and important SQL Server Audit questions that you may be asked during the SQL Server database administrator interview. I advise you to check them out and get ready for the interview.
Read more »
SQL Server Database Metrics
October 2, 2019Summary
There is a multitude of database metrics that we can collect and use to help us understand database and server resource consumption, as well as overall usage.
This data can include hardware statistics, such as measures of CPU or memory consumed over time. We can also examine database metadata, including row counts, waits, and deadlocks.
Read more »
SQL Server PRINT and SQL Server RAISERROR statements
October 2, 2019This article explores the SQL Server PRINT statements, and its alternative SQL Server RAISEERROR statements to print messages in a query.
Read more »
Using SQL Server Database Metrics to Predict Application Problems
September 27, 2019Summary
Database metrics can be collected, maintained, and used to help predict when processes go awry so problems can be resolved before they become severe. Understanding when an application or process misbehaves is not always easy. We are often left waiting until a server, application, or service breaks or enters an undesirable state before we know something is wrong. At that point, we are forced to rush and resolve a production problem quickly, before its impact becomes severe.
Read more »
Recover Data in AWS RDS SQL Server
September 27, 2019This article explores the process to recover data in AWS RDS SQL Server and its recent enhancements.
Read more »
An Overview of Instant File Initialization in SQL Server
September 25, 2019This article gives an overview of Instant File Initialization and its benefits for SQL Server database creation, restoration and file growth.
Read more »
SSIS Derived Columns with Multiple Expressions vs Multiple Transformations
September 25, 2019In this article, we will first give an overview on SSIS derived column transformation, then we will run an experiment to check if there is any difference between adding multiple expressions within one derived column transformation and adding a derived column transformation for each expression.
Read more »
MySQL Query (T-SQL) Tutorial for SQL Server
September 25, 2019Microsoft SQL Server and MySQL, both are quite well-established database engines. In our role as a DBA, at some given time point we require T-SQL straddling between both database engines unites Select, Insert, Update, Delete and some other…
Read more »
Truncate Table Operations in SQL Server
September 25, 2019Truncating a table is removing all the records in an entire table or a table partition. TRUNCATE table is functionally similar to DELETE table with no WHERE clause. However, TRUNCATE table is much faster than DELETE with respect to the time and the resource consumptions which we will look at in this article. TRUNCATE statement removes the data by de-allocating the data pages in the table data. This means that TRUNCATE is similar to drop and re-create the table. Also, it records only the page de-allocations in the transaction log, not the row-wise as in DELETE statement.
Read more »
Database Level DDL Triggers on Tables
September 23, 2019This article portrays the different utilization of database DDL Triggers for the Tables with a counting mail alert on schema composition using DDL (Data Definition Language) standard. Using that efficient method we can keep close eyes on monitoring schema changes in any database of SQL Server. We’ll also see how we could monitor these movements and send an alert email to persons responsible to inform about this change.
Read more »
SQL Server Execution Plan Interview Questions
September 20, 2019In this article, we will discuss a few very common questions that you may be asked during a SQL Server administrator or developer technical job interview.
Read more »
Recover a lost SA password
September 20, 2019In this article, we will review how to recover SA password by starting SQL Server in single user mode when you forget “sa” credentials or lose the access to the instances due to the following reasons:
Read more »
Alternate Row Colors in SSRS
September 20, 2019Setting alternate row colors in SSRS (SQL Server Reporting Services) is an important visualization configuration for end-users so that they can easily view their reports. However, setting alternate colors in SSRS is not a click of a button configuration like in the Microsoft Excel.
Read more »