28 posts tagged with sqlserver.
Displaying 1 through 28 of 28. Subscribe:

What's the safest way to get this data to the outside?

I have a database table with sensitive (read as personal, non-financial) information inside our office locked-down network that I need to expose to users on a website. What's the best way for me to expose this data without exposing us to unnecessary risk? [more inside]
posted by chillin411 on Aug 7, 2015 - 6 answers

Disk missing. Free query tool available?

Our crack IT staff has misplaced the MS Management Studio disk. Is there a free download that will get me by for a week or so? [more inside]
posted by SemiSalt on Jan 13, 2015 - 9 answers

SQL Server Package Configuration

How do I use a value from a Package Configuration in the Connection Manager? I am using an SQL Data Source, not an Environmental Variable. [more inside]
posted by soelo on Sep 16, 2014 - 3 answers

SSAS cubes on iPads?

What is the best way to enable people to access SSAS cubes on iOS? [more inside]
posted by pompomtom on Oct 15, 2013 - 5 answers

SELECT TOP 10 blogs FROM blagosphere WHERE type = 'SQL Server'

Best blogs for SQL Server? [more inside]
posted by bfranklin on Jul 1, 2011 - 5 answers

Increasing database performance for SELECTs

Databases: is it better to spend money on faster disk I/O or partitioned tables? Which has more influence on the speed of a SELECT query? [more inside]
posted by Ritchie on May 29, 2011 - 9 answers

SQL Alter statement

SQL SERVER: Need help creating new column in a table with unformatted SSN. [more inside]
posted by fozzie33 on Apr 6, 2011 - 6 answers

How to manually increment an integer value in a SQL Server 2005 database table?

How would you handle "manually" incrementing the value of this integer field in SQL Server 2005? [more inside]
posted by trunk muffins on Aug 3, 2010 - 7 answers

Delete records from every table with a certain column in SQL Server 2005?

SQL Server 2005: How do I create a script to delete specific rows from every table that has a certain column, deleting from the tables with foreign keys first? [more inside]
posted by DakotaPaul on May 26, 2010 - 11 answers

Seeking advice on an unsupported SQL Server upgrade

Can I switch the SQL Server inside a VMWare appliance to a license-fee-free edition without undue pain? [more inside]
posted by flabdablet on May 10, 2010 - 9 answers

Seems to say we're disconnected...

I am trying to revive a BCM2003 database from the mdf and ldf files. Crashed laptop had XP SP3 and Outlook+BCM 2003, new laptop has Win7 and Outlook+BCM 2007. The database does not connect. [more inside]
posted by gijsvs on Jan 11, 2010 - 3 answers

Finding rows that don't exist in an SQL Server 2005 table

I can't seem to build a query in SQL Server 2005 that returns rows that are not in a table. [more inside]
posted by DakotaPaul on Oct 7, 2009 - 17 answers

How does WITH work in MS SQL Server?

Can someone help me understand how the WITH common table expression works in Microsoft SQL Server? [more inside]
posted by DakotaPaul on Sep 11, 2009 - 9 answers

What is the best way to host an ASP.NET website?

What is the best way to host an ASP.NET website? [more inside]
posted by talkingmuffin on May 13, 2009 - 3 answers

Can SQL Server and IIS live happily ever after?

Hosting SQL Server and IIS on the same co-located server: Good idea, bad idea, or terrible idea? [more inside]
posted by JohnFredra on Mar 17, 2009 - 8 answers

Hello end user! Just FYI, the admin password to this database is: xyz

What might cause a SQLOLEDB connection string (containing an admin username/password) to briefly appear on-screen in a browser session and would I be crazy to buy a product that's had this bug for who knows how long without realizing it? [more inside]
posted by aydeejones on Feb 16, 2009 - 8 answers

Translating 's/ */ /g' into T-SQL?

Fixing whitespace: Can someone translate 's/ */ /g' into T-SQL? [more inside]
posted by pompomtom on Jul 30, 2008 - 2 answers

More SQL help, please

Another SQL question (*sigh*), but this time a bit more complicated. [more inside]
posted by omnipotentq on Jul 15, 2008 - 7 answers

Synchronize databases....3...2...1... NOW!

What's the best way to keep data one way synchronized between an internal Mircosoft SQL Server database and a web facing mySQL database? [more inside]
posted by advicepig on Apr 3, 2008 - 9 answers

How do I set up a SQL Server 2000 DSN connection when moving servers?

IANA IT professional, but I need to move our SQL Server database from one server to another server. I can't get the DSN connections to work now that we're on the new server; can you please hold my hand? [more inside]
posted by bcwinters on Mar 15, 2008 - 7 answers

Right Place, Wrong Time

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]
posted by dw on Nov 13, 2007 - 3 answers

I need to get part of a website onto a USB sick at will

I need to get part of a website onto a USB sick at will [more inside]
posted by Chuck Cheeze on Oct 24, 2007 - 7 answers

Where's Enterprise Manager?

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?
posted by SpecialK on Aug 1, 2007 - 3 answers

How to determine if a record has a certain value at any given time.

I need some SQL Server/database design help. I have a custom built admin for an ecommerce site where we manage our orders. During the life of an order, it can have many statuses ... [more inside]
posted by SoulOnIce on Aug 4, 2006 - 12 answers

isql and bcp

MS SQL Server Filter: I'm supporting a pretty old process that loads data into and out of SQL Server 6.5. The process uses isql and bcp from a SQL Server 2000 installation. Is there anywhere I can download these utilities for free, perhaps as part of a "SQL Server Client" tool? I have searched the M$ website...
posted by joecacti on Aug 4, 2006 - 4 answers

"There's no place like home...."

Need a tinker-free Linux/MySql install for Ruby On Rails. Also, seeking advice for getting started in RoR. [more inside]
posted by Afroblanco on Jun 27, 2006 - 19 answers

I don't want to be a country song.

Topping 400 and my dog is 14 1/2 years old... but it's not really about that. [more inside]
posted by auntbunny on Mar 26, 2006 - 2 answers

How can I export data from SQL Server 2000 to QuarkXPress using ColdFusion?

What's the best way to export data from a SQL Server 2000 database into QuarkXPress 4.11 using ColdFusion 5? [more inside] [more inside]
posted by kirkaracha on Feb 5, 2004 - 0 answers

Page: 1