SQL Server Archives - All Things DotNetAll Things DotNet
  • Subscribe to this RSS feed
  • Receive updates as soon as they are posted.

SQL Server Category

You’ve just entered a new stored procedure and you run your web page which uses it and WHAM! – you get this error message. Luckily, it’s not too bad.

August 20 , 2015 | | In: ASP.Net, SQL Server, SQL Server Tips

Change UTC DateTime to Local Time

Recently, I found out our SQL Server was storing events in UTC time. An application I was creating needed to get a list of events that happened on a certain certain day. Since our Central Standard Time was a little off, I had to come up with a fix for this. I had a parameter […]

March 24 , 2015 | | In: SQL Server, SQL Server Tips

SQL Server – Invalid Column Name

If you’ve been working with new columns or renaming columns in a table and when you go to the stored procedure, the column names are underlined in red and hovering over them shows an ‘Invalid Column Name’ description, don’t worry, it’s not as bad as it seems.

October 13 , 2014 | | In: SQL Server, SQL Server Tips

SQL Server Stalls During Installation

This happened to me in both 2012 and 2014 SQL Server installations (on a clean Windows 2012 R2 installation) and frustrated me to no end. It was super hard just to get all the extra apps uninstalled. What happens is that installation fails when installing Setup Support files. It just hangs and won’t go any […]

September 2 , 2013 | | In: SharePoint, Sharepoint 2010, SQL Server

PowerView Review

I hate to admit that I’m behind the curve in this area, but I just saw a demonstration of PowerView today and was very impressed.

November 15 , 2012 | | In: SQL Server, SQL Server Tips

Manually Insert Null in SSMS

When using SQL Server Management Studio, sometimes (especially during testing phases) it becomes necessary to enter data manually. It’s easy when you actually want to enter text via specific datatypes, but what do you do when you want to force a field to null?

You can show SSRS reports (although in rdlc format other than rdl) in your ASP.Net applications fairly easily with the ReportViewer control. But one of the most powerful weapons available is the ability to use Expressions to make the report do or show different things dynamically.

Recently I’ve been working on several stored procedures for DotNet applications and, though they were created successfully, when creating and editing them in the SQL Server Management Studio window, some, but not all of the column names in the list to be selected/inserted/updated would have the well-known red squiggly lines beneath them, and the tooltip […]

I came upon a strange situation, that I had to really work with, to get it done. My website databases were all done in 2008, and backups would not work across hosts in my case (using .bak or detaching and getting .mdf files). So I went about learning to downgrade, since my new host used […]

February 10 , 2011 | | In: SQL Server, SQL Server Tips

Renaming SQL 2008 Database

For quite a while, to rename a database, you could just execute the system stored procedure called ‘sp_renamedb': EXEC sp_renamedb ‘OldName’, ‘NewName’ At one point though, as I understood it, the word was that it would not be supported after 2005.

All Things DotNet Discussed – Winforms/ASP.Net/SharePoint/WPF

If you find this site helpful,
please donate to help keep it online and free

Code 'n' Sprox   DreamTemplate - Web Templates

Follow us on Twitter

Follow AllThingsDotNet on Twitter

Test - The Name: 6936