How to Suppress backupToUrl in Error Log

HiDBCC TRACEON (3226,-1) Only works for Backup To Disk.I'm hoping to suppress this for BackupToUrl.…

Roll Up All the Versions

Comments posted to this topic are about the item Roll Up All the Versions

Querying vertically partitioned data(bases) - sometimes known as Federated Databases

Can anyone suggest a technology that will allow distributed queries across multiple servers where t…

Dynamic Colum Name ???

Hi I'm trying to set a column name as the variable below Declare....Set @Month1s = cast(dateadd(mon…

String Search

Data dictionaries

Looking at various options, obviously looking for the least amount of work for the biggest bang. Re…

Service Broker - Missing Permissions? or something else.

Hi, I was wondering if someone could help me find the missing permission. We have a process which u…

Multiple Grouping with multiple tablix controls

Dear Team,I have a requirement to show the data at 3 different levels with multiple sections(in dif…

XE in Azure

Comments posted to this topic are about the item XE in Azure

Issue with using STUFF

HI,I am executing below query in query window then it works fine and get the result for Dept field …

Adventureworks tutorials that are NOT videos?

My girlfriend is a business student that is trying to learn more about BI/Reporting on her own. Ho…

Global Variables for connection manager

Hi Sir,Madam, We are trying to implement global variables in SSIS. for example from development to …

Document Map shows record from bottom

Hi All, I have created a sample report from adventureworksDW2012 database. I created a document map…

Query Result

Hello all, Please I want to be able to parse the result of this query to a variable using today's d…

Upgrade MCSA SQL 2012/2014 to MCSE

All, I would like to know what path should I chose in order to achieve MCSE for SQL 2016. I already…