Sunday, July 17, 2016

SQL Hacks



1) make self admin sql express script. Just download and run the below script
https://gist.github.com/wadewegner/1677788


2)SSRS Deployment Script
http://www.sqlblogspot.com/2014/03/ssrs-deploymentcomplete-automation2012.html

-
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Devops links

  Build Versioning in Azure DevOps Pipelines 

  • Devops links
      Build Versioning in Azure DevOps Pipelines 
  • using Linq methods with caution - E.g FirstorDefault()
    Don't use FirstorDefault() unless you are sure its valid/ verified in the business scenario. else you are going to introduce bugs in t...
  • Sql Query titbits
    Generate Dates and hour between Date Range  DECLARE    @start DateTime = getdate() -1,    @end   DateTime = getdate(); ; WITH Dates_CTE     ...