So, I've found the source of all the data I need in my database, but it is in a JSON file. MSSQL cannot read JSON and the entire internet seems devoted to telling me how brilliant and easy JSON is and then giving me 20 pages of code to deal with it. I don't have time to implement a JSON parse in C or anything like that. I just need to put this perfectly simple bit of data into a database. Can you help? [more inside]
Ok, I have an application that is using a back end of MS Access...I have another application that needs to get some of the data in the Access db but it is only SQL compatible. So...how do I set up an ODBC connection that will pull data from the Access db and write it out to a SQL db? This data needs to be updated hourly... Thanks for your assistance!
SQL - How to get an accurate count of the rows potentially affected by an UPDATE statement, or best practices for performing updates? [more inside]
MS SQL Pros, I need your help! What's causing MS SQL 2005 to import records so slowly? It's a persistent problem across all databases that just developed yesterday. Details inside... [more inside]
Currently Microsoft-only, but wanting to change our software soon to support Oracle as well. What are we getting ourselves into? [more inside]
I have been asked to make a proposal to upsize an Access database to allow for a few more concurrent users (currently 10) and ideally improve the overall performance of the system. Am I getting in over my head? [more inside]
I need to import a database into MS SQL but I do not want to end up with a transaction log as large as the database. What's the best way to do the import? [more inside]
After working in a mostly LAMP (Linux, Apache, MySQL, PHP) environment the last few years, I need to make a quick switch to WISA (Windows, IIS, MS SQL, ASP). [more inside]
Help me understand MSSQL logs... At least enough to do what I need to do. [more inside]
How can I connect to a SQL Server 2005 database using windows authentication with PHP? [more inside]
How do you use a single authentication system for different kind of servers, systems, and workstations? [more inside]
I have a set of dates/times in a MS SQL table that lack a timezone offset. I want to convert them to UTC, but I have to be mindful of Daylight Time for each of these dates (they're in the future). How can I convert them to UTC correctly? [more inside]
I have Visual Studio 2005 Professional. I installed VS2k5Pro with all of the options except the sample databases on my WinXP box, but now I can't figure out how to access the Enterprise Manager - replacement ... Enterprise Management Studio, or even find out if that app is included with the version I have. Any suggestions?
Is there a way of mapping a Virtual Drive letter or a share to an MSSQL database? [more inside]
Looking for a dedicated server hosting provider [more inside]
Attention SQL gurus. This has me completely stumped. How can I find the index (position) of a row in a table without querying the entire set? [more inside]