Accelerated Database Recovery in SQL Server 2019
An Overview of Traditional Recovery As with all relational database systems, SQL Server guarantees...
Using Alerts and Operators in SQL Server
Introduction With all the advancements in SQL Server and data, it feels great that such native SQL tools as Alerts and Operators are still...
Deploying a SQL Server Docker Container
Introduction Containerization has become the dominant topic after the Server Virtualization and Cloud Computing Eras. While many thought...
Filtering Data in T-SQL
Introduction In most scenarios when working with data, users do not require all the data in each...
Using Transaction ROLLBACK in SQL Server
Introduction Very recently, a colleague of mine came to me in desperation owning up that he had issued an update statement without a WHERE...
SQL Always On Availability Groups: Computer Objects
SQL Server Always On Availability Groups is Microsoft’s latest technology for addressing the High Availability and Disaster Recovery...
Switching Out Table Partitions in SQL Server: A Walkthrough
Introduction A few years ago we were tasked with a business requirement for card data in a specific...
AlwaysOn Availability Groups: Quorum
SQL Server AlwaysOn Availability Groups is Microsoft’s latest technology for addressing the High Availability and Disaster Recovery needs...
Everything you Need to Know about Database Normalization
The Relational Model of data management was first developed by Dr. Edgar F. Codd in 1969. Modern relational database management systems...
Parameter Sniffing Primer
Introduction Developers are often told to use stored procedures in order to avoid the so-called ad...
