DBxtra Discount
We periodically negotiate a discount withe vendors for the SQLServerCentral.com readers. We've gotten another one from DBxtra for a Professional license if you're interested in this reporting tool.
2005-04-28
2,788 reads
Product News
BDS SQL Digger 2 Released
Have you ever needed to find something in a stored procedure or function and found yourself trying to wade through syscomments? Ever want to know which views reference a table, but you don't trust sysdepends? BDS has released SQL Digger 2.0, a utility designed to help you search through your schema and code to find what you need.
2005-04-18
4,139 reads
Maintained by man and dog
As the online news service called NewsScape moves into its sixth year, it exhibits a lot of the characteristics of a child at the same age: It has a huge appetite for information, grows by leaps and bounds each year, and makes those who oversee it wonder if they can maintain control as it gets bigger. It is maintained by "a man and a dog – an aging golden retriever named Sambucus," according to the man, Andrew Clarke.
2005-04-15
1,744 reads
BDS SQL Digger 2.0 Released
Have you ever needed to find something in a stored procedure or function and found yourself trying to wade through syscomments? Ever want to know which views reference a table, but you don't trust sysdepends? BDS has released SQL Digger 2.0, a utility designed to help you search through your schema and code to find what you need.
2005-04-05
3,738 reads
Tableau Software Debuts
With it's VizQL, Tableau Software is revolutionizing the way that you will analyze data. Built to work with multiple data sources, including SQL Server databases and Analysis Services cubes, this software will amaze you.
2005-04-04
3,523 reads
Beta Call - Randolph for Database Schema Control
Maintaining control of your schema with SQL Server 2000 can be cumbersome. However there are starting to be more and more tools to assist you with version control and tracking your schema over time. Nob Hill software has a tool that helps, which is currently in Beta and code named "Randolph". If you have a need, check out their new product.
2005-03-30
2,638 reads
A DBXtra Discount!
SQLServerCentral.com tries to provide you a great deal of value for your subscription fees. We think we do a good job considering the $0 cost 🙂 One of the benefits we sometimes negotiate is a discount on products. DBXtra has generously offered a discount for the next few months, so read on and make your purchase today!
2005-03-11
2,880 reads
Text Export
I need to add dbl quotes around the beggining and end of the data in a text data-type column. There are lot of string functions to do this, but the data in the text exceeds the max capcity when I convert, therfore truncating some of the data. Any suggestions? -JG
2002-03-25
SQL 7.0 v. Oracle 9
i have an application which accesses data from SQL 7.0 through OLE DB. Are there any suggestions, guidelines for migrating to Oracle? SQL DBs are Schemas or DBs in Oracle?
2002-03-22
3 reads
using foreign key constraints
I would like to use foreign key constraints to ensure referential integrity in my SQLServer database, but I don't see how I can easily generate a user-friendly error message in my front-end application when an ADO error occurs due to violating one of the foreign key constraints. Any suggestions greatly appreciated.
2002-03-20
1 reads
Blogs
Simple Talks Episode 7
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
A New Word: the McFly effect
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
Key mappings in Visual Studio Code
At a recent conference I was asked how I executed code during my presentation....
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers