general question

31 Topics

SQL Strategy
Hi everyone, With the growing number of database technologies available, I'm curious how organizations decide which database should support different workloads. When working with Microsoft Fabric, how do you decide whether data should remain in an operational database or be moved into Fabric for analytics? I'd appreciate hearing the decision-making process you've found most effective.
Solved
binitafulpagare
27 days ago Place SQL database
223Views
0likes
3Comments
Training course recommendation on learning Natural Language to SQL within SQL Server?
Hi (I hope this is a suitable forum), We currently get our insights through Power BI (PBI) accessing data within SQL Server. Producing thsese reports/insights is labour intensive. With the introduction of AI, I've been tasked to find our if we are able to write questions (in Natural Language) of our data (held within SQL Server) and have the answers returned. If this is possible then it may negate the need for PBI reports to be generated to achieve the same insights. I have no understanding of AI at present. My gut is telling me the data model will have to be specific and very descriptive, and then we'd have to rely on customers (end-users) asking their questions in a regimented way - all challenges. I've been reading various online articles on the subject but each article, it seems, recommends different software and I'm gaining no momentum. Therefore, I am here to ask if you can advise on any training courses that would take me from a complete novice to someone who can, either, get the aim working or is equipped to advise it wouldn't work with our setup. We are a Microsoft (MS) house (SQL Server, Dynamics, etc...) and all in Azure. Any training material should follow using MS technologies otherwise the I.T. dept may put a blocker on it. Your suggestions will be most welcome. Thanks.
Solved
D_PBI
1 month ago Place SQL database
1.6KViews
3likes
6Comments
Foreign keys not visible in database explorer
Hi, when I create a relationship between two tables I've noticed that the related foreign key isn't visible in the database explorer, while for the primary keys at least it is reported the "pk" acronym: this is it a limitation or a regular behaviour? Thanks
Solved
pmscorca
3 months ago Place SQL database
1.8KViews
0likes
8Comments
Different behaviour between SQL database and SQL Analytics endpoint
Hi, I've noticed that there are diffencies between SQL database view and SQL Analytics endpoint view in the explorer. F.e. when I create a table with a datetime column I can do it successfully in the SQL database view while in the SQL Analytics endpoint view I need to use a datetime2 column. Moreover, it could occur that a dropped table in the SQL database view remains in the SQL Analytics endpoint view. The SQL Analytics endpoint view should correspond to SQL database view. Thanks
Solved
pmscorca
3 months ago Place SQL database
2.3KViews
0likes
12Comments
Generic error during SQL database creation
Hi, in a Fabric workspace with a F32 capacity (in North Europe region) I'm trying to create a SQL database for the first time, but I've only a generic error that says "A problem is occured". This message doesn't help to understand the real issue. I'm an admin for the workspace. Any suggests to me, please? Thanks
Solved
pmscorca
4 months ago Place SQL database
1.2KViews
0likes
1Comment
Fabric SQL Database GA
Hi all, Any idea when Fabric SQL Database will switch to GA? I saw an earlier post saying probably Q3 and definitely by the end of the year, but not seen anything since. Calendar Q3 has gone and I can't see a confirmed data in the roadmap. Thanks, DB
Solved
davidblake05
5 months ago Place SQL database
6.7KViews
1like
2Comments
facilitate the data migration to a Fabric SQL database
Hi, I'd like to know if it exists some tools to facilitate the data migration to a Fabric SQL Database. It seems that the Migration Assistant is specific for a data warehouse. thanks
Solved
AhmedMamdoh
5 months ago Place SQL database
4.4KViews
0likes
3Comments
Data mirror - Exception reading the data file.
Hi, I received this error from the Data Mirror UI. "We encountered an error while parsing data file being used, please fix the file and try again. The error is: Exception reading the data file. Exception: class parquet::ParquetStatusException (message: ‘Unknown error: System.OverflowException: Array dimensions exceeded supported range, at ParquetSharp.lO.ManagedRandomAcces sFile.ReadBuffer(lnt64 nbytes, IntPtr& buffer_handle, String& exception)'), ErrorCode: InternalError, ErrorCode: InputValidationError Artifactid: XXXX" Here are the columns: [jobOrderID] [int] NULL, [externalID] [nvarchar](100) NULL, [bhTimeStamp] [nvarchar](max) NULL, [dateAdded] [datetime2](3) NULL, [dateLastModified] [datetime2](3) NULL, [isDeleted] [bit] NULL, [action] [nvarchar](30) NULL, [migrateGUID] [uniqueidentifier] NULL, [truestDateAdded] [datetime2](3) NULL, [noteID] [int] NOT NULL, [personReferenceID] [int] NULL, [comments] [nvarchar](max) NULL, [minutesSpent] [int] NULL, [primaryDepartmentName] [nvarchar](max) NULL, [commentingPersonID] [int] NULL, [linkedInID] [nvarchar](200) NULL, [dateLastSync] [datetime2](3) NULL The largest value in the 'comments' column is 522932 bytes. Other tables with the same data types in the same database replicate without issue. I dumped the data out to a CSV file and loaded it into a lakehouse without errors. Where can I find the data mirror error log details? I would like to know the row and column that failed during import. Why did the data mirror replication fail on this table? Tim
Solved
timahenning2
6 months ago Place SQL database
2.7KViews
1like
3Comments
Tool to facilitate the data migration to a Fabric SQL database
Hi, I'd like to know if it exists some tools to facilitate the data migration to a Fabric SQL Database. It seems that the Migration Assistant is specific for a data warehouse. Many thanks
Solved
pmscorca
6 months ago Place SQL database
4.1KViews
0likes
6Comments
Setting up Mirrorred SQL Server
Trying to set up Mirrorred SQL Server to on prem sql using data gateway. Error: The database cannot be mirrored to Fabric due to below error: Test connection failed. undefined. Activity ID: undefined. Tested: Dataflow works fine with the sql connection using Std data gateway. I am Admin on the workspace. Checked all sql permissions. CDC is enabled db/table. TLS 1.2 on sql and on DG Tried: encrypted and unencrypted different database servers different authentication methods
Solved
ptmk25
8 months ago Place SQL database
3.1KViews
1like
6Comments