Archive | Scripts

Parse pg_dump Functions and Views Into Their Own Files (GreenPlum / Postgres)

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 what we wanted: […]

SSDT – Pre and Post Deploy Script Markers And Flava Flav

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 admit, this post […]

Change The Owner Of An SSRS Subscription: The Simple Way

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 you need to […]

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

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 you need to […]

SQL Query To Find Expired Accounts In Active Directory: Knowledge Is Power And The Goodbye List

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 PracticesAlrighty. We're all data […]

Get The MAX Date From A Cube Using MDX

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 the goal: populate […]

SQL Job Steps And Run_Duration: The query that formats run_duration correctly and doesn’t make you want to shoot your eye out

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 tried to figure […]

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 […]