One of the challenges when considering migrating your on-premises SQL Server databases to Azure SQL Database is its lack of support for Active Directory-integrated authentication. With the advent of Azure SQL Database V12, the authentication capabilities have been expanded, allowing for more flexibility that leverages Azure Active Directory. In this article, Marcin Policht provides an overview of this functionality.
This Friday Steve Jones talks about your support load. Let us know how many databases you support and what the load is like.
Set-based programming doesn’t mean “no loops” or a single statement. Finding out the best ways to traverse a full hierarchy.
SQL Server collation is an important setting when creating database objects. One of the best ways to ensure that collation issues do not happen is to ensure that the collation settings are properly specified in the script that generates the database objects - Siddharth Mehta demonstrates how to do this.
Steve Jones says that developers should take responsibility for the code they deploy, perhaps with a warranty of sorts inside their company.
Sometimes a request from a user who doesn't appreciate the limitations of the technology can jolt you into discovering that an application feature that was, until recently, difficult to achieve is suddenly relatively easy. Dino was asked to allow the user to take photographs and associate them with an item of work. After he'd recovered from the shock, he decided that it was achievable, and now describes how he went on and did it.
Sometimes DBAs become resistant to change. When they lose focus on their full purpose they may have DBA syndrome.
Aaron Bertrand runs some tests to challenge an assertion that CHARINDEX is always faster at pattern matching than LEFT and LIKE.
When we administer a SQL Database, we always have to work with files. This new article shows how to handle them using PowerShell.
Asking questions in an interview is important, but there can be issues. Steve Jones talks a little about how to approach this.
By Arun Sirpal
For those entering the AI space whether professionally or personally I wanted to give...
By Steve Jones
Thanks to everyone for attending my session on running a Local LLM. If you...
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
Good Afternoon, I have a Job which "fires" off an SSIS package (that is...
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Comments posted to this topic are about the item Spring Connections and Learning at...
How do I easily get the next 12 sequence values from a sequence object?
See possible answers