Fwd: T-SQL Starter Statistics Package for SQL Server (MSSQLTips 06/07/2018)

-
View MSSQLTips newsletter online
Tutorials | Tips | Videos | DBA | Developer | Business Intelligence

Have a SQL Server Assistant on Hand with SQL Doctor

T-SQL Starter Statistics Package for SQL Server

In this tip we cover several different T-SQL scripts to help you get started with statistics for SQL Server data....

Migrate SQL Server Database from Windows to SQL Server on Linux in Cloud - Part 3

In this tip we look at how to migrate a database from SQL Server on Windows to SQL Server on Linux....

Is Tempdb Giving You Troubles? Take Control of Tempdb!

Attend this webcast to learn how SQL Diagnostic Manager monitors tempdb, charts critical metrics for tempdb over time, alerts for issues with tempdb, and generates the tempdb statistics report....

10 Ways to Save Money for SQL Server High Availability

Do you know how to provide high availability protection for SQL Server without upgrading to Enterprise Edition? Learn how to get robust data protection features for a fraction of the cost of SQL Enterprise Edition with AlwaysOn Availability Groups in...

SQL Server Database Restores Tutorial

What good is a backup if you do not know to restore the backup. In this tutorial we will look at what restore options are available and which options are only accessible using T-SQL commands....



Adding SQL Server AlwaysOn Availability Groups to existing Failover Clusters

AlwaysOn is the new high availability feature introduced in SQL 2012 which allows us to create multiple copies of a highly available database using a Windows Server Failover Cluster (WSFC). In this tip we cover how to add AlwaysOn to an existing Failover ...

Passing Dynamic Query Values from Excel to SQL Server

We have always used Excel as a presentation layer to import data from SQL Server for analysis. For queries using parameters - if we have to change the values of parameters, we have to go to the Connection and make the change which isn't an easy way of doi...

Understanding the SQL Server Integration Services Catalog and creating the SSISDB Catalog

This tip will demonstrate you how to easily and quickly set up the SSIS catalog for SQL Server....


Comments

Post a Comment

Popular posts from this blog

How to import data in Ax2009 from a CSV file

-
In Microsoft Dynamics AX 2009, importing data from a CSV file can be done through the Data Import Export Framework (DIXF) , AIF (Application Integration Framework) , or by using X++ code to handle custom imports. Here's a step-by-step guide to importing data from a CSV file: Method 1: Using AIF (Application Integration Framework) AIF is commonly used for integrating external data in AX 2009. Here's how you can use it to import data from a CSV file. Step 1: Create an AIF Service Define an inbound port for the data import: Navigate to Basic > Application Integration Framework > Channels . Create a new channel for importing the CSV file, specifying the necessary details. Create a Data Service : Go to Basic > Application Integration Framework > Services . Add a new service or choose an existing one that handles the type of data you want to import (e.g., purchase orders, vendors). Setup File Adapter : Go to Basic > Application Integration Framework > Adapters . U...
For More Details »

July 2017 update: Form Adaptors Replaced by Type Providers

-
The July 2017 update of Microsoft Dynamics 365 for Finance and Operations, Enterprise edition includes many new features and changes. One of our new features is  type providers . Type providers are a new way to interface with forms in unit tests without a form adapter model. Previously, when a developer built or changed a form they would also have to add the adapter for the form to the same solution and rebuild the model to see the new form changes in test code. Type providers provide instant design time support, so that tests can access forms. With type providers, we have removed the need to maintain a form adapter model and the need for extra compile time to generate and compile the form adapter model. We removed the form adapter models in the July 2017 update because they are expensive to run and maintain. In general, the type provider framework requires less processing time, and is more flexible to use than the form adapter models.
For More Details »

X++ to C# Comparisons

-
Differences The following table lists X++ features that are different in C#. Feature X++ C# Comments Declarations All declarations must be at the start of the method, before any X++ statements. Declarations can occur anywhere in the method. Both languages permit multiple variables of the same type to be listed together in one declaration. Both languages allow you to assign an initial value in the declaration statement. if  and  else conditional statements The  if  statement accepts any type of expression that it can automatically convert to a Boolean. Common examples include an  int  for which 0 means false, or an object for which null means false. The  if  statement requires a Boolean expression. The syntax structure regarding curly braces and parentheses is exactly the same between X++ and C#. Literal string A literal string can be delimited by either of the following: A pair of double quotation mark (") characters. A pair of singl...
For More Details »