Kevin Shyr
8 posts.
- Follow up thoughts on IE password eye feature - not a bad feature, but should be off by defaultA few months ago when IE 10 first came out, I made this post. I'll admit it was a rant, and I appreciate all the comments. People actually care about this…
- Be aware: Internet Explorer 10 has a password Eye. They call it a feature, I say it's a security flawI'm glad my work laptop and my other machines are maintained centrally and not going out to get the latest updates on everything. We have one laptop…
- Time to stop using “Execute Package Task”– a way to execute package in SSIS catalog taking advantage of the new project deployment model ,and the logging and reporting featureI set out to find a way to dynamically call package in SSIS 2012. The following are 2 excellent blogs I found; I used them heavily. The code below has…
- SSAS deployment error: Internal error: Invalid enumeration value. Please call customer support! is not a valid value for this element.The first search on this error yielded some blog posts that says to check SQL server version. It suggested that I couldn't deploy a SSAS project…
- SSAS processing error: Client unable to establish connection; 08001; Encryption not supported on the client.; 08001After getting the cube to successfully deploy and process on Friday, I was baffled on Monday that the newly added dimension caused the cube processing to…
- Date Dimension: use date in YYYYMMDD format if your granular level is a single dateIt still surprises me how many people set up the DateDimID as Identity(1, 1). If you use YYYYMMDD format, then on some reports, you can even display the…
- Do NOT trust CHECKSUM or BINARY_CHECKSUM in SQL, use HASHBYTES insteadWe had a process ot using BizTalk to take in a reference file, then send data in via a table\type parameter in a stored procedure. The stored procedure…
- Windows Virtual PC vs. Hyper-V Virtual Machines vs. Windows Virtual PC after XPMode installation Advantages and DisadvantagesHyper-V Virtual Machines Advantage: - 64-bit support - dynamic memory allocation - multi-core CPU - Can install Windows 7 and Windows Server 2008 and later