Artigos Gerais

Set Up the Backup routine using the Windows Schedule Task - SQL Express

12/05/2017 16:48
1º - Prepare the database objects on Master DB -------------------------------------------------------------------   USE [master] GO /****** Object:  StoredProcedure [DBO].[spMaintenance]    Script Date: 13/02/2017 11:16:50 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER...

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

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 Access:  
1 | 2 | 3 | 4 | 5 >>

Crie um site com

  • Totalmente GRÁTIS
  • Design profissional
  • Criação super fácil

Este site foi criado com Webnode. Crie o seu de graça agora!