Ask Paula!

...bringing you notes from the field...
posts - 117 , comments - 87 , trackbacks - 0

My Links

News

Copyright © 2008-2014 Paula DiTallo

Tag Cloud

Article Categories

Archives

Post Categories

Image Galleries

.NET Development

Enterprise Integration

Entertainment - Games

Java Development

Mobile/PDA Development

Professional Affiliations

Practical Answers

Answers to problems/questions across all topics.
How Do I Install an Eclipse Plugin from a *.zip File?
If you aren't able to install from the Help\Install New Software menu, it is probably because the zip file doesn't have the content.jar/artifacts.jar needed to do so. You will need to navigate to where you've installed Eclipse, then follow these steps: 1. Navigate to the Dropin drectory2. Create a new subdirectory (folder).3. Expand the zip file to the subdirectory folder. 4. Restart Eclipse5. Under the Windows\Open Perspective menu, look for your plugin ......

Posted On Tuesday, July 15, 2014 11:29 AM | Comments (1) | Filed Under [ Practical Answers ]

Sql Server: Orphaned user name; Can't login, User name disappeared from my database
This usually happens when you restore a database. For example, you restore a copy of production database X to your QA server. In essence, you have overwritten the user info of that specific database with what exists in production. This creates an orphan user -- where you have no login associated with a user in that database on a server that once associated that user with the old copy of the database.Here is what to do fix the issue:1. Validate that what you think is the problem is the problem. Do ......

Posted On Monday, June 30, 2014 3:32 PM | Comments (0) | Filed Under [ Practical Answers ]

SQL Server: Restoring a backup generates this error: Operating system error 5(Access is denied.).
There are several reasons for this. The most common reason is that the account you are using while logged into mssql through ssms does not have access to the drive definition you are using as your source. Network drives are a good example of an access conflict.Assuming you have access to the drive, try redirecting the network drive to a local drive letter via xp_cmdshell (Note: be sure use of xp_cmdshell is enabled) .exec master..xp_cmdshell 'net use Z: "\\BackupServerXX\<share... ......

Posted On Thursday, June 26, 2014 3:32 PM | Comments (0) | Filed Under [ Practical Answers ]

SQL Server: How do I generate the table schema and populate it with inserts in a script?
In SSMS, there's a Generate Script utility (read: only available under version 2008 and up) . Here are the steps you would need to take to make use of the utility: Right click on the database you're interested in and go to Tasks -> Generate ScriptsSelect the tables and/or any other objects you'd like in order to get them into the script.Navigate to Set scripting options. Click on Advanced.Under the General category, navigate to Type of data to scriptSelect the Schema and Data option to get the ......

Posted On Tuesday, May 20, 2014 5:46 PM | Comments (0) | Filed Under [ Practical Answers ]

How do I find the largest files on my disk (storage)?
Here's an example using forfiles to scan your storage. This command line will look for files over 200mb on the C:\ drive after 1/1/2014.

forfiles /P C:\ /M *.* /S /D +"01/01/2014"  /C "cmd /c if @fsize gtr 209715200 echo @path @fsize @fdate @ftime"

For more information, check out Microsoft's examples and syntax page:

http://technet.microsoft.com/en-us/library/cc753551.aspx

Posted On Tuesday, May 6, 2014 10:06 AM | Comments (0) | Filed Under [ Practical Answers ]

Sql Server: Select Count(*) throws the error: Arithmetic overflow error converting expression to data type int
Try using count_big(*) instead-- this is defined as bigint instead of int.In this example, I am looking for how many 100s of millions of rows exist by product type where each row is roughly 300 bytes wide to ultimately obtain how many gigabytes of data I need to provision.select x.ProductType, count_big(*) as ProdCount, (count_big(*)*300) as TotalBytes, ((count_big(*)*300)/1073741... as Gigabytes from fdwintegration.etl.fuelpric... x inner join fdwintegration.etl.FuelProd... y on x.ProductIndicator ......

Posted On Monday, April 21, 2014 5:01 PM | Comments (1) | Filed Under [ Practical Answers ]

How Do I Alphabetize the Application Icons on my Droid?
Click on the App Button (aka: "Drawer" ) -- That's the key with the multiple squares, click on menu , select view type, select alphabetical grid.

Posted On Tuesday, April 8, 2014 12:48 AM | Comments (0) | Filed Under [ Practical Answers ]

Windows: How do I find what process is locking a file?
Open up an MSDOS command window. Type :net fileThe id, path, user name, loc# for the file will show up in a text list. Once you find the file you want unlock, you'll need to remember the id. To unlock the file, go back to the MSDOS command window. Type:net file 99/close (where 99 = file id)On a windows server there are 2 other ways:1. From an MSDOS command window type: Openfiles.exe /query /s YOUR_SERVER_NAME2. Server Manager>Roles>File Services> Share and Storage Management (right click ......

Posted On Friday, December 13, 2013 5:11 PM | Comments (0) | Filed Under [ Practical Answers ]

Linux/Unix: How do I find any partial file name on any directory?

We've all been there-- like -- where's that offline htm file i bothered to save last week ... oh I think it was blue something... or was it something blue?

find ../ -name '*blue*.htm*'  -print

If you want to keep it in an output file to sort through later while you do something else:

find ../ -name '*blue*.htm*'  -print > $HOME/ foundBlue.txt

 

Posted On Wednesday, December 4, 2013 12:24 PM | Comments (0) | Filed Under [ Practical Answers ]

My old (generation 2) nano iPOD won't shut off.

Try holding down the Menu and Selector (push-button circle in the center) down at the same time for at least 2 seconds.

Posted On Tuesday, October 8, 2013 8:01 PM | Comments (0) | Filed Under [ Practical Answers ]

My iPOD keeps saying "Do Not Disconnect" while charging. I can't listen to anything.
The simplest answer is because the iPOD software detects that it is unsafe (read: data loss) for your iPOD, Computer or both if you were to disconnect the cable without ejecting the device first.Here's what to do:On the Mac-- Click on the Finder icon Pick the iPOD icon.Navigate to the File menu--select Eject iPOD On a Windows OpSys device-- On the Start menu, click Computer (e.g. Windows 7).Right-click on the drive/device letter or iPOD icon (read: the icon doesn't always appear)Select Eject.The ......

Posted On Tuesday, October 8, 2013 7:58 PM | Comments (0) | Filed Under [ Practical Answers ]

How do I save frequently used SQL Statements in SQL Server?
One convenient way is to make use of the template feature (aka: Template Explorere) in SSMS.

1. Navigate to the View menu in SSMS
2. Select Template Explorer->right click on SQL Server Tempaltes.
3. Click New and create folder; use to add/edit templates.


Posted On Monday, October 7, 2013 12:27 PM | Comments (0) | Filed Under [ Practical Answers ]

How do I switch montor postions? Switching cables didn't help.
For Windows 7:1. Right click any blank area on your desktop. 2. Left click Personalize->Display Settings. A window will open that shows a monitor. 3. Navigate to Change Display Settings. A new window will appear showing 2 monitors. 4. Click Identify Monitors. When the monitor you are on is the main monitor, you will see "This is currently your main display" under Multiple displays. To change this, click on the other monitor and check the box that says "Make this my main display". Click Apply. ......

Posted On Monday, October 7, 2013 9:54 AM | Comments (0) | Filed Under [ Practical Answers ]

Which DMVs are most helpful? Is there a list of them?
As with most questions asked about monitoring/assessing/admini... MS SQL Server installations, the answer is "it depends".There are many other blogs/resources/etc. online that can get into the specifics--think of this mini-blog as a snake-bit kit! :) Overall, to get to a list of objects that fall under the DMV (Dynamic Management Views) category, type this:-- This will show you the views and the functions of all dmv objectsSELECT name, type, type_descFROM sys.system_objects WHERE name LIKE 'dm_%'-- ......

Posted On Friday, September 27, 2013 7:23 PM | Comments (0) | Filed Under [ Practical Answers ]

How can I tell when a stored proc (or function) in sql server was last modified?
You're really looking of the modify_date in the sys.objects table where the type is either a stored proc or a function. This works on a database by database level -- to elevate this search to the server level, you'll have to use the loop sproc sp_msforeachdb SELECT name, create_date, modify_date FROM sys.objectsWHERE type = 'P' -- change 'P' to 'FN' if you're looking for a function and modify_date between cast('2013-09-10' as date) and cast('2013-09-20' as date) ......

Posted On Friday, September 20, 2013 5:22 PM | Comments (0) | Filed Under [ Practical Answers ]

How do I change the value of a column in a CASE statement and eliminate NULLs?
In t-sql/mssql, if you have a known NULL value you can issue a statement like:SELECT ISNULL(BirthDate,'1/1/1970 12:00:00 AM') as BirthDateFROM DrviersThe ISNULL function is replacing any nulls found in the BirthDate column to a default value of 1/1/1970.In other situations, you may not have just NULL values, but other possibilities as well. SELECT ISNULL(BirthDate,'1/1/1970 12:00:00 AM') as BirthDate, CASE WHEN BusinessPhone IS NULL OR BusinessPhone = '' THEN 'Unknown' ELSE BusinessPhone END as BusinessPhoneFROM ......

Posted On Thursday, September 19, 2013 9:57 AM | Comments (0) | Filed Under [ Practical Answers ]

I get the error "Can't connect to SSISServer" . How do I fix this?
If you're seeing this error, or a similar access denied error you'll need to have your windows account given DCOM permissions. DBAs generally have the ability to add you.If you're a DBA and want to add a developer to be able to connect to the SSIS services to deploy packages here's a quick punch list:Logon to the target SQL Server. Go to Start->Run type lusrmgr.mscIn the Local Users and Groups dialog box, click Groups->Ditributed COM usersOnce in the Distributed COM users properties dialog ......

Posted On Wednesday, September 18, 2013 8:55 AM | Comments (0) | Filed Under [ Practical Answers ]

SQL Server Management Studio: Why do I get "Saving changes is not permitted" ?
This happens when you're in the SSMS gui making changes to the table that either affect the behavior of an index, cause existing data to be truncated/nulled, etc. This can also happen you try to change the order of columns, or change datatypes. If your credentials allow it, you can get past this message in order to truly shoot yourself in the foot! :)Navigate to Tools --> OptionsExpand DesingersClick on Table and Database DesignersCheck the box Prevent Saving changes that require table to be re-created ......

Posted On Wednesday, August 28, 2013 3:00 PM | Comments (0) | Filed Under [ Practical Answers ]

Why can't I connect to SSIS through management studio?
The microsoft integration service is secure by default. The DBA has to grant access to the service in order for it to connect successfully through ssms. To grant access to the Integration Services service Run Dcomcnfg.exe. Dcomcnfg.exe provides a user interface for modifying certain settings in the registry. In the Component Services dialog, expand the Component Services > Computers > My Computer > DCOM Config node. Right-click Microsoft SQL Server Integration Services 11.0, and then click ......

Posted On Monday, August 26, 2013 10:44 AM | Comments (1) | Filed Under [ Practical Answers ]

How do I Install IBM Data Studio 4.1 ?
The download for this workbench is large--somewhere around 1.2 gb. Finding the install exe for linux or windows isn't clear. Basically this download appears to be from a 2 disk distributable set of *.ISO files. Ignore all the distraction scripts in the core directory. Delve into \ibm_ds410_lin64 (I downloaded the 64 bit version) . Look for a directory called Disk1. There you will find the installer images for Windows and Linux.Here's a visual image of what the directory will look like ......

Posted On Tuesday, August 20, 2013 12:04 PM | Comments (1) | Filed Under [ Practical Answers ]

SSIS: My Toolbox is Missing!
I work with BizTalk (BTS) and SSIS frequently. In one of my environments, whenever I've programmed in BTS, then jump back to SSIS, the SSIS toolbox is missing in action. Here's what I do to solve the problem in that environment:Save the application and close Visual Studio.Go your AppData\Local\Microsoft\Vis... version]Rename the *.tdb files there to something else like *.tdb.xOpen Visual Studio (Note: You will see the progress status bar re-initializing all available toolboxes.)Open ......

Posted On Thursday, July 11, 2013 4:19 PM | Comments (2) | Filed Under [ Practical Answers ]

How do I know what Version of BizTalk is on my server?
There are 2 ways to do this, the first is to query the BizTalkDBVersion table:use [BizTalkMgmtDb]goSELECT DatabaseMajor, DatabaseMinor,ProductBuildN... ProductRevision FROM dbo.BizTalkDBVersion; Here is a list of possible BizTalk versions (CUP = cumulative update package, SP = service pack) :BTS20043.0.4902.0BTS2004SP... 3.0.7405.0BTS2006 3.5.1602.0BTS2006R23.6.1404... 3.9.469.0BTS2010CUP13.9.522... ......

Posted On Tuesday, July 2, 2013 5:59 PM | Comments (0) | Filed Under [ Practical Answers ]

SQL Server: I need to get to a remote server and management studio is broken. How can I login without ssms?
Try using osql . It can be a life saver. Here's an example of the most common usage:osql -E -S myMSSQLServerName /* This uses windows authentication to connect to a server */osql -? /* lists all the switches available to use with osql */Once you see the SQL prompt (1> ) , you can interact with the server.1> USE myDatabaseName2> GO3> SELECT col1, col24> FROM myTable5> GO6> 7> EXIT Here's a link or two to get you started. http://msdn.microsoft.com/e... ......

Posted On Wednesday, March 20, 2013 8:06 PM | Comments (0) | Filed Under [ Practical Answers ]

SQL Server: Is there a query I can use that generates similar output to Activity Monitor?
Yes! This query will return very similar information to what activity monitor returns--including the text of the query the process is running (when applicable). -- Query version of Activity Monitor SELECT SessionId = s.session_id, UserProcess = CONVERT(CHAR(1), s.is_user_process), LoginInfo = s.login_name, DbInstance = ISNULL(db_name(r.database_id), N''), TaskState = ISNULL(t.task_state, N''), Command = ISNULL(r.command, N''), App = ISNULL(s.program_name, N''), WaitTime_ms = ISNULL(w.wait_duration_ms, ......

Posted On Wednesday, March 20, 2013 7:13 PM | Comments (1) | Filed Under [ Practical Answers ]

SQL Server Agent:: I Can't Edit a Job Step because of the error "Creating an instance of the COM component with CLSID from the IClassFactory failed"
The immediate workaround to this problem is to open up a new SSMS session, then navigate to the SQL Agent Job you want to edit. At that point, you will be able to make the edit and save the changes.For more information on why this error occurs and the possible release(s) fixes, check out this url:http://connect.microsof... ......

Posted On Monday, March 18, 2013 7:05 PM | Comments (0) | Filed Under [ Practical Answers ]

SSIS: I get the error The column data for column "Column x" overflowed the disk I/O buffer
If you are reading a flat file, you are missing a delimiter somewhere and SSIS is trying to parse for the next value--so it thows an i/o buffer error. Look in the file for the missing delimiter. If the file is too big for that, try chopping up the file up into smaller versions until you find the line with the missing delimiter.

Posted On Friday, March 15, 2013 5:34 PM | Comments (2) | Filed Under [ Practical Answers ]

Eclipse Project:: How do I add an external *.jar file to my project?
1. Navigate to the project. Right-click, go to the Properties menu.
2. Go to the Java Build Path. Choose Libraries. Click the Add External JARs button.
3. Select the jar file/library to add.

NOTE: For projects you own, that you would like to add, use the Add JARs button instead.

Posted On Thursday, March 14, 2013 9:15 PM | Comments (0) | Filed Under [ Practical Answers ]

Visio 2010: How do I change the Title when in Borders & Titles?

To edit the text in a title or border in Visio 2010:

1. Look at the bottom of the document, click on the tab for background page  (usually called: VBackground-1)

2. Navigate the shape that has the text you want to change; type in the new text.

Posted On Thursday, March 14, 2013 9:15 AM | Comments (0) | Filed Under [ Practical Answers ]

Visio 2010: How do I change the relationship arrows in the database diagram?

For a quick changeover, go to:

Home -> Database -> Display Options ->Relationship

Select the relationship, then Database Properties -> Miscellaneous.

Posted On Thursday, March 14, 2013 9:09 AM | Comments (0) | Filed Under [ Practical Answers ]

How do I fix the error: CS1548: Cryptographic failure while signing assembly ?
The full error in Microsoft Visual Studio on a compile looks like this: error CS1548: Cryptographic failure while signing assembly 'C:\Program Files\Microsoft SQL Server\100\Samples\Analysis Services\Programmability\AM... This is likely due to a missing strong key pair value file. The easiest way to solve this problem is to create a new one. Navigate to: Microsoft Visual Studio 2010>Visual Studio Tools>Visual Studio x64 Win64 ......

Posted On Friday, November 11, 2011 10:36 AM | Comments (0) | Filed Under [ Practical Answers ]

How do I run (execute) a .bin file in Linux (Ubuntu) ?
If you are on a desktop version of Ubuntu, you can right-click on the file icon, click the permissions tab and click on "allow execution". If you are on a server copy without the desktop bells and whistles (or you would rather work with a command line in a terminal window), then do the following: sudo chmod +x myProgram.bin after you enter your password and get the prompt back type: ./myProgram.bin ......

Posted On Thursday, November 10, 2011 8:31 PM | Comments (0) | Filed Under [ Practical Answers ]

How do I remove a named instance of sql server 2008 on the same mssql server?
Normal 0 false false false EN-US X-NONE X-NONE /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin-top:0in; mso-para-margin-right:0in; mso-para-margin-bottom:10.0pt; mso-para-margin-left:0in; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans... mso-ascii-font-family:Calibri; ......

Posted On Thursday, November 3, 2011 2:28 AM | Comments (3) | Filed Under [ Practical Answers ]

How do I create and access another sql server db using linked server in SQL Server?
For a full explanation and step-by-step guide to setup a linked server through Sql Management Studio (SMS), check out this reference: http://www.databasejournal.... Here it is in a nutshell: If you are setting up a linked server for another sql server 2005/2008 box, just remember to (1) name the Linked server the same name as its network name, (2) select and provide under the security option ,"Be made ......

Posted On Monday, October 31, 2011 2:42 PM | Comments (0) | Filed Under [ Practical Answers ]

How do I get a listing of all DB instances and table names where a column name occurs in MS SQL Server?
I've been there! You are at a client site and you know you need certain data elements but aren't certain how many databases on a given server ...or ... which tables the data elements you are interested in might appear. Here's a single statement when executed from any SMS query connection that will get you there: EXEC sp_msforeachdb ' DECLARE @pattern nvarchar(100) SET @pattern = ''%elementName%'' IF EXISTS(SELECT 1 FROM [?].information_schema.columns WHERE column_name LIKE @pattern) BEGIN SELECT ......

Posted On Wednesday, October 26, 2011 3:46 PM | Comments (1) | Filed Under [ Practical Answers ]

How do I get access to DB2 from my .NET applications?
You have at least 2 choices: Source 1: SQL Server 2008 Feature Pack http://www.microsoft.com/do... ... this includes Microsoft OLEDB Provider for DB2 Source 2: Available from IBM, is the IBM I Access pack http://www-03.ibm.com/syste... Remember, whichever one you use, you will need to specifiy which libraries under the detail/advance settings in ODBC ......

Posted On Tuesday, September 13, 2011 2:08 PM | Comments (2) | Filed Under [ Practical Answers ]

Why Won't the Relationship Lines in Visio 2010 Connect to Anything?
That is a very good question..to which only Microsoft has the answer!:-) In the meantime, suffice it to say that every once in awhile, Visio loses track of your Glue/SnapTo settings which you'll need to restore. Here's what to do: 1. In Visio, navigate to "Home", open "View", expand "Visual Aids"2. Once in "Visual Aids", Check or Re-Check the "Glue"box. 3. Under the "Snap To" category, be sure shape intersections, shape handles, shape vertices, and connection points are all checked. 4. Under the ......

Posted On Tuesday, September 13, 2011 1:14 PM | Comments (1) | Filed Under [ Practical Answers ]

SQL Server: UPDATE Statement Basics
The last thing anyone wants to do is mess up an UPDATE statement! Here's a quick refresher for those of you using SQL Server: Simplest case (a single row, in a single table with a single known value in a column): UPDATE YourTableName SET Column1 = ‘NewValue’ WHERE SameOrOtherColumn = ‘OldValue’ Most common case (multiple rows, using another table as the source data with multiple columns): UPDATE YourTableName SET ColumnX = OtherTable.Column1, ColumnY = OtherTable.Column2 FROM OtherTable WHERE YourTableName.Column1 ......

Posted On Monday, August 29, 2011 3:30 PM | Comments (1) | Filed Under [ Practical Answers ]

SQL Server: How Can I search for a specific text value in all the stored procedures?
To quickly look through your stored procedure objects for a text value in a database instance, do the following: use [Metro] go SELECT ROUTINE_NAME FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_DEFINITION LIKE '%whatyouarelookingfor%' AND ROUTINE_TYPE = 'PROCEDURE' Now, this is no replacement for a configuration management repository, but it will do in a pinch. BTW, remember this sql statement does NOT transcend all databases on the server, just a single db instance ......

Posted On Monday, August 29, 2011 3:01 PM | Comments (1) | Filed Under [ Practical Answers ]

What happened to my Entity Framework (edmx) File?
If you're like me, you've probably clicked/clacked, docked/undocked the window with the edmx file while you were working on it in visual studio without intending to--and now, the entity diagram is gone and you are unable to open the file again from the solution window! Luckily, the edmx file is just another visually displayed xml file. From the solution window, right click on the edmx file -- select "Open with..." -- choose Xml . Once you see the xml for the edmx file close it. Go back to the solution ......

Posted On Tuesday, June 14, 2011 6:33 PM | Comments (0) | Filed Under [ Practical Answers ]

Why do I get the error: Specified Named Connection is either not found in the configuration for the EntityClient Provider?
The chances are pretty high that you are creating a multi-tiered application with a solution that may be calling several different projects, one of which is the ADO.NET Entity Framework DAO-layer. In order for the entity frame work to work outside the immediate project that its been created under, you'll have to import the connection string built by the EF wizard at create time to your other project's application or web config file. Here's an example. I have two projects under a single solution, ......

Posted On Tuesday, June 14, 2011 4:22 PM | Comments (0) | Filed Under [ Practical Answers ]

System.Data.OracleClient is missing or has been depricated. How do I fix this?
Yes, Microsoft is getting quite a reputation for abandoning or deprecating it's data access products/libraries. One thing you can do is download a 3rd party product called dotConnect by DevArt. The express edition is free. http://www.devart.com/dotco... ... however, if you are working in a shop that doesn't like its development team to use not well known third party tools, there's an alternative--but it still requires that you go to a non-microsoft source. Use Oracle.DataAccess.dll ......

Posted On Tuesday, June 7, 2011 5:26 PM | Comments (0) | Filed Under [ Practical Answers ]

Why is Vista so Slow when Browsing (Surfing) the Web?
Vista has an auto tuning feature which is hit and miss, depending on what network appliances/cards/devices you've got hooked up. Try this: 1. Navigate to Start>Programs>Access... Command 2. Type: netsh interface tcp show global 3. Look the line for receive window auto tuning. If it says highlyrestricted type this command (all on one line): netsh interface tcp set global autotuning=restricted 4. Try browsing, if it isn't any better, enter the same command like, just change restricted ......

Posted On Saturday, June 4, 2011 12:44 AM | Comments (0) | Filed Under [ Practical Answers ]

How Do I Change a Database Instance Name in SQL Server?
Ten minutes ago I created a scratch db instance with a name I mistyped. Not good! Fortunately, I have admin privileges so I can change it in my lab environment. If you're an admin AND no other users are accessing the DB instance, here's what you can do: USE master go EXEC sp_renamedb 'MetroWrongName', 'MetroRightName' GO If someone is using the instance, there is a workaround. Do this: USE master go -- flag the instance for single user only EXEC sp_dboption 'MetroWrongName','Single User', True GO ......

Posted On Friday, May 27, 2011 4:38 PM | Comments (1) | Filed Under [ Practical Answers ]

How do I Disable FireFox's Browser Cache COMPLETELY?
The worst part about web application development is the phase in the unit testing where we developers swear we've fixed something, but still when we test the change, the fix isn't there. After awhile, we remember to clear the browser cache and we discover the fix worked! In some cases, we really haven't fixed what we thought we fixed--and in other cases, we haven't really cleared the cache. I was working in FireFox recently and realized I hadn't really cleared the cache when I added a new button ......

Posted On Thursday, May 19, 2011 1:43 PM | Comments (2) | Filed Under [ Practical Answers ]

How do I read the SQL for a View in T-SQL?
The easiest way in MS SQL 2005 and up is to use the SQL Management Studio, go to Views, highlight the name of the view you are interested in, right click, select Script View as/Create to/Clipboard. open up notepad or your prefered editor and paste the contents of your clipboard. The SQL used to create the view should show up in your editor. If this doesn't work, or if you are working with older versions of SQL Server, look at the system objects as follows: use [YouDatabseInstanceName] go select * ......

Posted On Wednesday, May 4, 2011 12:41 PM | Comments (1) | Filed Under [ Practical Answers ]

How do I Delete a View? How do I Create a View?
Before I create views, I generally work out what I want to retrieve in my SELECT statement ahead of time so I'll just have to cut and paste the query. The example below is done in T-SQL/Sybase format, however for Oracle and MySQL, just place a semi-colon ';' at the end of your statement and remove the 'GO' command. To drop (delete) an existing view: DROP VIEW vw_rpt_metroBestCustomers GO To create a view: CREATE VIEW vw_rpt_metroBestCustomers ( CustomerName, OfficeNum, City, StateOrProv, Country, ......

Posted On Tuesday, February 22, 2011 5:01 PM | Comments (0) | Filed Under [ Practical Answers ]

How do I route my SMTP outgoing mail through gmail (Google Mail) ?
Here is the quick answer: Go into your client e software (e.g. Outlook, Thunderbird, etc.) for the account you are working on (usually default). Set the SMTP server to smtp.gmail.com Set the username as your gmail account user name (e.g. myname@gmail.com). Gmail will need the username and password you use for that account, so if your default is set to some other email, be sure to set the username and password to that value, or click on the checkbox for username/password. Check TLS as the secure connection. ......

Posted On Saturday, February 19, 2011 1:57 AM | Comments (1) | Filed Under [ Practical Answers ]

In SQL Server, How Do I List all the Constraints by Table or by Column Name?
This one will order the contraints by table: Select SysObjects.[Name] As [Contraint Name] ,Tab.[Name] as [Table Name],Col.[Name] As [Column Name] From SysObjects Inner Join (Select [Name],[ID] From SysObjects Where XType = 'U') As Tab On Tab.[ID] = Sysobjects.[Parent_Obj] Inner Join sysconstraints On sysconstraints.Constid = Sysobjects.[ID] Inner Join SysColumns Col On Col.[ColID] = sysconstraints.[ColID] And Col.[ID] = Tab.[ID] order by Tab.[Name] This one will order the contraints by column: Select ......

Posted On Friday, November 5, 2010 11:36 AM | Comments (1) | Filed Under [ Practical Answers ]

How do I know what version of IIS I am running?
I've encountered a LOT of posts on this--some of them represent a LOT of unnecessary work. Here's the simple way: 1. Navigate to Administrative Tools. 2. Go to Internet Information Services (IIS) 3. If you last looked at something, Navigate to ABOVE your server name -- where it says "Internet Information Services" 4. Look to the right. You should see something that looks like this: computer local version -------------------------- ------- ------------- YourComputerName yes IIS V6.0 You're DONE ......

Posted On Sunday, October 17, 2010 6:04 PM | Comments (0) | Filed Under [ Practical Answers ]

How do I Debug my SQL Server Stored Procedures?
If you don't have the Visual Studio IDE to work with, you can go the old fashioned route with issuing PRINT statements. If you do have the Visual Studio IDE available, execute the following steps: open visual studio navigate to server explorer create/open a connection to your database right click on the stored proc you want to work with and choose "Step into stored procedure" For more details, or for a more visual example with the instructions, navigate to this url: http://www.dotnetfunda.com/... ......

Posted On Wednesday, September 8, 2010 7:16 PM | Comments (0) | Filed Under [ Practical Answers ]

Full Practical Answers Archive

Powered by: