QlikView/QlikSense Script: Mapping & ApplyMap

MAPPING, ApplyMap: ejemplo // Nota: salto adrede algunos números MiMapa: Mapping LOAD * INLINE [     Codigo, Valor     1, Mercurio     2, Marte     3, Venus     7, Saturno     8, Jupiter ]; TablaSinMapping: LOAD * INLINE [     UnIndice     1     2     3     4     5     6     7 …

QlikView/QlikSense Script: Mapping & ApplyMap Leer más »

QlikView Course Content – Level 2: Developer (16 h)

1. Loading Files and Database Data What is a qvd file? Optimized load Using ODBC and OLEDB Script Checking and Debugging Script control flow (conditional, loops) 2. Associating Data from Several Tables Associations Loading and associating a second table Renaming fields Qualify / Unqualify Mappings Save table to file Resident data source 3. Concatenating Tables …

QlikView Course Content – Level 2: Developer (16 h) Leer más »

QlikView Course Content – Level 1: Designer (16h)

1. Introduction What is QlikView? QlikView Basics Document 2. Query editor: simple data load from file 3. QV Objects 4. Making Queries in a QlikView Document Basic QlikView terminology / colors Associative selections Stepping back or forward in the list of selections Locking and unlocking selections Searching values Selection bookmarks 5. Script Editor Basics: Loading …

QlikView Course Content – Level 1: Designer (16h) Leer más »


Stolen  Copied from Adam Machanic’s blog ( STRING_SPLIT Aaron Bertrand’s performance tests: Session Context   Time Zone Support sys.time_zone_info: AT TIME ZONE:   HASHBYTES   Session Wait Stats   Live Query Statistics Ability to attach to other sessions’ Live Queries!   Actual Query Plan Data Enhancements …

T-SQL 2016 NEW FEATURES Leer más »


New time functions in SQL 2016 Converts an inputdate to the corresponding datetimeoffset value in the target time zone. If inputdate is provided without offset information, the function applies the offset of the time zone assuming that inputdate value is provided in the target time zone. If inputdate is provided as a datetimeoffset value, than …

AT TIME ZONE (T-SQL) Leer más »

SQL Server Backup Encryption

To encrypt a backup we need to configure an encryption algorithm (supported encryption algorithms are: AES 128, AES 192, AES 256, and Triple DES) and an encryptor (a certificate or asymmetric key). So if you don’t have a Database Master Key defined you need to create one.


Dedicated Administrative Connection: How to Enable the DAC for Remote Connections and Clusters EXEC sp_configure ‘remote admin connections’, 1; GO RECONFIGURE GO

SQL 2016 SP1 – Consistent Programming Surface Area

On 16th Nov 2016, Microsoft announced the support for ‘Consistent Programming Surface Area’ across all editions of SQL Server with few exceptions. Please refer to the The key value proposition is that it allows customers to use the same code base independent of the editions in SQL Server.

BCP simple example

desde consola (cmd) cd «C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\130\Tools\Binn» bcp «Person.Address» out c:\data\Address.txt -S «» -d AdventureWorks2014 -Usa -Psql -c -T Fichero generado: C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\130\Tools>bcp -? uso: bcp {tablabd | consulta} {in | out | queryout | format} archivo de datos [-m errores máximos] [-f archivo de formato] [-e archivo de errores] …

BCP simple example Leer más »