Search results

  1. P

    Scripting a table in SQL Server Management Studio does not include indexes

    If you ever needed to script a table in SQL Server Management Studio (SSMS), you might have noticed that simply right-clicking the table, selecting "Script table as" will not include indexes: This is usually an issue, especially when you are using this script to integrate the tables into a...
  2. P

    Management Studio tabs not updating visually

    Recently I've encountered a situation where when switching between tabs in SQL Server Management Studio (SSMS), the screen doesn't refresh, making it look as if you are editing another query. Scrolling up and down would solve it, but it's quite annoying (not to mention confusing) if you are...
  3. P

    Management Studio overwriting instead of inserting text while typing

    For some reason, all of a sudden my SQL Server Management Studio (SSMS) started behaving somewhat odd; where other applications behaved properly, allowing me to type and the text simply being inserted, SSMS was overwriting text. I tested multiple other applications (Visual Studio, Notepad), but...
  4. P

    Azure Function error - Value cannot be null. Parameter name: uriString

    While attempting to fire a request at the Azure Function I deployed, I was greeted with the above error: As it turns out, while I thought I added the parameters used by the function (which on my local machine are pulled from the local.settings file), this turned out not to be the case...
  5. P

    (S)FTP Error: "Meet authentication failure when connect to Sftp server"

    Every so often when running an Azure Data Faxtory pipeline in which we attempt to source multiple files from an SFTP Server and subsequently dump them in a blob storage, we'd run into the following error: After a lot of poking around and testing, we determined this error is caused by the...
  6. P

    SSIS - Difference between MERGE and UNION ALL components

    As part of studying for a Microsoft exam, I came across a particular question: "You are planning a SQL Server Integration Services (SSIS) package. The sources have the same structure and data types. You have the following requirements: * The package must be able to combine data from at least...
  7. P

    SSAS: errors in the metadata manager the database with the name <db> already exists

    Should you ever be prompted with the error: , chances are that you renamed the name of the database recently. This is what happened in my case, and I ran into the error when trying to build the cube (and having changed the project settings to point at the changed database). As it turns out...
  8. P

    SSAS - Error THE ‘ROLE’ WITH ‘ID’ = {ID} DOESN’T EXIST IN THE COLLECTION.

    Today I was working on a new cube project. Basically we will be adding existing as well as new objects to a new cube. This will ensure the users will not be overwhelmed with all the objects existing in the existing cubes, but rather just see the subset they are interested in (and taking these...
  9. P

    Visual Studio/NuGet error: "... already has a dependency defined for ..."

    In order to get rid of some 2.3k error messages in Google Webmaster (for a different site), I figured I'd code a solution to do this for me, rather than doing so manually. This would require me to use the Google Apis Client Library in Visual Studio 2013. When attempting to do so, I received...
  10. P

    SSIS - Milliseconds truncated from datetime variables

    If you are using SSIS, chances are that you are using incremental loads in some places. If you are, there's a high likelihood that you aren't limited to using incremental IDs for watermarks, but at times might have to resort to using a LastLoadDate or something similar. In a lot of cases, you...
  11. P

    MDS: Reversing transactions (bulk process)

    At my current customer, somebody accidentally deleted a large number of entries. In itself, this is not a problem, as MDS offers a great way to reverse transactions (provided you configured MDS to use version management). To do so, go to the MDS homescreen, select the "Version Management"...
  12. P

    SSRS Error - An item with the same key has already been added

    I was working on an SSRS report today. It's a fairly straightforward process; select a data source, paste in a query, and click "Next". Not with this report. The error in the title popped up for me. It's a pretty non-descriptive title, though, so I popped open the Query Builder, hoping to find...
  13. P

    Terry Pratchett (Discworld) saying "Bingely bingely beep"

    This is as off-topic as things might get, but in my spare time I enjoy reading. One series of books that I love dearly is the Discworld series by the late Sir Terry Pratchett; a man whose writing skills and sense of humour were on a completely different level. In the series, onbe of the main...
  14. P

    Installing scrapy for Python on Windows

    Scrapy is a web-scraping library for python. Installing it (once Python is installed) is fairly straightforward. First of all, we'll have to install pip. Pip is a package manager for python. The easiest way to obtain it is by saving the following page to your local computer (like, for instace...
  15. P

    Deploying a DLL to the Global Assembly Cache

    If you are going to be using third-party (or your own) DLLs from inside SSIS, you will have to ensure the DLL is registered on your target server(s). This article is meant to describe how to do this. First, find the DLL you need. For the sake of this article, let's assume we have grabbed a copy...
  16. P

    SSIS - Search in files

    Recently I wanted to know which of my packages contained SQL that referenced a specific table. I ended up copying all packages to a folder, and painstakingly performing a text-based search in the files to find the table in the script. Today, a colleague showed me this is actually possible...
  17. P

    SSAS - Missing admin user

    This morning, I noticed my local installation of SSAS was complaining it didn't recognize my user account. This is probably because it's been quite a while since I logged on to the corporate domain, and I suspect my token expired. In SSAS this manifested itself by my userid being replaced with...
  18. P

    SSIS Error: "Meta data for: ... "does not match the metadata for the associated output column"

    This morning, I found myself adding some new columns to an existing dataflow that uses a Union All to combine data from 4 different SQL sources. It had been set up so all SQL statements produce the same columns, and I added some default fields to accommodate for the sources that do not have the...
  19. P

    SSIS - Error: "an item with the same key already been added"

    A colleague of mine just ran into the following error: At the time he was copying some objects from one SSIS package to another, as he had been doing most of the day. However, all of a sudden this error popped up to ruin his day. He didn't actually try to save or do anything, but even just...
  20. P

    SSAS - Drill-through row count is capped at 1,000 rows

    Our customer has requested the ability to have drill-downs in the cube, so we set those up in SSAS as actions. However, today she came and asked if we somehow capped the rowcount at 1,000 rows. Seeing I wasn't the developer who originally set the drill-through up, I got a bit worried, as...
Top