SQL Server Archive
-
Hurry, You Only Have 69 Years to Fix Your App!
Thought the year 2000 bug was the last of it? Too bad, it's coming again. Unfortunately, you probably won't be alive to reap those consulting hour rewards to refactor legacy apps. -
Puzzling Situations: Using MultiValue Parameters with Stored Procedures in SSRS
Why developers go WTF? with SSRS MultiValue Parameters + SQL Stored Procedures, and how to fix that. A T-SQL Tuesday joint. This months theme: Puzzling Situations. -
FIX: SSIS Script Component Error “The value is too large to fit in the column data area of the buffer”
SSIS Error "The value is too large to fit in the column data area of the buffer." and Microsoft.SqlServer.Dts.Pipeline.DoesNotFitBufferException. Fix -
HOW TO: Uninstall SQL Server Embedded (from SharePoint or WSS)
Uninstall SQL Server Embedded edition How To. -
FIX: Cannot connect to MICROSOFT##SSEE database
If you can’t connect to the MICROSOFT\SS… Read the rest
-
FIX: SQL Server Stuck in Single User Mode – And You Can’t Get In
Ever get a SQL Server 2008 database stuck in SINGLE_USER_MODE, then find you can't maintenance it, access it, and even SP_WHO2 fails? Maybe you dropped it into SINGLE_USER_MODE to perform a DBCC CHECKDB type of repair, then tried to access it again and voila...you're not the only one in the database. This could happen in a number of scenarios, but a typical one in a SharePoint environment is the SEARCH database. -
FIX: FTP Task Blocked When Run in SQL Server Agent
Got the connectionstring and credentials down… Read the rest
-
Analyze and Optimize SQL Server Reporting Services Reports
Things to look for in SSRS optimization include… Read the rest
-
Free eBook: SharePoint & SQL Server 2008
Microsoft has released a free eBook for DBAs tha… Read the rest -
Connect to SharePoint database on MICROSOFT##SSEE
This handles the annoyance when trying to conne… Read the rest
