I have a function that includes: SELECT @pString = CAST(@pString AS VARCHAR(255)) COLLATE SQL_Latin1_General_Cp1251_CS_AS This is useful, for example, to remove accents in … Read more
I have made a backup of my SQL Azure in a bacpac file and when I try to import the bacpac in localdb … Read more
My current design is makes me want to create a FK to a non-unique/non-PK. Is this a code smell and/or does my overall … Read more
I’ve created a bacpac file of my database for transfer to Azure. The file is uploaded and imported successfully but there’s no data … Read more
I’m using SQL Server replication to mirror a few tables from an on-premises SQL Server instance to an Azure SQL database. We had … Read more
This feels like such a common question, I’ll understand if it is closed but if so please suggest a better place I could … Read more
I am trying to create a stored procedure on my Azure SQL Database, which has joins to other database table in Azure SQL … Read more
I was learning about RCSI when I discovered something strange on Azure SQL Database. The DMV sys.dm_tran_version_store_space_usage always reports 0 as the space … Read more
I can use the Management studio to connect directly to my Azure SQL database and execute this query: select * from DB.dbo.DSeries where … Read more
My wife has been asking me to create a web application for her business and from what I’ve read using SQL Azure would … Read more
