Copy files across the domains - Command DOS
12/05/2017 16:47
net use \\Server_destination\folder_destination /User:user_domain\username\password
xcopy \\Server_source\folder_source\*.* \\Server_destination\folder_destination
Articles
Trigger SSRS Subscriptions Manually
12/05/2017 16:42
SELECT ScheduleID
FROM ReportSchedule
WHERE (SubscriptionID = '04109b04-aaaa-bbbb-cccc-fe271bde49a4')
EXEC ReportServer.dbo.AddEvent @EventType='TimedSubscription',...
Change the SSRS file name by subscription (automatically)
12/05/2017 15:22
DECLARE @MMYYYY NVARCHAR(60),
@posI INT,
@posF INT,
@File VARCHAR(60)
Updating a SSRS Report through the Dynamic CRM
12/05/2017 15:20
Open the CRM -> Developers -> Customizations -> Customize the System -> Reports
Dock the Report Data Pane in Report Designer (SSRS)
12/05/2017 15:12
Applies To: SQL Server 2016 (to appear the Report Data - shortcut)
In Reporting Services Report Designer in SQL Server Data Tools (SSDT), the Report Data pane displays a hierarchical view of data objects that you can use in a report, including data sources, datasets, fields,...
Mudar a senha do Windows 2012 via remote desktop - Change the password through the terminal service
12/05/2017 15:09
Press WindowsKey+R (or get the Run box open) – then type OSK (It will open ‘on-screen-keyboard in your remote-remote session). Or open on-screen-keyboard in different way.
Then press on your physical keyboard (not on that on screen!!) ctrl and alt keys. Using your mouse tick DEL key on...
SQL Server - Top Features Coming to SQL Server 2017
12/05/2017 14:40
Microsoft has announced the new SQL Server 2017, in summary, these are the Top Features Coming up:
SQL Server in Linux
SQL Server on Windows today is built on Windows Server failover cluster for high availability and disaster recovery. In this session, we'll show how SQL Server 2017 running...
Sync tables in SQL databases using Row Version
22/02/2017 22:42
Problem
For SQL Server database professionals a common task is synchronizing data between two tables. There are different ways of implementing a solution in SQL Server such as Change Data Capture or Change Data Tracking, replication, using triggers and so on. However, there are...
One Note from Google
22/02/2017 21:50
Another different way to save your notes, online and free
https://keep.google.com/
Access: https://keep.google.com/
Create SQL Server Alias – CliConfg.exe
22/02/2017 21:49
If you are working with a number of SQL Server instances (or have really complex server/instance names!), you may already be familiar with aliases and using it to connect to instances. We create aliases for instances using SQL Server Configuration Manager.
However, SQL Server Configuration Manager...