SQL 2016 - New Features

26/08/2018 13:08

Microsoft - Azure Discovery Days

26/08/2018 12:59
            Conclusion:   In my point of view, cloud, in general, it can significantly reduce the CAPEX, however, it depends on the projects. We should consider that solution for a new infrastructure/startup investment instead of in-premises or companies...

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...
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!