Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

BIT Barbarian

After working in the mortgage industry for 7 years, I transitioned into Business Intelligence and began learning SQL and .NET. My goal is to integrate my business knowledge into my development to intelligently analyze and find solutions to problems. Blogging offers me an option to share what I've learned as well as receive feedback on better practices and solutions.

Archives: April 2013

Installing SSMS 2012 all by it’s lonesome

SQL Server Management Studio (SSMS) is not offered as a standalone download on MSDN.

Installation requires the user to download the sql server installation package and choose to install only this single feature. For developers, SQL Developer edition is a great choice. 

Read more

0 comments, 16,909 reads

Posted in BIT Barbarian on 30 April 2013

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 result to the current date after a particular time, strip the time out of the date, and concatenate the current time together with it, and then convert back to… Read more

0 comments, 33 reads

Posted in BIT Barbarian on 23 April 2013

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 more provide a valuable tool to productive coding.

Coding in SQL Server Management Studio (SSMS) has greatly improved over the version releases, but it still lags behind the power of… Read more

0 comments, 244 reads

Posted in BIT Barbarian on 22 April 2013

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 simple date comparison in dynamic SQL wasn’t working. Found out that the remote database I was connecting to had a char date instead of a datetime. I found the comparison… Read more

0 comments, 116 reads

Posted in BIT Barbarian on 18 April 2013

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 they normally would use. When a report is pulled for last month’s information, defaulting the date fields for the user can help streamline their usage of the report, instead of… Read more

0 comments, 3,021 reads

Posted in BIT Barbarian on 18 April 2013