|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
Copying an Azure SQL Database with PowerShell | |
I have an Azure SQL Database that I want to copy for a point in time reporting requirement whenever I am asked. Since I need to do this regularly, I'd like to have a script that can do this easily with PowerShell. What is the easiest way to do this? | |
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) |
Required Environment Variables When I start a Linux container running SQL Server, what environment variables do I need to provide? Answer: The ACCEPT_EULA and MSSQL_SA_PASSWORD variables Explanation: Only the ACCEPT_EULA and MSSQL_SA_PASSWORD variables are required. The MSSQL_PID defaults to developer and the MSSQL_TCP_PORT defaults to 1433. Ref: SQL Server Linux Environment Variables - https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-configure-environment-variables?view=sql-server-ver15 |
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 2017 - Administration |
problem for the log reader - Good morning all I have configured a transactional replication where the disstribution server is remote the snapshot it works well while the subscriber part does not work I had this i have this eroor The concurrent snapshot for publication 'BR_Traceability_OtherR&D_Repl' is not available because it has not been fully generated or the Log Reader Agent […] |
SQL Server 2017 - Development |
Help with a query - Hello I am fairly new to SQL and tying to work out a code. I created the following query and it wont run. The RevenueCD field is located in the [Epic].[Finance].[UBRevenueCode] table and needs to be joined to the Epic.Finance.HospitalTransaction table. The common field in both tables is [UBRevenueCodeID]. When I tried to join them […] |
SQL Server 2016 - Administration |
who's connect using R? - Hi, I look after a server and have users connecting with R who are causing alot of performance issues. Is there an easy way to identifying these people. any help welcome:) Thanks, Eamon |
Drop table - i need to delete specific tables "_backup " which took before changes to the table, instead of deleting the table one by one , any script is there to complete the task at ones. |
SQL Server 2016 - Development and T-SQL |
Filling Missing Weekend Dates - Hi and first time poster, so please be gentle! I have a table with the following sample data which excludes weekend dates for each employee:- Employee Date Hours John Doe 15-OCT-20 7.5 John Doe 16-OCT-20 7.5 John Doe 19-OCT-20 7.5 I would like to have the missing dates inserted […] |
Un-queried tables - Hi, Is there a way to know which tables from a DB are NOT being queried? Context : We do a lot of reporting from multiple data sources (SAP, cloud based apps, etc), so from time to time we require the replication of a bunch of tables for our reporting. Our developers prepare the queries […] |
Executing another stored proc inside of a stored proc - Hello, Wondering if anyone has any insight into how I can do this: I have a lengthy stored proc which produces a number of metrics that I may need to use for other calculations. This stored proc uses OpenQuery to gather the data. I would like to create another stored procedure that calls this stored […] |
Development - SQL Server 2014 |
Two Tables - Values from one in columns and other in rows w/ data from a third - I'm not sure why my other topic was removed (maybe too much code in the post) so I'll try again. I have two tables. We'll call them Subaccounts and AccountCategories. The Subaccounts table has just that - a list of Subaccounts and their descriptions (1 per row). See the attached file (Subaccounts tab). The AccountCategories […] |
Identical indexes - one clustered PK, another non-clustered - I found a pair of two identical indexes, containing the same column - one is clustered primary key and another is non-clustered non-unique. When I suggested to remove the 2nd index, developers explained that we need both of them. First - for queries with wide column listing in Select clause, and the 2nd one - […] |
SQL Server 2019 - Administration |
Cannot get SQL Server 2019 MDS Model values to display in Model drop list on MDS - Cannot get SQL Server 2019 MDS Model values to display in the Model drop list on MDS Website Title Page. Was able to get Models to display in SQL Server 2017 MDS OK. Managed to configure both MDS 2019 Website and MDS 2019 Web Service and Excel MDS 2019 Add-in successfully connecting to SQL Server […] |
Get list of databases from failed SQL Server instance - We recently had a major SAN failure and completely lost many of our SQL Server instances. For many instances, we had no user database backups (this was by design due to storage limitations). However, we have system databases for all of the lost instances. I want to recover a list of the databases originally hosted […] |
Find (Count) Joins inside Views - Good Afternoon All, I want to be able to count the number of joins used in views. We have a lot of views that are legacy and are awful. I was hoping to provide some kind of insight into what views could be improved or not used anymore -- using the number of joins as […] |
SQL Server 2019 - Development |
SQL Agent and Windows Task Scheduler - Hi Guys, Has anyone used windows task scheduler with SQL Agent? I have a FTP which needs to be imported into a database every morning. At the moment we save the FTP as a CSV and currently import that into the database but I'm hoping to fully automate the importing process? I'm hoping widows task […] |
SQL Azure - Administration |
Azure SQL Database and AD Authentication - Quick Question. I have a Database that sits on-prem, The database feeds a number of excel reports that are authenticated using the on Prem AD. I which to put this DB in Azure SQL Database keeping the AD authentication. I am guessing ADFS is required from the on-prem to Azure AD but my knowledge is […] |
Analysis Services |
Only 90 Days of Data in Azure Analysis Services - I want to make sure there are only 90 days of data in my Azure Analysis Services (AAS) model. I'm thinking about using Power Query/M to only filter the most recent 90 days and then doing a Process Full. Is that the best approach to this? If so, how can this be implemented, especially since […] |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |