Database Sequence Objects with dbatools
This article delves into five new dbatools command that work with sequence objects.
2023-05-31
1,451 reads
SQLServer
SQL Server, Oracle and PostgreSQL Database Security Roles, Schemas, Grants, Privileges and Owners - Part II
This article covers the concepts of roles, schemas, grants, privileges, and owners and the similarities and differences in SQL Server, Oracle, and PostgreSQL.
2023-03-24
New functions in SQL Server 2022 - LEFT_SHIFT and RIGHT_SHIFT
Learn about the new functions LEFT_SHIFT and RIGHT_SHIFT in SQL Server 2022 and how these functions could be used.
2023-03-20
json_object and json_array Functions SQL Server 2022 Tutorial
Learn about the new functions JSON_OBJECT and JSON_ARRAY to work with JSON formatted data in SQL Server.
2023-02-20
Convert Problematic Data in SQL Server
In this article, we look at various ways to convert problematic data in SQL Server by using TRY_CAST, TRY_CONVERT, and TRY_PARSE.
2022-10-03
Views in SQL Server 2019 with SSMS
This article explores how to create and use views in SQL Server 2019 using SSMS.
2021-12-27
5,764 reads
A Step by Step Guide to the Availability Group (AG) Listener
Availability databases hosted on SQL Server Always On Availability Groups (AG) can be connected using a unique Virtual Network Name (VNN), called the Availability Group Listener. When an Availability Group is enabled, clients can connect to databases in both primary and secondary replicas without explicitly specifying the SQL Server instance name. You don’t even need […]
2021-05-17
5,475 reads
Fixing "Login failed for user" error in SQL Server
In this article, I am going to explain fixing a problem related login failure error with SQL Server. The Problem One of the common error in the SQL Server error log is "Login failed for user 'DomainName\ServerName$'. Reason: Could not find a login matching the name provided. [CLIENT: <local machine>]". Even though it says that […]
2020-11-24
40,722 reads
Finding the Free Space Difference Between Availability Groups Replicas
When was last time you have checked your Always On Availability Groups' replicas storage distribution?
2020-11-09
1,850 reads
Great Power(Shell)...Great Responsibility
-WhatIf you could see what would happen if you ran a command?
2020-10-23
3,727 reads
Blogs
Migrate datetime data to datetimeoffset with AT TIME ZONE
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
The Comprehensive Guide to Mastering Your SQL DBA Skills
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
Friday Basics: Authentication vs. Authorization
By Brian Kelley
Another security fundamentals topic is authentication versus authorization. For those who have a clear...
Forums
The Backup File Extension
Comments posted to this topic are about the item The Backup File Extension
Ingest and Retrieve data from an ADX Cluster Using Python
Comments posted to this topic are about the item Ingest and Retrieve data from...
The DBAccountant
Comments posted to this topic are about the item The DBAccountant
Question of the Day
The Backup File Extension
I run this command in SQL Server 2022. What is the extension of the backup file?
BACKUP DATABASE HerdofTwo TO DISK = 'HerdOfTwo_20240501'See possible answers