Browse by Tags

Now-a-days the buzz word is Data Analytics. Customers are savvy and want to know how we can help analyze their data. I feel Data Analytics should be part of every medium to large Dynamics 365 project. This is first of many blogs I will start writing for Data Analytics. ...

Una de las tareas más deseadas hoy en día por muchos administradores de bases de datos, es el particionar sus tablas, una de las grandes ventajas del particionamiento de tablas en SQL Server, es la capacidad de distribuir la carga física en múltiples discos duros, por ende, existen más partes mecánicas...

Table of Contents Introduction Prerequisites Create New SQL Database on Azure: Creating SQL Server on Azure Connecting Azure SQL Serve from Local SQL Server Setting Azure SQL Server firewall rule Creating Tables for Azure SQL Database Introduction In this article, we will see in detail...

Issue: Admin needs to send jobs status report to managers by email after every specific interval of time same as SQL Server builtin job activity console. Solution: Below is the store procedure that gets status of all jobs if Job_Id is null or get specific if sends Job_Id. USE [master...

Table of Contents Solution Reference See Also Solution This article shows an example of how to repeat headers on each page of SSRS report. Consider this code block is my dataset query from AdventureWorks database: SELECT TOP 100 BusinessEntityID,JobTitle,Gender FROM [HumanResources...

Table of Contents Overview Background Add-in code User Control code Complete UserControl code References Overview Sometimes it is necessary to use Excel automation in order to grab some information from a specific data source and put it in Excel directly. The objective is to get more control about...

Table of Contents Problem Definition Steps To Reproduce the Problem Reason Resolution Summary See Also Problem Definition Recently, there was a thread in the forums asking whether there is any way to avoid the dynamic SQL in the generated code while scripting out the stored procedures from SQL...

Stubborn? I just want to keep my (customers) server computers as clean as possible! In this blog post I share my notes and experiences from the field. Normal procedure for developing SSIS packages is to setup your SQL Server machine, additionally install SQL Server Integration Services and...

Table of Contents See Also Other Languages Thinking in Sets is a great book by Joe Celko . This book tells us about concepts, how we need to think when we are working with databases. Columns are not fields, rows are not records and tables are not files, hence SQL is declarative, not procedural...

Table of Contents Overview String Manipulation Using Custom Code Concatenating Data Column Values Into a Single String Scenario Solution Counting Occurrences in a Concatenated String Scenario Solution Sorting Elements of a Concatenated String Scenario Solution See Also Overview SQL Services Reporting...

The Request My dataset returns multiple rows of data for a given grouping with only one field (we will call it Grade) varying across those rows. I want my report to display a single line for a group with all of the values of Grade for that group displayed as a concatenated string in a single cell...

The Request Is it possible to have a field which contains a link to the build results? The Solution Yes. Links can be done in 2 ways (that I know of) in SSRS. The most common is to set the Action property of a control (textbox, image, etc.). If you right-click the control and open its...

Table of Contents See Also Other Languages The poster asked how to automatically adjust SQL Server's max server memory setting following a cluster fail-over - see here . I provided the following script with suggestions for how it could be tailored for their environment. USE [ master...

Today I presented a solution for a very common request - given a decimal number, find its floor (I am using this Wikipedia definition ) as well as its fraction. This is the solution as appeared in that referenced thread: DECLARE @amount MONEY; SET @amount = 812.85; ...

Slightly boring class for doing some regex... I've stored my notes on my pWord program which I also use for tracking passwords and it will always be open source. www.sourceforge.net/projects/pword . Please feel free to ignore my IE10 formatting woes using the WYSIWYG!. using System;...

Table of Contents Introduction COLLATION Introduction Before getting deep into the topic let's show you an existing feature of SQL Server. A simple table: A stock table just focusing on the item names. The item names are both case sensitive and case insensitive. Now we want to retrieve...

To understand how SQL Server defragments an index, consider a simplified example of pages after many insertions, updates, and deletions, as shown in the following figure : Page numbering represents the logical sequence of pages. However, the physical sequence as shown in the figure from...

More Ooten we may want to write custom Filters for Cube Data retrieved through Excel. You can achieve it through VBA or simply by adding few iterations on Excel. We can Achieve Custom calculations by simply adding OLAP PIVOT TABLE Extension to EXCEL . A common scenario would be building a 13-week...

Transact-SQL (T-SQL) é uma linguagem de consulta SQL Server. Este artigo lista os artigos do TechNet conhecidos que são dedicados aos vários aspectos da linguagem Transact-SQL . Tabela de Conteúdo SQL Server em Geral PIVOT CLR Datas Relacionadas Operador...

In SSRS, new roles and adjustments to existing roles must be performed in SQL Server Management studio, SSMS. After opening up SSMS, click on "Connect" and select "Reporting Services…" Enter your Server Name and login information and then click Connect. After...

Table of Contents Topics 1. DROP IF EXISTS 2. STRING_SPLIT 3. SYSTEM_TIME 4. JSON There are several SQL Server 2016 enhancements which are worth discussing. Topics 1. DROP IF EXISTS In old versions of SQL Server we had to check if the table or column exists before dropping...

PowerPivot para SharePoint – existentes Farm instalação SQL Artigo técnico do servidor Autores: Leon Cyril, Dave Wickert, Denny Lee Revisores técnicos: Lee Graber, Jennifer Chu, Kathy MacDonald, Artur Pop, Heidi Steen Publicado em: setembro de 2010 Aplica-se a: SQL Server 2008...

SQL Artigo técnico do servidor Aplicativos de camada de dados no SQL Server 2008 R2 Escritor: Alan Brewer, Roger Doherty, Prashant Choudhari, Shireesh Thota, Charlie Carson, Omri Bāḩat Revisor Técnico: Jen Witsoe, Muralidhar S, Clifford Dibble, Sanjay Nagamangalam Publicado em: fevereiro...

Table of Contents Introdução Opções de Criação Porque Usar? Introdução A View nada mais é do que visualizações que são criadas para encapsular o código e a complexidade das consultas, no BOL (Books Online) temos a seguinte definição: “Creates a virtual table that represents the data...

Table of Contents Introduzione Preparazione dell'ambiente Accenni su Powershell Pipelining Help in linea Interrogare SQL Server tramite Powershell e .NET Interrogare SQL Server tramite Powershell e cmdlet Codice di esempio Bibliografia Introduzione In questo breve articolo vedremo un utilizzo...