SQL Azure - Administration

• Topics

  Started by

  Posts

  Last post

• Migrating SQL express database over to Azure

  Hi all, My boss wants to move our customers over to azure from SQL express (mostly SQL Express, som…

  paul 69259

  6 replies

  1 year, 5 months ago

  By: paul 69259

• Testing a Migration from IaaS to MI, and the Log Replay Service

  A bit of background - we are migrating from an Availability Group on IaaS, to a Managed Instance. T…

  BrainDonor

  1 replies

  1 year, 5 months ago

  By: BrainDonor

• Azure Data Studio not acting like SSMS

  I created a schema and a table under that schema. I queried that table. I wrote a stored procedure …

  mike.podric@gmail.com

  1 replies

  1 year, 7 months ago

  By: mike.podric@gmail.com

• shrinkfile option not working

  Total size of Tables=500 GB Storage of DB shows 2.6 TB, Microsoft recommends run dbcc shrinkfile  w…

  sqlguy80

  15 replies

  1 year, 7 months ago

  By: Jeff Moden

• IX fragmentation and Updating Stats

  Though its Azure MI Business critical , I see fragmentation, Any script to identify which IX's need…

  sqlguy80

  3 replies

  1 year, 7 months ago

  By: Michael L John

• Good Azure cost calculator

  Azure calculator doesn't give a good estimate as it cannot differentiate between HA/ DR and primary…

  curious_sqldba

  1 replies

  1 year, 7 months ago

  By: curious_sqldba

• shrink data file with low priority

  so total size of DB on Azure is 1 TB, but when I add all tables ( Data file ) and log file the tota…

  sqlguy80

  7 replies

  1 year, 7 months ago

  By: frederico_fonseca

• script to check size of Tables, Database and free space

  Can someone share script to check Table Sizes in GB. ,and size of DB in GB. The scripts I see onlin…

  sqlguy80

  1 replies

  1 year, 7 months ago

  By: Jeffrey Williams

• Connecting to Azure SQL Servers as admin using SSMS

  Hello, Over 15 years of experience using traditional SQL Servers and have just commenced with an em…

  Can Do Drew

  3 replies

  1 year, 8 months ago

  By: Can Do Drew

• Azure Datawarehouse or SQL Pools and profiler equivalent...

  I added the Profiler module to AZure Data Studio in our ("Microsoft Azure SQL Data Warehouse ) env …

  digdave7

  6 replies

  1 year, 8 months ago

  By: Grant Fritchey

• Azure SQL Cluster Failover notification

  Thanks for your time in reading this....first and foremost I have an Azure SQL cluster setup in bot…

  DHeath

  1 replies

  1 year, 8 months ago

  By: DHeath

• Azure Postgres reliability/management experiences

  I am considering implementing an Azure Postgres DB for use in a part of an ETL process. I would nee…

  CreateIndexNonclustered

  1 replies

  1 year, 8 months ago

  By: CreateIndexNonclustered

• post steps for Table PARTIONING

  Any one did Table partitioning in Prod, please list steps here. we have a transaction DB with 4  Ex…

  sqlguy80

  3 replies

  1 year, 8 months ago

  By: Johan Bijnens

• Provide access to View Vs Tables

  Dears, Hope this thread finds you well I have been creating DALs ( Data Acess Points) in SQL using …

  river1

  5 replies

  1 year, 8 months ago

  By: Jeff Moden

• How to create .bacpac file for multiple databases in SQL 2008

  Hi We have a SQL Server 2008 on-prem DB server that consists of 4 databases, these 4 databases are …

  Harshana-455711

  3 replies

  1 year, 9 months ago

  By: Ant-Green