|
|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
Backing up to Azure | |
I want to send the backup of my SQL Server 2019 database to Azure Blob storage. When I enter the URL, what is the format? All CAPS are the items I set for my account. | |
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) |
Limiting Access on Startup I want to limit access to the SQL Server on startup to just sqlcmd. How can I do this? Answer: Use the -m startup option with SQLCMD as the value (-mSQLCMD) Explanation: The -m option allows you to limit access to an application. The value for -m is case sensitive. Ref: Database Engine Startup Options - https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/database-engine-service-startup-options?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 |
Inserts not propagated in transactional replication - Hello, I have a transactional replication configured which subscription fails to sync to often due to 20598 errors. I've enabled verbose logging on the Distribution agent, nothing more detailed captured than the message that the UPDATE fails due to the row missing at the Subscriber. I've run profiler on the Subscriber side and verified that very often […] |
Key Lookup to Clustered Index - Hey all, Been a bit since I've been down this road. Clearly I'd assume this is as expected and I'm just old and rusty. Attached is the execution plan I'm looking at. I have an index seek happening with a key lookup. The key lookup is happening on the clustered index. I attempted to add […] |
Restart SQL server from CMD - We have a issue in SQL Server 2017 (RTM-CU21) with SSISDB when a server restart happens SQL server will go into a stopped state and I cannot restart it from the configuration manager have to run the following command from cmd to start the service Net Start MSSQLSERVER /T902 how can I make this […] |
Replication issue - my table is getting replicated from server 1 to server 2. I got a request to delete the records in table in server 1 and insert new set of records. does replication take care of the records in server 2 or should i do something to make both in sync. |
SQL Server 2017 - Development |
Cross Apply, sub query or something else.... I\'m stuck - need help on a query please. given the following table; CREATE TABLE #T (CATEGORY bigint, NESTEDSETLEFT bigint, NESTEDSETRIGHT BIGINT) INSERT INTO #T ( CATEGORY, NESTEDSETLEFT, NESTEDSETRIGHT ) SELECT 5637145852,1526,1541 UNION SELECT 5637145310,392,407 UNION SELECT 5637145515,814,837 I need to be able to pass NESTEDSETLEFT and NESTEDSETRIGHT into this query without using a cursor.... SELECT CATEGORY, ITEMID […] |
SQL Server 2016 - Administration |
Linked Server Modification - I have a linked server and need to change only the @svrproduct and the @datasrc. I cannot figure out how to do this. I do not want to drop the object and recreate. @server = N'EAUTO', @srvproduct=N'1.2.3.4', @provider=N'SQLNCLI', @datasrc=N'1.2.3.4' Thanks, Terry |
SCOM/SCCM alert when Always On High Availability dashboard is green - Hello experts, Does anyone know why SCOM (or is it SCCM?) would send the following alert when everything is OK and green in the Always On High Availability > Show Dashboard? The Metric is: Microsoft.SQLServer.Windows.Monitor.Database.DBStatus (UnitMonitor) https://systemcenter.wiki/?GetElement=Microsoft.SQLServer.Windows.Monitor.Database.DBStatus&Type=UnitMonitor&ManagementPack=Microsoft.SQLServer.Windows.Monitoring&Version=7.0.0.0 MSSQL on Windows: Database is in offline/recovery pending/suspect/emergency state The databases in each AG are also online and […] |
SQL Server 2016 - Development and T-SQL |
Storing File in SQL database - Best option - What do I tell a .net developer is the best approach for storing various file type in a SQL db? PDF, TIF, JPG... |
Administration - SQL Server 2014 |
Migration of Server - We are looking to move the SQL server to different datacenter. Since it's a standalone instance so it can be moved using V2V or other different options. However, the IP address might change after the move? I am thinking changing from configuration manager would be suffice the IP Address Listened by the SQL Server. Do […] |
SQL Server 2019 - Development |
Size of table - Hi This probably a silly question but..... If I query the size of a table and it shows 20 gigs in size, when I do a select * from that table from another server will I bring back 20 gigs over the network? thanks in advance |
Validate field in STaging before loading - I have a STaging table where I have defined all fields as Varchar(255), now I'm trying to load the Prod table, and one of my fields(order_open_qty) is defined as Decimal(18,10), but it fails as data from STaging fails converting Varchar to Dec. Is there any pre-validation I can run to change those bad records to […] |
Reporting Services |
SSRS and SharePoint - We currently have SSRS 2017 and are looking at adding SharePoint to our environment. The question has come up as to whether we should implement SharePoint with Reporting Services or without and keep our SSRS 2017 separate as it is. I'm just starting out with Reporting Services and have no experience with SharePoint. I'm not […] |
SSRS Query Designer not showing newly added measures - We have recently added new measures to our existing cube (that was originally developed in SSAS 2012 and then we stood up SSAS 2019) in dev and test. When I go into my SSRS project using VS 2015, then the query designer and refresh my connection to SSAS 2019, the measures that were developed in […] |
Analysis Services |
Azure Log Analytics or SQL Profiler for AAS? - I think you can use both SQL Server Profiler or Azure Log Analytics for Azure Analysis Services logging. But which one is the better option? |
Integration Services |
Running SSIS package on Always On and getting error - Hello, so My ssis Package i created, does 2 things: 1.it first checks if the Table exists, and if not, create it 2.checks if Store procedure exists, if not creates it using a Dynamic tsql statement so far, i made several ssis packages with it including several Execution SQL Task, and works fine, just this […] |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |