SQL TRIM Function April 24, 2019 by Rajendra Gupta In this article, we will review the new SQL TRIM function in SQL Server 2017 onwards as well as providing some information on strings functions that pre-date it like LTRIM AND RTRIM. Read more »
DATEPART SQL function April 23, 2019 by Rajendra Gupta This article explores the DATEPART SQL function and its use in writing t-SQL queries. In the previous article, SQL Convert Date Functions and Formats, we explored various data formats and convert them using SQL Convert function.
SQL Add Column operations April 22, 2019 by Rajendra Gupta This article explains the SQL add column operation into an existing SQL table. We will also explore different examples of SQL add column operations. Read more »
Using the SQL Server Audit Feature to Audit Different Actions April 22, 2019 by Ahmad Yaseen In the previous article of the SQL Server Audit series, SQL Server Audit Feature Components, we discussed the three main components of the SQL Server Audit feature; the SQL Server Audit, the Server Audit Specifications, and the Database Audit Specifications in details. In this article, we will show how to use the SQL Server Audit feature to track, log and review the different operations performed at both the SQL Server and the database levels. Read more »
SQL Server Transaction Log Administration Best Practices April 22, 2019 by Ahmad Yaseen In this article, we will go through a number of SQL Server Transaction Log recommendations and best practices that each database administrator needs to follow in order to enjoy his holidays and have a pleasant sleep without nightmares or calls during the night. Read more »
How to use fake tables in SQL unit testing? April 22, 2019 by Esat Erkec In this article on SQL unit testing, we will talk about how to isolate SQL unit tests from dependencies and how to use fake tables in SQL unit tests, so that we will able to develop more robust and less fragile SQL unit tests. Read more »
Fundamentals of Test-Driven Database Development (TDDD) with tSQLt unit testing April 19, 2019 by Haroon Ashraf This article talks about core concepts of test-driven database development followed by creating simple SQL unit tests with tSQLt based on this approach. Read more »
PowerShell encrypt password techniques for SQL Server April 18, 2019 by Milan Rancic Challenge Automating SQL Server tasks with PowerShell can increase productivity and save time, but how do use PowerShell encrypt password techniques to avoid saving them as plain text. This article will show you how. Read more »
SQL Union vs Union All in SQL Server April 18, 2019 by Rajendra Gupta This article explains to the SQL Union and vs Union All operators in SQL Server. We will also explore the difference between these two operators along with various use cases. Read more »
SQL OUTER JOIN Overview and Examples April 16, 2019 by Rajendra Gupta This article will provide a full overview, with examples of the SQL Outer join, including the full, right and left outer join as well as cover the union between SQL left and right outer joins. Read more »
SQL Server Transaction Log Backup, Truncate and Shrink Operations April 16, 2019 by Ahmad Yaseen In this article, we will cover SQL Server Transaction log backups, truncate and shrink operations with an overview and examples covering everything discussed
SQL Code Snippets in Azure Data Studio April 16, 2019 by Rajendra Gupta This article will fully cover the code snippet SQL developer productivity feature in Azure Data Studio including a list of available snippets and examples of how to create custom code snippets Read more »
SQL Server Audit Feature Components April 15, 2019 by Ahmad Yaseen In the previous articles of the SQL Server Audit series (see the TOC at the bottom), we discussed the concept of the SQL Server Audit, why we need an audit solution to track and log the different events performed in our SQL Server instances and databases, and went through the different methods that can be used to audit the SQL Server databases. In this article, we will discuss the SQL Server Audit feature components and how to configure it. Read more »
SQL Server with a Docker container on Windows Server 2016 April 15, 2019 by Sreekanth Bandarla In this article let’s see how to install a SQL Server Instance using a Docker container in Windows server 2016. Read more »
SQL INSERT INTO SELECT Statement Overview and Examples April 12, 2019 by Rajendra Gupta This article covers the SQL INSERT INTO SELECT statement along with its syntax, examples and use cases. Read more »
Methods to Insert Data into SQL Server April 10, 2019 by Ed Pollack Summary There are a variety of ways of managing data to insert into SQL Server. How we generate and insert data into tables can have a profound impact on performance and maintainability! This topic is often overlooked as a beginner’s consideration, but mistakes in how we grow objects can create massive headaches for future developers and administrators. Read more »
AWS RDS SQL Server – Monitoring database instances April 9, 2019 by Ranga Babu In this article, we will review how to monitor AWS RDS SQL Server database instances and setup email notifications using event subscriptions and CloudWatch alarms.
SQL PARTITION BY Clause Overview April 9, 2019 by Rajendra Gupta This article will cover the SQL PARTITION BY clause and, in particular, the difference with GROUP BY in a select statement. We will also explore various use case of SQL PARTITION BY. Read more »
SQL Order by Clause overview and examples April 9, 2019 by Rajendra Gupta This article will cover the SQL ORDER BY clause including syntax, usage scenarios to sort out results in a Select statement. Read more »
Validate backups with SQL restore database operations using DBATools April 8, 2019 by Rajendra Gupta In this article, we will explore database backup validation by with SQL restore database operations using DBATools. Read more »
SQL unit testing best practices April 8, 2019 by Esat Erkec SQL unit testing is a testing method which allows us to test the smallest, atomic programmable part of a database object. SQL unit testing plays a key role in the modern database development cycle because it allows us to test individual parts of the database objects work as expected. SQL unit testing adds a great worth to the database project because unit tests are more reliable then manual test methods. Read more »
SQL SELECT INTO Statement April 5, 2019 by Rajendra Gupta This article will cover the SQL SELECT INTO statement including syntax, parameters and use with multiple tables, filegroups and a WHERE condition Read more »
SQL Foreign key April 5, 2019 by Ranga Babu In this article let us review different ways to create a SQL foreign key, rules on updates and deletes, enabling foreign key constraints, disabling foreign key constraints and not for replication in foreign keys. Read more »
SQL Convert Date Functions and Formats April 3, 2019 by Rajendra Gupta In this article, we will explore various SQL Convert Date formats to use in writing SQL queries. Read more »
SQL Restore Database using DBATools April 3, 2019 by Rajendra Gupta This article will cover SQL restore database operations using the open-source PowerShell module, DBAtools, and will cover commands for backup restoration using the command Restore-DBABackup with many various permutations like restoring from file, separate directory, renaming databases, norecovery options and more Read more »
