Posts

Showing posts from August, 2013

Free SQL Server Management Studio Addin/Plugin/External Tool to get object information quickly

Image
A small utility written in c# to help get object information in SQL Server Management Studio quickly and easily. It can be used on any version of SQL Server and on any SQL Server databases. You might have been a big fan of Alt-F1 (sp_help) but it has it own restrictions, object has to be in the same database to use Alt-F1 key and get the object information.This utility can help you overcome that limitation along with other features. Please read the entire documentation to configure and use the utility.

Download VAKATI SSMS Helper
Google Drive by default opens in preview mode and shows you all the files, go to File Menu and click download menu item to download as a zip file.
Features Can run outside of current database context.
Can get information on all the valid objects in the selection at once.


Displays output in a different window so your last execution results stays in the results grid.
























Can be used using user defined hotkeys(SSMS 2012).

Cons:
Output in text, so not selectable using column…

Kingston KTD-PE316K4/32G and ASUS M5A97 R2.0 Socket AM3+ ATX AMD Motherboard

The following two products don't go well together, so get only the ram mentioned in the qualified vendor list from asus.

I couldn't understand why it doesn't work even though the motherboard spec clearly says that it can support DDR3 ECC, Non ECC 1600mhz ram modules.


http://www.microcenter.com/product/410801/32GB_DDR3-1600_(PC3-12800)_Desktop_Memory_Kit_(Four_8GB_Memory_Modules)_KTD-PE316K4-32G

Kingston 32GB DDR3-1600 (PC3-12800) Desktop Memory Kit (Four 8GB Memory Modules) KTD-PE316K4/32G

Specifications
FeaturesFeaturesFor Dell PowerEdge R620, T620SpecificationMemory TypeDDR3Number of Modules4Memory Capacity32GB (4 x 8GB)Memory SpeedDDR3-1600 (PC3-12800)Error Correction CodeECCMemory Slot240-pin DIMMWhat's in the BoxWhat's in the Box4 x 8GB DDR3 Memory ModulesManufacturer WarrantyParts5 YearsLabor5 Years

http://www.microcenter.com/product/398235/M5A97_R20_Socket_AM3_ATX_AMD_Motherboard

ASUS M5A97 R2.0 Socket AM3+ ATX AMD Motherboard

SpecificationsGeneralFeaturesD…

Creative Sound Blaster Audigy2 ZS SB0350 7.1 Channels 24-bit 192KHz PCI Interface Sound Card Windows 7 64 bit NO SOUND

I like my Creative Sound Blaster Audigy2 ZS SB0350 so I took it from my old pc and installed it on a newly built windows 7 64 bit edition pc but there was no sound. I installed the driver properly no exclamations in device manager but no sound.

I uninstalled the device  from the device manager, restarted the pc and got my sound going.

Creative Sound Blaster Audigy2 ZS SB0350 7.1 Channels 24-bit 192KHz PCI Interface Sound Card

Specs from creative/newegg
http://www.newegg.com/Product/Product.aspx?Item=N82E16829102178

ModelBrandCreativeSeriesSound Blaster Audigy2 ZSModelSB0350 Audio coreAudio ChipsetAudigy2Channels7.1Sample Rate192KHzDigital Audio24-bitHardware DecodeDolby Digital EX 6.1Polyphony64 Voices (Hardware) PortsLine InYesLine OutYesSPDIF OutYesMIC InYesMIDI/JoystickYesCD/Aux InYesFireWire (IEEE 1394)1 SpecInterfacePCIOperating Systems SupportedWindows 98SE, ME, 2000 SP2, or XPSystem RequirementsProcessor: Genuine Intel Pentium II, Celeron 350MHZ,AMD-K6 450MHz or faster
Motherboa…