Skip to content
Brian  By Experience

Brian By Experience

A bit of everything. Robots, Software Development, Libertarianism, Christianity, Anti-war

  • Home
  • About
  • Essential Links
    • Essential Links: Christianity
    • Essential Links: Game, Web, & General Software Engineering
      • Client Side Web Technologies… Coooolll!!!
      • .NET Resources
      • C & C++ Stuff… yay!
      • Reporting
    • Essential Links: Libertarian-ism, Capitalistic Anarchy, and other Pro-liberty sites.
    • Essential Links: Robotics & 3D Printing
    • Essential Links: Vegetarianism and Veganism
  • Categories
    • Brian By Experience
      • Liberty
      • Christianity
    • SNLS
    • 3D Modeling, Rendering, Printing, etc
    • Brian’s Code Extreme
      • JavaScript
      • SQL
      • C#

Category: SQL

Why hasn’t MS updated the SSRS Viewer in a while?

From https://connect.microsoft.com/SQLServer/feedback/details/798562/add-auto-refresh-option-for-reports-on-manage-report-page-to-report-manager Thanks for your feedback! When the report is going through the actual Report Viewer (e.g. Report Manager), we … More

rdlc, SSRS
C#

When is your code done? When you finish the refactor refactor refactor rule.

Since unit test cases should be written before the actual code, you cannot say that code is done when the … More

C#

A Well needed Foreign key query for T-SQL

What is one of the biggest pains of troubleshooting data manipulation in a database? Foreign key constraints. So one guys … More

Constraints, Foreign Keys, Information_Schema, MSDN, Stack Overflow
C#

More on T-SQL DateTimeOffset, DatePart,ToDateTimeOffset, SwitchOffset and Timezones

SELECT CAST(‘2007-05-08 12:35:29.1234567 +12:15’ AS datetimeoffset(3)) AS ‘datetimeoffset’ ,DATEPART(tz,CAST(‘2007-05-08 12:35:29.1234567 +12:15’ AS datetimeoffset(3))) AS ‘timezoneoffset’ ,TODATETIMEOFFSET(CAST(‘2007-05-08 12:35:29.1234567’ as datetimeoffset(3)), 735) … More

DatePart, SwitchOffset, ToDateTimeOffset

Incrementing ID on a SQL row that you cannot use the Identity property with.

This is most common when the identity is not the primary key, and is tracked independently for each Foreign Key … More

Code Sample, SQL, T-SQL

Recent

  • Ugh… how many months has it been now?
  • One week success, one week fail, lets see about this week.
  • My latest political post
  • Casting down imaginations and all night things.
  • Pen vs sword

Search

Archives

Categories

Meta

  • Register
  • Log in
  • Entries feed
  • Comments feed
  • WordPress.com

Brian By Feed

RSS Feed RSS - Posts

Top Posts & Pages

  • Ugh... how many months has it been now?
  • One week success, one week fail, lets see about this week.
  • My latest political post
  • Casting down imaginations and all night things.
  • Pen vs sword
  • What is inflation, and when did this current disaster really begin
  • Trying something new
  • I ran out of visitors šŸ˜„
  • Fastest was to be hacked…
  • Friday one person caused my site to have a jump in traffic
Blog at WordPress.com.
  • Follow Following
    • Brian By Experience
    • Join 84 other followers
    • Already have a WordPress.com account? Log in now.
    • Brian By Experience
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy