Course-Schedule

 
@Blog

SQL Server 2012 MDS Excel Add-in Link and DQS Integration

2 months ago in Dejan Sarka

In SQL 2012 RTM, in Master Data Manager home page, there is a link to MDS Excel Add-in. However, the link is broken. However, as my good friend Allan Mitchell pointed me, you can download it from SQL Server...

@Blog

Azure Data Sync: Cleaning local databases and stop syncing

2 months ago in Azure Corner

It seems a recurrent topic this week in the SQL Azure forums, how do I remove an Azure Data Sync installation so I stop my syncing process and could delete all the Data Sync stuff (tables, stored procedures...

@Blog

Why I prefer using only Lync if anybody needs to contact me?

2 months ago in Fernando G. Guerrero

For multiple reasons, but the main one is that I do not want to keep status in multiple applications (Skype, Live, Facebook and so on). It is very annoying to receive a call from Skype or my cell phone,...

@Blog

Executing .NET code in Dynamics AX 2009: Solving error “the selected file is not a valid .NET assembly”

2 months ago in SolidQ AX Team Blog

To increase the functionality of AX is possible to execute .NET code.

In general terms the idea is create a .dll with the .NET code and after add the .dll as reference in AX. After that you’ll be able...

@Blog

MDS 2012 RC0 and Windows Built-In Groups

2 months ago in Dejan Sarka

I noticed an interesting issue with SQL Server 2012 RC0 Master Data Services. It seems that security does not work for some built-in Windows groups. It looks like MDS is not recognizing membership of some...

@Blog

Why Time Series Forecasts Impossible Numbers

3 months ago in Dejan Sarka

How can you measure the quality of forecasted values with the Time Series algorithm when you do not have the actual data yet? Waiting until the data is available is likely not practical because by that...

@Blog

SQL 2012 XML exist() Function NULL Comparison

3 months ago in Dejan Sarka

If the XML data type exist() function returns NULL and is used in comparison with 0, the comparison returns NULL in SQL 2012. Such comparison returned TRUE in previous versions. Consider the following...

@Blog

SQL Server 2012 XQuery Supplementary Characters Support

3 months ago in Dejan Sarka

From SQL Server 2012, XQuery functions are surrogate-aware. SQL Server Unicode data types, including NCHAR, NVARCHAR, and XML, encode text in UTF-16 format. SQL Server allocates for each character a unique...

@Blog

SSAS 2012 RC0 DMX IMPORT bug Workaround

3 months ago in Dejan Sarka

In SSAS 2012 RC0 Dimensional, importing a model with dependencies using the DMX IMPORT statement does not import data source views from a backup made with SSAS 2005, 2008 or 2008 R2. Thus, the imported...

@Blog

Inappropriate user interface: the most useless washbasin I have ever seen in a hotel room

3 months ago in Fernando G. Guerrero

Unfortunately, I spend too many nights in hotel rooms every year.

Fortunately, this gives me opportunities to learn about many things. One of them is what services companies, such as hotels, can do to...

@Blog

Powershell for the DBA: Cleaning SQL Server backup files

3 months ago in Enrique Puig Nouselles

One of the most important tasks for a database administrator is to backup all the databases for security reasons. As a Database administrator we need to make sure that in case of a disaster we will be...

@Blog

AX 2012 Installation with Enterprise Portal (Crash and Hotfix)

4 months ago in SolidQ AX Team Blog

A crash in the application can be due to a problem with Diasymreader.dll. You can see the full description of this problem and his solution here:

http://support.microsoft.com/kb/2390372

To solve this...

@Blog

Step by Step guide to Import a bacpac to SQL Azure Database via Import and Export CTP

4 months ago in Paras Doshi

In my previous post, we saw how to export a SQL Azure database to Azure storage as a bacpac. Now, in this blog post, we will import a bacpac to a SQL Azure database. Before we begin, we will need:

1)...

@Blog

Step by Step guide to Export a SQL Azure Database to Azure storage via Import and Export CTP

4 months ago in Paras Doshi

Import and Export (CTP) is an interesting SQL Azure feature that allows us to Export a SQL Azure database in form of a bacpac to Azure storage. And think of bacpac as the “zipped” version of schema and...

@Blog

Differences between SharePoint 2010 Management and Shell Windows PowerShell

In this article is going to be explained the differences between the Windows PowerShell console and the SharePoint Management Shell in SharePoint manage.

SharePoint 2010 Management Shell loads a Windows...

Follow us on: