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 HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
Comments posted to this topic are about the item The day-to-day pressures of a...
Comments posted to this topic are about the item The Problem Isn't Always Your...
Comments posted to this topic are about the item Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers