|
|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
Resetting Status | |
What does sp_resetstatus do? | |
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) |
Azure VM SQL Database Backups As a contractor, I have set up a SQL Server instance inside of an Azure VM. I am a little worried about support from the organization that needs this, since they have accidental DBAs that work on the systems. I want to make the backup process simple and easy for them, while ensuring they can have a point in time recovery to an hour. They are comfortable in the Azure Portal, and a solution that works in the Portal is preferred. Which of these should I choose? Answer: Use Azure Backup to the Recovery Services Vault with the workload extension Explanation: While getting retained might be profitable, this isn't the easiest way to get backups in Azure for a company running SQL Server in a VM. Azure Backup can install an extension into your VM that allows for backup to the Recovery Services Vault. The policy and settings can then be managed in the Azure Portal. Ref: About SQL Server Backup in Azure VMs - https://docs.microsoft.com/en-us/azure/backup/backup-azure-sql-database |
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 |
Hello, I'm a Seller [CVV] - Provide of CVV and Bank Logins + MSR/ATM Skimmers good prices here. - US cvv: Visa/Master: $2 - Amex Card/Discover: $4 - UK cvv: Card Random: $8, With D.O.B/With Pin: $13 - CA cvv: $10 - Paypal verified with mail and pass login: $25 ----RULE---- * Only sell, not share and I don't want to […] |
SQL Server 2017 - Development |
Sell cvv with good quality - Provide of CVV and Bank Logins + MSR/ATM Skimmers good prices here - US cvv: Visa/Master: $2 - Amex Card/Discover: $4 - UK cvv: Card Random: $8, With D.O.B/With Pin: $13 - CA cvv: $10 - Paypal verified with mail and pass login: $25 ----RULE---- * Only sell, not share and I don't want to […] |
SQL Server 2016 - Administration |
Cost Threshold For Parallelism - How do I find last update timestamp for Cost Threshold For Parallelism value? Is it logged somewhere? |
Get history of blocking - Hi Is there any view that stores blocking history? Thanks |
to change the netbios name on a replication server - Hello everyone I have a server in transactional replication I have a netbios change request from this server the Publisher and Distribution Server are configured on the same server what will be the impact of this change on the good functioning of my replication must change the logical no of this server through the command […] |
Software need db owner permission to master database (sql2016) - We have a manufacturer whose software requires authorization for the master database. (only db owner working) Unfortunately, the manufacturer can not tell us why this access to the master database is necessary. Without Permission the application will not start What are your opinions? Have you ever seen such software? We have 200 different applications but […] |
SQL Server 2016 - Development and T-SQL |
full text search - Trying to understand why when I search for numerics in full text, contains does not return, but containstable does. It seems that in that in this instance the 0's are repeatable and not indexed, but why does one work and the other not? Is there a way to make it work regardless? CREATE TABLE [dbo].[EquipSrch]( […] |
Disable DCD on table fails - Hello everyone, I have CDC enabled on a few tables. Recently i had changed one column in 2 tables from varchar(20) to varchar(50) and then capture agent CDC job started to fail. What i found is that there is a bug in all SQL versions and no fix. The work around i found is: Drop […] |
SQL 2012 - General |
New CVE-2019-1068 vulnerability - is there a patch for MSSQL 2012? - MSSQL Server 2012 Service Pack 4 is officially supported until 2022-07-12: https://support.microsoft.com/en-us/lifecycle/search?alpha=sql%20server%202012 The new vulnerability in MSSQL, published 2019-07-09: CVE-2019-1068 | Microsoft SQL Server Remote Code Execution Vulnerability https://portal.msrc.microsoft.com/en-us/security-guidance/advisory/CVE-2019-1068#ID0EMGAC mysteriously excludes MSSQL 2012. The oldest supported version in the table is MSSQL 2014 SP2. And the article states "If your SQL Server version number is […] |
SQL Server 2008 - General |
Cannot upgrade SQL 2008R2 DB Engine - Hi; thanks for reading the post i have inherited a legacy SQL Farm with a couple servers running SQL2008. I am attempting a side-by-side upgrade on the servers (due to constraints out of my hands) I have successfully upgraded a number of them but have a troublesome few remaining. When I attempt an upgrade […] |
SSRS 2016 |
PowerBI Server - Hi all, First of all forgive me if this is the wrong forum for this, I couldnt find a specific channel for PowerBi, so sorry. Anyway, I'm researching PowerBI and I've got myself a bit confused, imagine the scenario that I develop a report and then publish it to the cloud powerbi.com as I want […] |
SSDT |
pivot on SSDT 2017 - Good Morning everyone I have a problem with a tabular Project on SSDT 2017, I have a 1 table with columns Q1, Q2, Q3 & Q4, I need to Pivot this columns, the manual say that I used the transform Menu, but I dont Find this Menu, Could anyone help me please. I appreciate your […] |
Integration Services |
SSIS - I am trying to connect oracle 11.2 using Integration service Oracle Destination Editor and OLE DB Destination .Installed the Oracle database client on the SSIS server but still get the below error. There was an error trying to establish an Oracle connection with the database server. Did anyone made successful connection.Any idea or advise please? […] |
SSIS Package/Agent Job Not Failing!!! - I have a package running in SQL 2016 using Project Deployment. One of the steps executes a stored procedure. All of the tasks have their error parameters left at default so any error should cause the package to fail because the maximum error count is 1. In this particular instance the database user account used […] |
SQL Server and Sharepoint |
Page Output cache problem - I have several users who see old page layout rather than new one. I am not sure what is the problem. Page output Cache profile says inherit inside site content cache option. Is this causing a problem?. I tried clearing browser cookies from user PC, but same problem thanks |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |