Search results

  1. P

    SQL Query Help

    You would have to pivot your results to get the answer to show up as a column.
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. P

    SQL Server questions pls suggest answers

    I'll try, but as mentioned, context might be important. I would go for option C for this question. Permissions define WHAT someone can do. However, these permissions are assigned TO different entities (I.e. users/groups or roles). Windows is a form of authentication, not authorization. I am...
  9. P

    SQL Server questions pls suggest answers

    Is this a homework assignment or something? What's the context of most of these questions?
  10. P

    cakephp - mssql connection string

    Are you running cakephp and SQL Server on the same server? Did you install the Microsoft SQL driver for PHP, and did you add it to your php.ini? You can find more info about the php driver here:
  11. 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...
  12. P


    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...
  13. 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...
  14. P

    Convert rows to columns query

    Hello Venkat. What have you tried so far?
  15. P

    time to upgrade

    Hi Roman. Without knowing hardware specs, it's literally impossible for anyone to estimate how long an upgrade would take. Even with specs, it's a tough estimate. I'd recommend you to attempt a run using a test server. Simply backup all your databases, and restore them on the test server running...
  16. 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...
  17. 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"...
  18. 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...
  19. 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...
  20. 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...