Skip to content
IT Nursery
  • Home
  • Programming
    • Mac / IOS
    • Android
    • Web Applications
    • PHP
    • Java
    • C
    • C++
  • DataBase
    • MySQL
  • CMS
    • WordPress
  • System and Network
    • Serverfault

azure-sql-database

How to remove diacritics in computed persisted columns? COLLATE is non-deterministic and cannot be used

by IT Nursery

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

Tags azure-sql-database, sql-server-2012, t-sql

Can’t restore Azure bacpac into localdb with SqlPackage

by IT Nursery

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

Tags azure-sql-database, sql-server

Design encouraging FK to non-unique/non-PK

by IT Nursery

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

Tags azure-sql-database, database-design, foreign-key, sql-server

No data in Azure SQL after importing bacpac file

by IT Nursery

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

Tags azure, azure-sql-database, import

How can I determine the last synchronization time for a SQL Server replication subscription?

by IT Nursery

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

Tags azure-sql-database, sql-server, transactional-replication

How can I improve the performance of a sorted join?

by IT Nursery

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

Tags azure-sql-database, join, performance, query-performance

Cannot create SP in Azure SQL Database

by IT Nursery

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

Tags azure-sql-database, sql-server, t-sql

sys.dm_tran_version_store_space_usage reports always zero space used

by IT Nursery

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

Tags azure-sql-database, sql-server-2019, tempdb, tempdb-version-store

Linked server to SQL Azure very slow

by IT Nursery

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

Tags azure-sql-database

Just how secure is the data I put on SQL Azure?

by IT Nursery

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

Tags azure-sql-database, security
Older posts
Page1 Page2 … Page15 Next →

Recent Posts

  • Advice for improving internal dashboard [closed]
  • grep : ‘+’ special character
  • File location for Syslogs in Centos machine
  • How to collect users’ task completion times?
  • “service {FOO} start” vs. “/etc/init.d/{FOO} start”? [closed]
IT Nursery
Creative Commons License
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.

Important Link

  • About
  • Privacy Policy
  • Contact

IT Nursery

The Goal of ITNursery Engaging the world to foster innovation through aggregate information. Our Question Answer post, blog information, products and tools help developers and technologists in life and at work.

copyright © 2023 All Right Reserved | IT NurSery
x
x