snippet designate a certain time of the day in getdate()
Snippet to designate a certain time of the day to evaluate in the current day. If you need to limit a...
2013-04-23
350 reads
Sheldon Hull
- Website: https://www.sheldonhull.com
Native SSMS a second class citizen no longer…
Intellisense can be a boon to adding quick development. Quick hints on scope specific variables, syntax suggestions, function descriptions and...
2013-04-22
904 reads
dynamic sql and a char crash
Dynamic SQL can be helpful, but a pain to debug. I spent hours today working on figuring out why my...
2013-04-18
408 reads
How to default SSRS date parameters to the first and last day of the the previous month
Populating default dates in SSRS can be helpful to save the user from having to constantly input the date range...
2013-04-18
84,375 reads
Blogs
Bash: ^^}: bad substitution – upgrade your bash version
By HamishWatson
This blog post is about a situation where you are capitalising an argument in...
Azure Platform Series “You have exceeded the maximum amount of scale changes within the past hour”
By HamishWatson
This blog post relates to where you might be doing scale operations of your...
Bash: “command not found” in IF statement
By HamishWatson
This blog post is about a situation where writing an IF THEN ELSE statement...
Forums
Compare columns between 2 tables
Create TABLE #TableA ( TaskNameA nvarchar(100), GovernA bit, ToolTypeA nvarchar(10), ResourceNameA nvarchar(100) ) Create...
access registrykey from within SSRS report
I am trying to the code function to determine if a particular application is...
Powershell script giving the error "The specified value 'Patch' is invalid."
I am trying to patch my SQL server with CU8 and GDR for SQL...
Ask SSC