Archive | SQL Server Management Studio

How To Set Variables Using The SSIS Execute Package Utility

Free copy of SQL Best Practices? Get your copy of SQL Best Practices and be the database developer that has rocket fuel in his veins. Even better? These Best Practices are written in an easy to understand format so your whole team will quickly want to adopt them. Get SQL Best PracticesYay! There's a GUI […]

SQL Server To GreenPlum MPP/Postgres Transition

Free copy of SQL Best Practices? Get your copy of SQL Best Practices and be the database developer that has rocket fuel in his veins. Even better? These Best Practices are written in an easy to understand format so your whole team will quickly want to adopt them. Get SQL Best PracticesI'm working with a […]

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

Free copy of SQL Best Practices? Get your copy of SQL Best Practices and be the database developer that has rocket fuel in his veins. Even better? These Best Practices are written in an easy to understand format so your whole team will quickly want to adopt them. Get SQL Best PracticesHere's a quick little […]

Error when trying to use DAC connection in SQL Server

Free copy of SQL Best Practices? Get your copy of SQL Best Practices and be the database developer that has rocket fuel in his veins. Even better? These Best Practices are written in an easy to understand format so your whole team will quickly want to adopt them. Get SQL Best PracticesSo, one of my […]

SQL Server Impact Analysis Query

Free copy of SQL Best Practices? Get your copy of SQL Best Practices and be the database developer that has rocket fuel in his veins. Even better? These Best Practices are written in an easy to understand format so your whole team will quickly want to adopt them. Get SQL Best PracticesUgh. Impact analysis is […]

Formatting MDX and DAX: Free Online Tool From Microsoft

Free copy of SQL Best Practices? Get your copy of SQL Best Practices and be the database developer that has rocket fuel in his veins. Even better? These Best Practices are written in an easy to understand format so your whole team will quickly want to adopt them. Get SQL Best PracticesEver cut and paste […]

SQL Server Management Studio: Recover Lost Files

Free copy of SQL Best Practices? Get your copy of SQL Best Practices and be the database developer that has rocket fuel in his veins. Even better? These Best Practices are written in an easy to understand format so your whole team will quickly want to adopt them. Get SQL Best PracticesNooooooooo!  Power outage+unsaved files […]

Use F5 To Execute A Query In Visual Studio

Free copy of SQL Best Practices? Get your copy of SQL Best Practices and be the database developer that has rocket fuel in his veins. Even better? These Best Practices are written in an easy to understand format so your whole team will quickly want to adopt them. Get SQL Best PracticesIf you're coming to […]