Coverting SSRS 2005 rdl to SSRS 2015 rdl

SQLServerCentral » Latest topics

Coverting SSRS 2005 rdl to SSRS 2015 rdl

Hi
I apologise if this I in the wrong place.

I hope you can help, we have recently move from SQL Server 2005 to SQL Server 2014. I have now been tasked with moving the reporting services reports from the server hosting SQL Server 2005 to t

more info...

SQL Server 2016 Build List

SQLServerCentral » Latest topics

SQL Server 2016 Build List

Comments posted to this topic are about the item [B]SQL Server 2016 Build List[/B]

more info...

Comic for 2017.11.22

RSSMix.com Mix ID 8239024

Comic for 2017.11.22

New Cyanide and Happiness Comic

more info...

Disable Automatic update SSRS versioning issue

SQLServerCentral » Latest topics

Disable Automatic update SSRS versioning issue

Hello, i´m new woriking with SQL reporting services,
This is the issue:

Every time i restore the report server database works fine but
a couple of hours is corrupted by an error of versioning,
maybe something is upgrading the report

more info...

Better TSQL Performance

SQLServerCentral » Latest topics

Better TSQL Performance

Hi everyone, 

I am trying to improve query performance, I have encapsulated the following query into a stored procedure and have made some structural changes, added indices, etc (I an inherited a poorly designed db), but I feel I can do more

more info...

Choosing the Birthday of a Customer by month?

SQLServerCentral » Latest topics

Choosing the Birthday of a Customer by month?

[code language="sql"]CREATE TABLE birthdays(
 cust_id  INTEGER NOT NULL PRIMARY KEY
,cust_fname NVARCHAR(50) NOT NULL
,cust_lname NVARCHAR(50) NOT NULL
,cust_dob DATETIME NOT

more info...

Comic for November 17, 2017

RSSMix.com Mix ID 8239024

Comic for November 17, 2017

Dilbert readers - Please visit Dilbert.com to read this feature. Due to changes with our feeds, we are now making this RSS feed a link to Dilbert.com.

more info...

Cosmos DB Free for One Year and Other Azure Services Always Free

SQLblog.com - The SQL Server blog spot on the web

Cosmos DB Free for One Year and Other Azure Services Always Free

While the Cosmos DB emulator is a great way to learn Cosmos DB, it’s better to work directly with the full Cosmos DB service in Microsoft Azure. Previously this was a barrier to learning for many people. Now you can get 12 months of free access to Cosmos DB, Azure SQL Database, Linux and Windows virtual machines, and certain types of storage. Other Azure services are now always free including IoT and AI and Cognitive Services such as speech and face APIs. Go here to get all of the details. I previously...(read more)

more info...

Cluster Behaviour

SQLServerCentral » Latest topics

Cluster Behaviour

Hi Experts,

We have a 2 Node Active \Active Cluster of BizTalk and 2 Node Active\Passive cluster for Application. The Second node for both Application and BizTalk SQL Server resides in Data Center 2 . If the network connectivity between the Data

more info...

Data consistency

SQLServerCentral » Latest topics

Data consistency

I build ETL process and worry about data consistency
so I am going to use transactions functionality in SSIS where it is possible  
what do you think about this approach? 
Are there any best practices regarding transactions

more info...

[SQL 2014 - SSISDB] - Issue: Exception has been thrown by the target of an invocation in SSIS Script task with C# code, (Version 12.0.0.0, 32-bit mode)

SQLServerCentral » Latest topics

[SQL 2014 - SSISDB] - Issue: Exception has been thrown by the target of an invocation in SSIS Script task with C# code, (Version 12.0.0.0, 32-bit mode)

Hi All,
There is a package with script task deployed on server and there is a job to execute it, if I run it from File System or directly from BIDS,
it works perfectly. However when I try to do it thru Integration Services Catalog it returns mess

more info...

Date Ranges - Simple, but seemingly impossible

SQLServerCentral » Latest topics

Date Ranges - Simple, but seemingly impossible

Hi all,

I've done a lot of research and tried so many things for around a week. I'm desperate at this point, so I'm asking for your help.

I have this ProductDiscounts table:

more info...

Transactional Replication from SS 2016 to SS 2014

SQLServerCentral » Latest topics

Transactional Replication from SS 2016 to SS 2014

Is it possible to
a.  Create a Snapshot for Transactional Replication in 2016 and restore it in 2014 ?
b.  Have SS 2016 be a Publisher and SS 2014 be a subscriber ?

Are there any known or potential issues ?


Hemant

more info...

Comic for 2017.11.22

RSSMix.com Mix ID 8239024

Comic for 2017.11.22

New Cyanide and Happiness Comic

more info...

Vagrant and SQL Server 2017 on Linux

SQLServerCentral.com Articles

Vagrant and SQL Server 2017 on Linux

Vagrant provides a mechanism to build and configure a virtual Linux box running SQL Server 2017

more info...