|
|
|
|
|
|
| | Total Hits: 220 | Today: 0 | Author: Edgewood Solutions Engineers | Rating:  |
| | 
With the recent tip on the native SQL Server data modeling capabilities, questions arose about data modeling alternatives in the marketplace. The native tools are a very valuable free solution, but may lack advanced functionality needed in some circumstances. As such, this tip outlines the data modeling tools available for SQL Server which can be leveraged by DBAs and Developers to meet a variety of data modeling needs.... |
| | Total Hits: 181 | Today: 0 | Author: Edgewood Solutions Engineers | Rating: |
| |
When designing tables you may not always know what columns need to exist prior to when the table is created. Therefore over time table changes are made where you may add or drop columns. Based on this table modification you may want to have certain columns next to each other for easier management and grouping of like data in the table structure. It doesn't really matter to SQL Server where the column is located, but to us humans it sometimes makes a difference. Dropping a column is not a big ... |
| | Total Hits: 126 | Today: 1 | Author: Edgewood Solutions Engineers | Rating: |
| |
One of the nice things you can do with Enterprise Manager is script out all of your objects to a source file. You can then use these files to load your source control, make a backup of your database objects or use the scripts to load another database. The way this scripting is done is by using DMO (Distributed Management Objects). The scripting can be done with many different languages and it gives you control over doing repetitive tasks or making your own interface into SQL Server. There is a... |
| | Total Hits: 112 | Today: 0 | Author: Edgewood Solutions Engineers | Rating: |
| |
It has come to my attention that some of our MSDB databases are getting what I would consider large for a system database. Some of our MSDB databases are over 2 GB which is a little perplexing because I know we do not create any user defined objects in that database. Can you give me some insight into the issue? I know we have this issue with both SQL Server 2000 and 2005 instances. On a few different SQL Server instances, we have observed MSDB databases over 1 GB. In each of the circumstance... |
| | Total Hits: 276 | Today: 0 | Author: Edgewood Solutions Engineers | Rating:  |
| |
One task that most people are faced with at some point in time is the need to import data into SQL Server from an Excel spreadsheet. We have talked about different approaches to doing this in previous tips using OPENROWSET, OPENQUERY, Link Servers, etc... These options are great, but they may not necessarily give you as much control as you may need during the import process. Another approach to doing this is using SQL Server Integration Services (SSIS). With SSIS you can import different types... |
| | Total Hits: 182 | Today: 0 | Author: Edgewood Solutions Engineers | Rating: |
| |
Moving data into SQL Server is something that most DBAs or Developers are faced with probably on a daily basis. One simple way of doing this is by using the Import / Export wizard, but along with this option there are several other ways of loading data into SQL Server tables. Another common technique would be to use either DTS (SQL 2000) or SSIS (SQL 2005). In this tip we take a look at some of these other options for importing data into SQL Server.... |
| | Total Hits: 178 | Today: 0 | Author: Tim Ford | Rating: |
| |
There are times when I find myself needing to run a SQL command against each database on one of my SQL Server instances. There is a handy undocumented stored procedure that allows you to do this without needing to set up a cursor against your sysdatabases table in the master database: sp_MSforeachdb.... |
| | Total Hits: 135 | Today: 0 | Author: Kimberly L. Tripp, Neal Graves | Rating:  |
| |
Microsoft SQL Server 2005 provides nonlocking, nonblocking read consistency to your users through snapshot isolation and read committed isolation using row versioning. Find out when you can use these features to improve performance and reduce latency in your applications.... |
| | Total Hits: 181 | Today: 1 | Author: David Banister | Rating: |
| |
Although T-SQL is extremely powerful for most data processing, it provides little support for text analysis or manipulation. Attempting to perform any sophisticated text analysis using the built-in string functions results in massively large functions and stored procedures that are difficult to debug and maintain. Is there a better way?
In fact, regular expressions provide a much more efficient and elegant solution. It is easy to see how they would be helpful for comparing text to identif... |
| | Total Hits: 668 | Today: 0 | Author: EMS Software Development | Rating: |
| |
EMS SQL Manager for PostgreSQL is a powerful tool for PostgreSQL Database Server administration and development. PostgreSQL Manager works with any PostgreSQL versions up to 8.0 and supports all of the latest PostgreSQL features including tablespaces, argument names in functions, and so on. It offers plenty of powerful tools for experienced users such as Visual Database Designer, Visual Query Builder, and powerful BLOB editor to satisfy all their needs. PostgreSQL Manager has a new state-of-the-a... |
| | Total Hits: 658 | Today: 0 | Author: EMS Software Development | Rating:  |
| |
EMS SQL Manager for MySQL is a powerful tool for MySQL Database Server administration and development. MySQL Manager works with any MySQL versions from 3.23 to 5 and supports all of the latest MySQL features including views, stored procedures and functions, InnoDB foreign keys, user-definable functions, transaction-safe tables, new MySQL 5 Authentication Protocol, MySQL 4.x user privilege extensions, charsets and collations support for databases and tables. It offers plenty of powerful tools for... |
| | Total Hits: 748 | Today: 0 | Author: EMS Software Development | Rating: |
| |
EMS MS SQL Manager is a powerful graphical tool for Microsoft SQL Server administration and development. It makes creating and editing MS SQL Server database objects easy and fast, and allows you to run SQL scripts, manage users and their privileges, build SQL queries visually, extract, print and search metadata, export data to 15 available formats and import them from most popular formats, view and edit BLOB fields, and many more.... |
| | Total Hits: 660 | Today: 0 | Author: EMS Software Development | Rating: |
| |
EMS IB/FB Manager is a high-performance tool for administering InterBase and FireBird. Its Graphical User Interface allows you to create/edit all InterBase/Firebird database objects in a simple and direct way, design databases visually, run SQL scripts, manage users and privileges, visually build SQL queries, extract, print, and search metadata, create database structure reports in HTML format, export/import data, view/edit BLOBs and many more.... |
| | Total Hits: 2691 | Today: 0 | Author: Wes Grant | Rating: |
| |
An Open-Source, Web-Based Interface for SQL Server and MSDE. The USer Interface mimics Microsoft's Enterprise Manager.... |
SQLPane  | Version: 1.0 | Price: $19.99 / Free Trial |
| | Total Hits: 692 | Today: 0 | | Rating: |
| |
SQLPane is a webbased SQL utility, which gives interface to perform any SQL operation, namely INSERT, UPDATE, DELETE, SELECT etc.SQLPane shows the query results in a HTML table. SQLPane also shows database structure with describe table capability.SQLPane works onAccess Oracle and SQLServer databases. This component is very useful for the projects where developers need to access the database,andperform different operations. It's also useful for developers who wants to work remotely, because SQLPa... |
| | Total Hits: 731 | Today: 0 | Author: Danny Lesandrini | Rating: |
| |
Microsoft Access is a two-fold blessing for programmers. In addition to being a fantastic development platform, its wide popularity as an office productivity tool helps to sustain a market for end user data reporting utilities. Savvy developers know how to cash in on this opportunity by writing focused applications with a clear objective in mind. Does Visual Access XP meet this litmus test? Read on and see.... |
| | Total Hits: 614 | Today: 0 | | Rating: |
| |
Proc-Blaster is a Template Based Code Generation tool which supports a variety of programming languages including VB.NET and C#. Prewritten VB.NET and C# templates are also included in the installation.... |
| | Total Hits: 407 | Today: 0 | | Rating: |
| |
Auto-Inserts automatically and intelligently converts SQL Server data into Insert scripts. Auto-Inserts handles Identities and all SQL Server datatypes. It even intelligently orders the script processing to delete and re-insert every record in a database without violating referential integrity.... |
| | Total Hits: 677 | Today: 0 | | Rating: |
| |
1 Click DB Pro is designed for trusted database administrators to browse, search, and edit a wide variety of ODBC and OLEDB compliant data sources. Includes support to modify and create Fields, Indexes, Triggers, Stored Procedures, and Foreign Keys in Microsoft Access and SQL Server.... |
| | Total Hits: 646 | Today: 0 | | Rating: |
| |
SQLLog is a server-side, audit trail software package which tracks and logs changes to data in Microsoft SQL-Server 7/SQL-Server 2000 databases. It tracks who, what, when and from what application changes are made to corporate data. Whenever a record is inserted, updated, or deleted, SQLLog records it and stores the original and new values. SQLLog adds complete audit trail capability to any Microsoft SQL-Server 7/ SQL-Server 2000 database. It lets you concentrate on the data model and functional... |
|
|
|
|
|
|