Ever worked on a quick little project, come across what you assume is a common need and think "I'll just google up some code that someone else has written and then be off to the races"? Have you done this and not been able to find the code you're looking for? Well, that was me… Continue reading SSRS: Parse parameters column from ExecutionLog
Man!!!! Why is the code to create a database snapshot so ridiculously complicated? Actually, I guess I understand why but how about allowing it to be done through SSMS and then setting a bunch of the parameters as defaults for us? Come on Microsoft! Help a SQL brother out! Well luckily, where Microsoft fails, I'm… Continue reading Easy SQL Server Snapshot Script / Proc
Don't you love how what should be a simple little tasks can become the most time consuming of the day? While trying to set up Visual Studio so that I could deploy directly to a development server I realized I would need the path to the SSRS ReportServer. Not the Report Manager mind you but… Continue reading How Do I Figure Out My SSRS ReportServer URL If It Is Not The Default?
Yay! There's a GUI to execute SSIS packages! Boo! It's really hard to figure out how to pass variables through it! You may have seen a message that looked something like this: TITLE: SSIS Execution Properties ------------------------------ DTExec: Could not set Package.Variables[User::MyVarA].Value value to Data Source=DevServ1. ------------------------------ BUTTONS: OK ------------------------------ Here are the three most… Continue reading How To Set Variables Using The SSIS Execute Package Utility
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) . SQL Server - TOP SELECT TOP 100 * FROM MyTable Corresponding PostgreSQL - LIMIT SELECT * FROM my_table LIMIT… Continue reading SQL Server T-SQL To GreenPlum PostgreSQL Syntax Cheat Sheet
Dear SQL Server Integration Services Team, Would it be possible to get a more specific error message than "There are some mapping errors on this path"? Your friend, Phil The tricky problem with this error is getting enough information to troubleshoot it. Here's a nice trick for you: Run the package. Wait. What? Why would… Continue reading SSIS: There Are Some Mapping Errors On This Path – Troubleshooting
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… Continue reading SSIS Export To UTF-8 or UNIX (or how to set your code page to output a flat file for unix)
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… Continue reading SSDT VS 2012 – Bringing an existing database under source control
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… Continue reading SSRS Subscription Error: Failure sending mail: The report server has encountered a configuration error. Mail will not be resent.
So you need to change the owner of an SQL Server Reporting Services subscription? No problema. (Why would you need to change it you might ask? Perhaps because you have deactivated the user account that created the subscription and now "strange things are afoot at the Circle K", and if you know that reference please… Continue reading Change The Owner Of An SSRS Subscription: The Simple Way