Applies to:
Microsoft Windows 7 Enterprise
AutoHotkey (see code for AHK version)
What?
Someone suggested an app that counts the days I have left serving my notice. I thought I'd go one better ...
Applies to:
Microsoft SQL Server Reporting Services 2012
Microsoft Visual Studio 2012 Premium
Microsoft Windows 7 Enterprise
What?
So I have a column in an SSRS report which displays a date. ...
... do this:
On the server, open the XML file: C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer\RsReportServer.config
Set the recycle time to 0: 0
Restart the ...
Applies to:
Microsoft SQL Server Reporting Services (SSRS) 2008 R2
Microsoft Visual Studio 2012
Microsoft Business Intelligence Development Studio
What?
I recently revamped our standard ...
Applies to:
Microsoft Windows 7 Professional
What?
Looking at ways of displaying different drives per user on a single computer. This one is by modifying the system registry, so if you aren't familiar ...
... 0.4 seconds.
We're obviously not interested in shaving off time from 0.4 seconds; no, we're more interested in the fact that 0.4 Microsoft seconds seems to translate to about 10 minutes in the real ...
... files would speed things up).
Applies to:
Microsoft Windows XP
Microsoft Windows 7
Microsoft Windows 8
for Vista and Windows 2008 without XCOPY, try ROBOCOPY.
How?
We're going to use ...
... for Oracle:
-- -- REGEXP_REPLACE(country_name, '(.)', '\1 ')
-- -- REGEXP_INSTR(email, '\w+@\w+(\.\w+)+') > 0
-- -- REGEXP_SUBSTR('oracle', 'o r a c l e', 1, 1, 'x')
Microsoft T-SQL
Note the ...
... EPM (Microsoft Enterprise Project Management) more and more. Similar systems have popped out that support some form of time recording and activity logging. The example below however is within a LAMP/MySQL ...
Applies to:
Microsoft Business Intelligence Development Studio 2008 (BIDS)
Microsoft SQL Server 2008 R2
What?
This article describes solutions to the error:
Subscriptions cannot be created ...
What?
This is a quick article on how to convert some cells in Microsoft Excel to number values...
Why?
OMG. Seriously Microsoft! I have spent an hour trying to convert a column of currency values ...
Applies to:
Apple iOS 7
Apple iTunes 11.1.3.8
Microsoft Windows 7 Professional
What?
Just so many articles out there that did not help me. This article is how I finally did mine.
Why? ...
Applies to:
Microsoft Business Intelligence Development Studio (BIDS) Visual Studio 2008
Microsoft Windows 7
Microsoft .NET Framework 3.5
Microsoft Visual C# 2008
What?
So like lots of ...
Applies to:
MS SQL Server Management Studio 2008
Two Transact-SQL databases
What?
A quick article on how to compare two Microsoft databases using the tools provided with SQL Server and without ...
... myColumn
-- Reorder a column
ALTER TABLE myTable MODIFY COLUMN misplacedColumn AFTER otherColumn;
MySQL and Oracle PL/SQL
ALTER TABLE myTable
MODIFY myColumn myDataType
Microsoft ...
... silly T-SQL concatenation which requires plus signs and thinks it's super clever when it tries to add a number and a string together; then remembers it's a Microsoft by-product and realises it can't.
Solved ...
What?
This is a quick article to remind me on how to skip blank rows when using a Flat file as a data source. I would receive another Microsoft error as clear as mud:
Error: The conditional operation ...
What?
This is a quick note to myself so that I never use parentheses in the column headings again. Basically I have a pivot table in Microsoft Excel 2010 with the projects down the left (in the first ...
... inserting blank rows to act as dividers.
Microsoft Certified Responses:
"In the Excel connection you cannot skip Nth rows."
"It is not possible."
I am shocked at how responses to this and opinions ...
... + " 00:00:00")
So although your SSIS IDE (Visual Studio?) will give you a useless Microsoft message saying something like:
Error: Data conversion failed while converting column "This_Date" (3833) ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.