|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
Stopping Compute in Azure VMs | |
I have created an Azure VM, but I don't need to use it for the next two weeks while I am on vacation. What should I do to reduce the cost of my resource as much as possible, while making it easy to restart later? | |
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) |
Enabling Container Availability Groups I am running a couple of Linux containers with SQL Server. How do I enable the Availability Group option? Answer: Set the MSSQL_ENABLE_HADR value to 1 Explanation: There is an environment variable, MSSQL_ENABLE_HADR that you set to 1 to enable the feature. Ref:
|
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 |
Set permisson user allow connect with application, don't allow connect with ssms - Hello, guys. I use .net to code, can i set permisson a sql user only can connect in connection string in .net code, and not allow that user login with ssms ? |
Maint Plan Failing after 'sa' Disabled - I have 4 Maint Plans, 1 of which fails because 'sa' is disabled, but I don't see 'sa' specified in the plan. It rebuilds indexes, updates statistics, deletes old backups, then takes new backups. The other 3 Maint Plans just run DIFFS and T-Log backups. All 4 Scheduled Job Owners are a Windows account. On […] |
SQL Server 2016 - Administration |
RING_BUFFER_RESOURCE_MONITOR - IndicatorsPool? - Hi all, i've been looking into an odd issue with possible plan cache memory starvation (SQL couldn't generate a query plan prior to timeout for unchanged procs that happily compliled previously) , and spotted quite frequent RESOURCE_MEMPHYSICAL_LOW events. IndicatorsProcess and IndicatorsSystem are both 0, but IndicatorsPool is 2, and I can't find any information around […] |
Always On Availability Groups Issue - Hi, I see couple of below errors for 2 sql server instances i.e. primary and secondary. When I see the dashboard, it displayed the state as critical and after few minutes it turned green (I mean the databases we are online and synchronized). I do not see any databases on both the instances in recovery […] |
SQL Server 2016 - Development and T-SQL |
A real challenge and I need suggestions on efficient ways to solve it - I have a need to determine the site of cancer given some complexities. Each cancer patient has up to 4 diagnosis codes with the first being the primary. I currently have a mapping table that is capable of mapping up to two values to a result value. Currently I only check the primary diagnosis to […] |
Varchar to datetime - Hi, How can I convert SCHEDSTART varchar(25) '2020-06-07-12.30.00.00000' to datetime '2020-06-07 12:30:00.000' SELECT convert(datetime,(left([SCHEDSTART],10) +' ' + left(Right([SCHEDSTART],14), 12) ), 127) didnt work. Any help ? |
Administration - SQL Server 2014 |
PBM - result_detail column in syspolicy_policy_execution_history_details - Hello, we use PBM to monitor last full and last log backup. PBM created, nothing special so far. We created a stored procedure and a job querying syspolicy_policy_execution_history joining syspolicy_policy_execution_history_details to get the result of the PBM and send it as e-mail. So far so good. But we want to include the expected result in […] |
SQL Server 2012 - T-SQL |
using parameter and not using parameter , the result is different - declare @YYMMDD DATETIME set @YYMMDD='2020-09-23 00:00:00.000' select CONVERT(VARCHAR(6), '2020-09-23 00:00:00.000', 112) , CONVERT(VARCHAR(6), @YYMMDD, 112) same value, when we use parameter to pass the value, and not using parameter, the result is not same, what is the reason ? thanks! |
SQL Server 2019 - Administration |
How does dns determine what ip to resolve to in an multisubnet AG? - When a SQL Listener is created on a Multi Subnet environment 2 x ip addresses are assigned. AG Name - SQLAG1 AG Listener Name - SQLAG1-LI 10.0.0.1 10.0.10.1 I have given the ip addresses above for example. In DNS there are 2 x entries for the SQLAG1-LI one for each of the IP addresses. A […] |
SnapCenter Server Backup for SQL - Hello, do you have any experience with SnapCenter Server 4.3. Can we say that is a valid backup? can we use like a primary backup? I have some testing now, and I am afraid how is working with this web app. Thanks |
I've lost the ability to connect to my SQL 2019 instance - On my home Windows 10 Professional desktop PC, I've got SQL Server 2019 Developer Edition installed. I thought I had mixed mode but am not so sure. A month or two ago I had problems with my Windows profile - it became corrupted. So, I disabled it and created a new Windows Profile. I thought […] |
SQL Server 2019 - Development |
\'DBMS_DATA_MINING\' is not a recognized CURSOR option - Is DBMS_DATA_MINING available in SQL Server 2019? This is error: 'DBMS_DATA_MINING' is not a recognized CURSOR option |
Analysis Services |
Where is the AdventureWorks 2008R2 Analysis Services project download? - I need the 2008R2 version because I want to climb the Stairway to MDX and in Level 1 it says: Consider working, therefore, with 2008R2, if at all possible: learning the basics of MDX is challenging enough for most that are new to it, without the additional distractions imposed by working with older releases. In […] |
Integration Services |
SSIS Package that updates two databases on the same SQL Server instance - Hi, I have a large script that is querying and updating two databases on the same SQL Server instance (one client database and the MSDB). I'd like to publish this script in an SSIS package, but when I do so it complains that I don't have authorization to update the MSDB database. I have created […] |
SSIS package error on remote database - hello everyone, so i have created a SSIS package that i want it to run on another server, so example below: Server A is running the SSIS package, and the destination is Server B, that i want it to run under a certain account, like either the network service or system service, which has the […] |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |