Archive | T-SQL

SQL Server T-SQL To GreenPlum PostgreSQL Syntax Cheat Sheet

Here's a quick translation from SQL Server's T-SQL to Pivotal's MPP GreenPlum PostgreSQL for some of the most commonly used syntax (i.e. here's the stuff I've tripped over while moving from SQL to GreenPlum/Postgres) .   Loading... SQL Server - TOP SELECT TOP 100 * FROM MyTable Corresponding PostgreSQL - LIMIT SELECT * FROM my_table […]

Troubleshooting: SSIS Unable to retrieve column information from the data source. Make sure your target table in the database is available.

As soon as I saw this error message I guessed the problem was related to using a temp table. What was surprising was that the error message actually said this but I didn't realize it until by chance I cut and paste the message into another window.  Look below: Do you see the reference to […]

SQL Server To GreenPlum MPP/Postgres Transition

I'm working with a team building a data warehouse using Pivotal's GreenPlum MPP (Massively Parallel Processing) database which is based on PostgreSQL. Although, all the data modeling basics transition easily from RDBMS to RDBMS there's a bit of a learning curve switching tools and syntax. Listed below are some of the items I've noted during the […]

SSDT – Pre and Post Deploy Script Markers And Flava Flav

I admit, this post is primarily to provide a place for me to copy and paste my own code, but it's so sweet I figured some of you other SQL Server Data Tool Users might find it handy. When troubleshooting the generated deployment scripts I've always added a PRINT statement to indicate the beginning and […]

SSDT – The object reference differs only by case from the object definition warning

Well here's a Visual Studio SQL Server Data Tools (SSDT) warning I haven't come across before. I suspect the problem occurs only when performing a join to an external database reference dacpac. Luckily, the fix is simple (although a bit time consuming if you have very many of these warnings). First, the warning message will […]

SSDT VS 2012 – Bringing an existing database under source control

Alright! You are the hero of your database team! You've received the okay to start using SQL Server Data Tools to manage one of your existing databases. You think to yourself: "Within a few minutes I'll have the project up and running and I can move on to phase 2 of my plan to save […]

SSRS Subscription Error: Failure sending mail: The report server has encountered a configuration error. Mail will not be resent.

So, when a SQL Server Reporting Services subscription gives you an error message like: "Failure sending mail: The report server has encountered a configuration error. Mail will not be resent." You know exactly what to do to fix it right? Just fix the so called "configuration error". Problem solved! Another day another dollar. Am I […]

Preventing Failed SSRS Subscriptions: Which user created your subscriptions?

Check it out my friends. You need to keep an eye on which accounts are creating your SSRS subscriptions. Why? Because buried inside the ReportServer database (with no way to change it from the front end) SQL Server Reporting Services  is keeping track of this information. And when one of those user's account is disabled strange […]

Who Has The DAC?: Or How I Found Out I Had The Dedicated Admin Connection On SQL Server

Here's a quick little snippet of T-SQL script that will hopefully prove handy to someone (and that I'll end up googling at some point and find my own blog post). Are you trying to determine who is currently using the dedicated admin connection (aka DAC) on a particular SQL Server? Did SSMS give you a […]

Add Page Compression To Every Table In Your SQL Database The Winston Wolf Way

So you need to add page level compression to every table in your SQL Server database? I'm not going to judge you. I'm not going to tell you it's a good idea or a bad idea. I needed to do it in my DEV environment and maybe you need to do it in your production […]