contractorsramblings.blogspot.com
Developers Ramblings (formally Contractors Ramblings): TSQL Disk Usage
http://contractorsramblings.blogspot.com/2013/05/tsql-disk-usage.html
Developers Ramblings (formally Contractors Ramblings). An FAQ to my Contracting/Permanent life. Thursday, 23 May 2013. Only because I have a server with the Reports.Disk Usage doesn't like to work. This will show actual files sizes and MB used internally. Brian Jones aka TopGooner. Labels: SQL Server 2008. Subscribe to: Post Comments (Atom). Team Foundation Server 2010. Brian Jones aka TopGooner. View my complete profile.
contractorsramblings.blogspot.com
Developers Ramblings (formally Contractors Ramblings): December 2009
http://contractorsramblings.blogspot.com/2009_12_01_archive.html
Developers Ramblings (formally Contractors Ramblings). An FAQ to my Contracting/Permanent life. Thursday, 17 December 2009. TFS merge filename collision error. Anyhow, to sort this out I force got latest for the "main" repository, overwriting all the files. Then I merged the "development" tree back, and check in pending changes then worked with no error. All via the GUI. For details on a baseless merge. Brian Jones aka TopGooner. Labels: Team Foundation Server. Subscribe to: Posts (Atom).
contractorsramblings.blogspot.com
Developers Ramblings (formally Contractors Ramblings): September 2012
http://contractorsramblings.blogspot.com/2012_09_01_archive.html
Developers Ramblings (formally Contractors Ramblings). An FAQ to my Contracting/Permanent life. Tuesday, 18 September 2012. TFS2010 View and unsubscribe another users alerts. Unfortunately in TFS2010 there is on UI that allows you to view and remove another users post. The issue I had was that a user left, however emails were still being sent from TFS to his account. The solution - a bit messy. To view all alerts in a collection:. SELECT * FROM tbl EventSubscription ORDER BY Address. Brian Jones aka TopG...
contractorsramblings.blogspot.com
Developers Ramblings (formally Contractors Ramblings): May 2013
http://contractorsramblings.blogspot.com/2013_05_01_archive.html
Developers Ramblings (formally Contractors Ramblings). An FAQ to my Contracting/Permanent life. Thursday, 23 May 2013. Only because I have a server with the Reports.Disk Usage doesn't like to work. This will show actual files sizes and MB used internally. Brian Jones aka TopGooner. Labels: SQL Server 2008. Subscribe to: Posts (Atom). Team Foundation Server 2010. Brian Jones aka TopGooner. View my complete profile.
contractorsramblings.blogspot.com
Developers Ramblings (formally Contractors Ramblings): April 2010
http://contractorsramblings.blogspot.com/2010_04_01_archive.html
Developers Ramblings (formally Contractors Ramblings). An FAQ to my Contracting/Permanent life. Thursday, 8 April 2010. Solid State Drives for SQL Server. Interesting article on solid state drives and SQL Server. Brian Jones aka TopGooner. Labels: SQL Server 2005. Subscribe to: Posts (Atom). Team Foundation Server 2010. Solid State Drives for SQL Server. Brian Jones aka TopGooner. View my complete profile.
contractorsramblings.blogspot.com
Developers Ramblings (formally Contractors Ramblings): February 2010
http://contractorsramblings.blogspot.com/2010_02_01_archive.html
Developers Ramblings (formally Contractors Ramblings). An FAQ to my Contracting/Permanent life. Wednesday, 3 February 2010. SQL Server Stats and Query Optimiser tips. With 13 Things You Should Know About Statistics and Query Optimiser. Covers a lot of ground and is worth a read. Brian Jones aka TopGooner. Labels: SQL Server 2005. Subscribe to: Posts (Atom). Team Foundation Server 2010. SQL Server Stats and Query Optimiser tips. Brian Jones aka TopGooner. View my complete profile.
contractorsramblings.blogspot.com
Developers Ramblings (formally Contractors Ramblings): September 2010
http://contractorsramblings.blogspot.com/2010_09_01_archive.html
Developers Ramblings (formally Contractors Ramblings). An FAQ to my Contracting/Permanent life. Friday, 24 September 2010. SSRS load image from external assembly. This has been a bit of and adventure to get this to work. I had a standalone C# assembly for creating data matrixes (2D barcodes) and it exported as a bitmap. This is really no different from loading a bmp from disk. I wanted to create a report that displayed a data matrix per part in a table. There are a few issues with this:. In the Add Refer...
contractorsramblings.blogspot.com
Developers Ramblings (formally Contractors Ramblings): May 2014
http://contractorsramblings.blogspot.com/2014_05_01_archive.html
Developers Ramblings (formally Contractors Ramblings). An FAQ to my Contracting/Permanent life. Tuesday, 13 May 2014. Mixed mode assembly is built against version 'v2.0.50727' of the runtime and cannot be loaded in the 4.0 runtime without additional configuration information. Can not execute SQL Server RMO PublicationMonitor TransPendingCommandInfo from a .NET 4.0 application. Load LegacyV2Runtime at runtime. That will allow you application to use Mixed mode assemblies (CLR 2 and 4 in this case). Mixed m...
contractorsramblings.blogspot.com
Developers Ramblings (formally Contractors Ramblings): SQL 2012 Full Restore to a new database - error Database in use
http://contractorsramblings.blogspot.com/2014/03/sql-2012-full-restore-to-new-database.html
Developers Ramblings (formally Contractors Ramblings). An FAQ to my Contracting/Permanent life. Monday, 10 March 2014. SQL 2012 Full Restore to a new database - error Database in use. A colleague decided to use the new(ish) SQL 2012 Management Studio to restore a database to a new named database. Something that is simple in previous versions, and very useful when you don't want to overwrite an existing database. However, whenever he tried it always failed with Database in use error. Weird. Curious - this...
contractorsramblings.blogspot.com
Developers Ramblings (formally Contractors Ramblings): Transactional Replication : How to find erroring command and remove it
http://contractorsramblings.blogspot.com/2014/03/transacitonal-replication-how-to-find.html
Developers Ramblings (formally Contractors Ramblings). An FAQ to my Contracting/Permanent life. Tuesday, 25 March 2014. Transactional Replication : How to find erroring command and remove it. Had an interesting situation today where a replicated stored procedure call was in error. The issue was that the procedure call had some single quotes in a string parameter. This was giving the following error in Replication Monitor:. Get help: http:/ help/MSSQL REPL21001. Once the offending command has been identif...