-
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 […]
-
Which code page for UTF-8?
If you’re trying to export data in Windows to a UTF-8 format you may be wondering which code page you should use. Well the riddle is solved. Code Page 65001 is the equivalent of UTF-8. If you need to create an SSIS package to export data as UTF-8 for consumption by a unix system you should […]
-
SSIS Export To UTF-8 or UNIX (or how to set your code page to output a flat file for unix)
As more and more companies are moving to heterogenous environments with both windows and unix systems the life of the Microsoft SQL Server developer is becoming much more interesting. For our recent data warehouse project I was asked to create a SQL Server 2012 Integration Services (SSIS) ETL package to output a text file for […]
-
SQL Query To Find Your Version of GreenPlum or Postgres
Ummm, what version of GreenPlum am I running? (Which is the same as asking: What version of Postgres am I running?) There are a few easy ways to figure this out but I’ll stick with the SQL since that’s the most universal: SELECT VERSION() That’s it. I wish I could make it more complicated. 🙂
-
Find all users in an Active Directory group from the command line (no matter what your perms)
For some reason no one has ever trusted me enough to let me help administer the active directory groups. This means I’m always adding database perms to groups somewhat blindly, hoping the group names are intuitive enough that I can deduce who’s in them. Enter the magic of the command line! Turns out you can […]
-
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 […]
-
Where is vsdbcmd.exe in Visual Studio 2012!?!
Looking for your old friend vsdbcmd.exe in visual studio 2012? There’s good news and bad news. The bad news is it’s gone and it’s not coming back. (see this MSDN thread if you don’t believe me). The good news is there’s a replacement: sqlpackage.exe The path for sqlpackage.exe is typically: C:\Program Files (x86)\Microsoft SQL Server\110\DAC\bin […]
-
Handrawn SAFe Agile Doodlegraphic
A few years back I remember ready an article saying that people who doodled while listening to a lecture retained more information than those who did not doodle. With two solid days of training on the Scaleable Agile Framework (aka SAFe) I thought it might be a good idea to give it a try. Then […]