SQL
There are 17 entries for the tag
SQL
Like most developers, I run SQL on my main work computer. I find that the RAM usage gets quite bloated at times, so I have a handy bat file that I run to restart the SQL service, giving me my RAM back. Here are the simple steps to achieving this: 1) Right click on your desktop and create a new text document. 2) Rename file to restartSQL.bat 3) Click yes on confirmation to change a file name extension. If you did not get this error, you will need uncheck "Hide extensions for known file types" on the ......
Chris (who I meet down at SC Code Camp 2006) left a comment on my C# connection string validation code pointing out some flaws in my code. He suggested playing with System.Data.SqlClient.SqlCo... I redid the code to take advantage of this helper class. Here is the updated version of the code. Note that I only validate Data Source, Initial Catalog, User ID and Password because that is the only thing our software uses right now.public static bool IsValidSQLConnectionString(... ......
Update - I made the code better here Here is a code snippet I use to validate SQL connection strings: /// <summary>/// Checks a connection string for validity/// </summary>/// <param name="cn">SQL Connection string to validate</param>/// <returns>True if connection is valid.</returns>/// <history>/// [Tim Hibbard] 12/03/2006 Created/// </history>public static bool IsValidSQLConnectionString(... cn){ bool RV = true; try { if (!cn.Contains("Data Source")) ......
When we decided that ParaPlan 4.0 would be rebuilt in .NET (from Access), we decided not to redesign the SQL database. Even though we have some inefficiencies in our db we want to decrease development time and allow our beta testers to be able to switch back and forth between our Access front end and our .NET front end. As development began, we decided that we needed an object for each table and that we could eliminate some of the database inefficiencies in our objects. So we have an Appointment ......
Update - Found a solution here I've had a problem ever since installing TFS, and I've not blogged about it yet because I wanted to figure out a good solution first. I haven't found the solution, so I'm hoping for some good advice from the brilliant GWB readers. We have quite a few dll's and controls that we reference from our applications. For example, we have our SQL Connection String control that lives in the EnGraph Controls team project. If I want to use the SQL Connection String control, I add ......
Update: 02/27/2007 added support for raw SQL Strings When I build data access layers, I like to define a const for each column in the query like this: const int CLIENTID = 0; const int STATUS = 1; const int FIRSTNAME = 2; That way, I can pull data like this: newClient.Name.FirstName = reader.GetString(FIRSTNAME); And if something changes in the database, I know I only have to change the field that FIRSTNAME references. However, sometimes, tables can be quite large and it becomes a pain in the wrist. ......
I didn't really like how I was storing some of our SQL connection information. It was buried deep in the file system in an XML file, but it was still plain text. So I spent my day looking at the different encryption options in the .net framework. I needed it to be two-way encryption so our objects could still work with it, so I decided on Rijndael. I found some great code, modified what I needed and wrapped it in one of our objects. It works pretty well. Now only if KU could have pulled it out... ......
It's official! EnGraph has begun development on the migration of our flagship product, ParaPlan to .NET. We have several little helper applications that are written in .NET, but our main core is still an Access front end hitting a SQL database. We are completely redesigning the user interface, business rules and database structure in the new ParaPlan, code named "Goldstar". We have been talking about and planning this for almost two years, it's very exciting to see it move to the next level. Kyle ......
I need to rebuild one of my machines soon, so I have compiled a list of applications that I can not forget to install: Snippet CompilerNUnitNDocDesktopSid... BanditCDexSource Gear VaultWWMXStimulsoft .NET ControlsActive PortsDVD ShrinkGoogle EarthMicrosoft Anti-SpywareLavasoft Ad-AwareRed Gate SQL ToolsMapPointVirtualPCLine CounterISObusterOutlook KnockoutNetMeterw:BloggarEvan Is A Bad Computer UserQuickTime KillerNetPing ......
DateBox: This control contains a textbox. When the user double click the textbox, a calandar control is displayed. The user can select the date, and the date will be displayed in the text box. The developer can get the date by calling the .TheDate property. Download Just dll SQL Connection String Builder: This control contains 4 textboxes and labels for Date Source, Initial Catalog, UserID and Password. The developer can pass in a valid SQL connection string and the individual elements will be parsed ......
We have released SQL Connection String Builder .NET Control. This control is designed for situations where you need your user to enter their own SQL connection info. It has 4 textboxes and labels for Data Source, Initial Catalog, User ID and Password. You can pass in a full connection string and it will parse out the elements and display them in the proper field or you can let the user populate the data and pull out a valid connection string using the .ConnectionString property. The connection string ......
We are working on an Office addin for Outlook that : 1) Displays new messages in a window allowing you to quickly reply to an email, or delete it 2) Forwards new mail to your mobile device. 3) Forwards new mail to a SQL Server (based on connection string, stored procedure name and parameters) 4) Control the behavior of EnGraph OutlookPlus from your cell phone via SMS It is still in development and we don't have any documentation for it yet, but if anybody wants to help test when it is a bit closer, ......
One of our applications is an Access front end linked to a SQL backend. We link the tables and then all the database calls go against an ADODB connection. This weekend, I was supposed to do a major upgrade for one of our clients. This upgrade was going to involve changing the database structure, so I had the DBA add drop and create table permissions to my SQL login. Once the login permissions were changed, our application stopped working. The first place a data call was made, we would get a "could ......
When migrating an access application to sql server, sql changes all your access date/time fields to sql date/time format. Well, with access you can store the data as any type of date format (short time, long date, etc). Sql stores it all in one format (ex: 05/28/1979 12:48:00). Thats fine, because usually you have control over the data before the end user ever sees it and you can make it look nice with a FormatDateTime or whatever. Well, I ran into a case today, where it was just better to bind a ......
I love to be connected. My laptop has wireless. My cell phone can get online. I can plug a cable from my phone to my laptop and use it as a modem when I am on the road. The problem has always been retrieving my email when I don't have my laptop. I can go online with my phone to mail2pda.com, but then I have to enter my username, password, pop3 server...etc. Major pain. So for a while I was using rules in Outlook to foward emails to my phone. That worked ok, but I could only get the first 160 charactors ......
Well, 500 miles worth of trips between Lawrence and Kansas City, I am mostly moved into my new apartment. I am a mile away from Kyle's place, so it cuts the commute by about 45 minutes :) Road runner won't have my cable hooked up until the 24th, so I am using my cell phone connected to my laptop to post this. I've been thinking alot about our migration from Access to .net. I am trying to decide if we should continue to support Access as a backend or we should make everybody use SQL/MSDE. I think ......
Well, after attending DevEssentials in Kansas City and listening to Jeff Julian speak on the importance of community and blogging your individual development efforts, I decided it would be a good idea to start blogging on my own. I have been moblogging for a while, but this is my first official text post. I live in Lawrence, KS and develop in .net, SQL, and VBA Access for a small virtual company. I have been programming ever since my Dad gave me a Mac Plus and ZBasic at the ripe age of 10. I also ......