Laden...
|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
Sparse Column Defaults | |
What are the restrictions for defaults on columns declared as sparse? | |
Think you know the answer? Click here, and find out if you are right. |
Yesterday's Question of the Day (by Steve Jones - SSC Editor) |
Data API Builder Operations What types of database operations does the Data API Builder support? Answer: any CRUD operation Explanation: The Data API Builder supports all CRUD operations (create, read, update, delete). Ref: What is the Data API Builder? - https://learn.microsoft.com/en-us/azure/data-api-builder/overview |
Database Pros Who Need Your Help |
Here's a few of the new posts today on the forums. To see more, visit the forums. |
SQL Server 2016 - Development and T-SQL |
Read data from json file - I am using the following code to read a json file. I can display the keys and coreentitykey info. However, I am unable to view the attributes (Enable and Name). Not sure how to display with the other fields. Any help is greatly appreciated. DECLARE @json NVARCHAR(MAX) = N'[ { "metadata": { "numNodes": "1329", "metadataKey": […] |
SQL Server 2019 - Administration |
Cannot restore new DB - I have made an empty DB called "HJEM_BB" I try to fill it from a backup (From device) When i select the backup, it opens nicely. Sets it to overwrite, some time goes, and i get this message: TITLE: Microsoft SQL Server Management Studio ------------------------------ Restore of database 'hjem_bb' failed. (Microsoft.SqlServer.Management.RelationalEngineTasks) ------------------------------ ADDITIONAL INFORMATION: Microsoft.Data.SqlClient.SqlError: […] |
SQL Server Data...is it encrypted? - Hi Suppose someone gained unauthorized access to the physical SS data stored on my machine. Is the data encrypted? Will the user need a password to access the data? Here is how I login to SS: Thank you |
SQL Server Setup - We don't have an IT department that can help us. We have our SQL server on a laptop that an employee owns and manages. He no longer wishes to support us with the SQL database on his laptop. The employee is disgruntled, so we need to make sure he does not have access to the […] |
SQL Server 2019 - Development |
standard deviation function doesnt seem to be behaving like an aggregate - hi i have 6 statistical populations in my overall data set. They run across 21 data points. No matter what i try with the standard dev function, i get back all 21 data points, each with a repeated std dev for the population that data point is in. from the looks of the function it […] |
Using ROW_NUMBER() to increment every time a value occurs - Hello folks, I have some rather unstructured data coming into a staging column from a file. I can guarantee the order of the data on load using a column I am calling RowNumber. I like to group the data using ROW_NUMBER() every time the value 'CreateDate' occurs. Here is current my effort. Thanks if you […] |
SQL Azure - Administration |
Transfer data from azure vm to blob storage - Hi Experts I want to move data/ some million rows from a Azure vm table to Azure blob storage. What all are the best ways to complete this task? Thanks Manoj Bhadiyadra |
Issue with Creating Linked Server from Azure SQL Managed Instance to On-Premises - Hi, Interestingly, I was able to create a linked server in the reverse direction—from the on-premises SQL Server to my Azure SQL MI—using a remote login and password for authentication. However, when I attempt to establish the link from Azure SQL MI to the on-premises SQL Server, it consistently fails. Additional Details: I have an […] |
Reporting Services |
The user data source credentials do not meet the requirements to run this report - I am trying to implement a SSRS reporting dashboard similar to the SQL-performance-dashboard-reports that allows me to click on a link to pull up another report (sub-report) passing it a server name as a parameter. The Data Source is setup to use Embedded connection with the following connection string: ="Data Source=" & Parameters!ServerName.Value & ";Initial […] |
General |
When trying to use a LocalDB, I get an error - I tried to find an appropriate forum to post the question. This one seems to be the closest. I'm sorry if I'm wrong. This is a long story, which I haven't time to go into now. I'm starting a new Blazor Web app using .NET 9 and include what's called Individual Accounts (or Individual Users, […] |
Powershell |
display bytea image - I moved a table from MsSql to Postgresql that had a field defined as Image in Mssql now in Postgres it's a Bytea field. How can I make sure data copied across with success? Is there some code I could run to make sure Image looks correct from PostgreSQL ? Thanks. |
Analysis Services |
MDX SSAS Calculated measure for last totals + turnovers - I have a measure with totals for specific dates with the LastNonEmpty aggregation, and a measure with turnovers with the Sum aggregation. Help create a measure with totals for each day that would take into account the last known totals + turnovers from the date of the last totals to the current date. I tried […] |
SQL Server 2022 - Administration |
How do I fix the, "Unable to process the existing user settings" error message? - I'm sure I've asked this question in either this forum, or another one, in the last 6 months, but I am still struggling with it. Over the Christmas break, desktop support reimaged my dev box, so I would have thought this problem would have disappeared. But I am sadly mistaken. When I open SSMS 20.2 […] |
I need help accessing my local SQLExpress - My PC has been causing me problems for months. I've told my desktop support team. They reimaged my machine, but it hasn't helped. I cannot run SSMS against the LocalDB I get this error: and that's as far as that goes. If I try to connect to LocalDB I get this error: and that ends […] |
SQL Server 2022 - Development |
What approach should I take in getting two databases to work together? - At work I am rewriting an old application which no longer builds. It was poorly written to begin with. The original developers, who wrote it about 15 years ago, didn't follow any convention that was used at the time. They created a database to collect data and added one table to handled identity. All users […] |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Laden...
Laden...
© 2025