Tags » SQL Server

Easiest way for automating Analysis services database backup

I believe many of you know or already use different way for this requirement as technology and requirement is not new, but I believe easiest and fully automated way always the best to have the options together. 1,450 more words

SSAS

Goodness-of-Fit Testing with SQL Server Part 5: The Chi-Squared Test

By Steve Bolton

…………As I’ve cautioned before, I’m writing this series of amateur self-tutorials in order to learn how to use SQL Server to perform goodness-of-fit testing on probability distributions and regression lines, not because I already know the topic well. 4,120 more words

SQL Server

SQL SERVER – FIX: Error: 18456, Severity: 14, State: 58. Login failed for user

One of the most common and searched SQL Server failure is around “Logins”. Login failed for user has always been tricky and interesting to troubleshoot. I don’t think there is a silver bullet to easily troubleshoot the same. 337 more words

SQL Authority

Grant EXECUTE to all stored procedures in a schema

To Grant Execute permission to all stored procedures in a schema in current database, use the following statement:

Grant Execute on Schema ::dbo to

To do it for all schemas in current database: 20 more words

Stored Procedure

Create a SQL Server Job

— use KenticoCMS_Datamart_2

GO
PRINT ‘Executing dma_QuickJob.sql’;
GO
IF EXISTS (SELECT
name
FROM sys.procedures
WHERE
name = ‘dma_QuickJob’)
BEGIN
DROP PROCEDURE
dma_QuickJob;
END;
GO

CREATE PROCEDURE dbo.dma_QuickJob… 218 more words

Database Mirror Monitoring with Scripts

The database mirror monitor is a nice tool, but registering all your databases and clicking through each one can be time consuming when you have dozens. 756 more words

SQL Server

SQL Connections – Finding what fixed port SQL is listening on

— by Lori Brown  @SQLSupahStah

While trying to add a database to an existing AlwaysOn Availability Group (AG), I was having difficulty making a connection from the primary replica to the secondary replica. 378 more words

SQL Server