There’s a reason I love Steve Martin so much
I think I’ve found out why the help desk isn’t sending out emails… :-) http://twitpic.com/1tmt6q
OK, so you want SQL Server on the box over there with only 587 MB (or whatever) free on the C: drive. The problem is that a full SQL 2005 installation takes up almost 2 GB on the system drive, even if you install all you can on that fresh new 500 GB secondary drive [...]
Okay, so you have a corrupted index. I know, it never happens in MSSQL, so I guess this is just a proof-of-concept thingie. First let’stake a quick peek at your index, just to make sure this is a complete waste of time: SELECT a.index_id, name, avg_fragmentation_in_percentFROM sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL, NULL, NULL) AS aJOIN sys.indexes [...]
End of the year… AH! Okay so you checked and the periods and entering you latest invoices, for instance the one from 12/9-09 with a due date on 1/8-10 should be a piece of cake. But now you get an error: “Date Deviates from Permissible Range [Document Name – Offending Date] [Message 173-11]“. What the…! [...]
For accounting, need a script to backup before changing stuff $conn = new-Object System.Data.SqlClient.SqlConnection("Server=nybba0sql;DataBase=Northwind;Integrated Security=SSPI") $conn.Open() | out-null $cmd = new-Object System.Data.SqlClient.SqlCommand("CustOrderHist", $conn) $cmd.CommandType = [System.Data.CommandType]‘StoredProcedure’ # This Parameter Line This will error if Parameters are not accepted by Stored Procedure. $cmd.Parameters.Add("@CustomerID","ANATR") | out-Null $rdr = $cmd.ExecuteReader() While($rdr.Read()){ Write-Host "Product Name: " $rdr['ProductName'] } $conn.Close() [...]
First get all xtype ‘U’ (TABLES) in database: USE [database]SELECT * FROM sysobjects WHERE type = ‘U’ ‘P’ = Stored Procedures‘V’ = Views Next select all columns that matches: For a list of TABLES, COLUMNS and TRIGGERS… run this query that took mealmost *5 minutes* to write! SELECT O.[NAME] AS ‘TABLE’, C.[NAME] AS ‘COLUMN’, C.[ID] [...]
using : ubuntu minimal boot using: Unetinst using bootable USB Links: https://help.ubuntu.com/community/Installation/FromUSBStick http://www.lifehacker.com.au/2009/05/install-a-minimal-ubuntu-desktop/ https://help.ubuntu.com/community/Installation/MinimalCD http://www.howtogeek.com/howto/linux/create-a-bootable-ubuntu-usb-flash-drive-the-easy-way/ http://sourceforge.net/projects/unetbootin/
Using: SPList Using KWiz Scenario:Several subsites having each their department calendar.One main calendar that includes items from deepartment calendars. Main calendar running several calendars, like KWiz. First setup sub calendars to allow tagging for frontpage calendar:http://stsadm.blogspot.com/2008/11/my-new-powershell-cmdlets-for.html install the extention add a boolean column that indicates if it should be on main calendar.: PS C:\DEVELOP> $list [...]
If you, like me, used to copy your files to your Linux server just to get access to a decent Diff utility, despair no more. WinMerge is a must have tool in your belt: http://sourceforge.net/projects/winmerge/ Nicely color coded and it allows [ screens ]
