|
|
|
|
|
Total Hits: 2641 | 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....
|
|
|
|
Total Hits: 693 | 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: 350 | 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: 624 | 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....
|
SQLPane
|
Version:
1.0
|
Price: $19.99 / Free Trial
|
|
|
Total Hits: 653 | 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: 519 | 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....
|
|
QuB
|
Version:
1.0.0
|
Price: $99.00
|
|
|
Total Hits: 340 | Today: 0
|
Author: InterAKT Online
|
Rating:
|
|
The solution for automating SQL query generation, easying database applications development for building website administration tools For a dynamic web application developer, who needs to put database content on the web and is not an SQL expert, QuB is the tool that allows table relation management, automating SQL query generation. Unlike other tools, QuB manages tables, relations and conditions for your queries visually....
|
|
|
|
Total Hits: 102 | 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: 920 | Today: 0
|
Author: Randy Dyess
|
Rating:
|
|
As you work with SQL Server you have probably heard of the terms data cache and procedure cache and may have wondered what exactly a cache was. SQL Server is configure to use a pool of memory of the server and it will allocate the majority of this memory pool to hold both data pages that have been read and the compiled execution plans for all Transact-SQL statements. It is this dynamic pool of memory that is being referred to and the data cache and procedure cache, keep in mind that in versions ...
|
|
|
|
Total Hits: 148 | Today: 0
|
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: 189 | Today: 0
|
Author: Jay Dave
|
Rating:
|
|
I have heard about Microsoft Data Protection Manager V2 as a portion of the System Center Data Protection Manager that Microsoft is supposed to be releasing shortly. I have heard this technology is backup or CDP related. What exactly is this technology? What does it mean to me as SQL Server DBA, Network Administrator or Backup Administrator? What benefits can I expect to yield from this technology?...
|
|
|
|
Total Hits: 194 | Today: 0
|
Author: Edgewood Solutions Engineers
|
Rating:
|
|
Finding out information about database settings is not that hard when you use Enterprise Manager or Management Studio, T-SQL commands such as sp_helpdb or query the system tables directly. But the way the information is returned may not always be the most useful. When using the GUI tools you can't easily grab just the information that you need and you can only look at one database at a time. With the T-SQL commands such as sp_helpdb the database options are all strung together and not listed ...
|
|
|
|
Total Hits: 177 | Today: 0
|
Author: Edgewood Solutions Engineers
|
Rating:
|
|
In a previous tip we discussed 10 items that should be addressed to manage your SQL Server environment. These items included; backups, security, disaster recovery, etc... The second item on the list was to check database and table integrity. This is pretty much a simple task to perform and there is not much if any interaction that needs to take place between the DBA and SQL Server. Although this is pretty straightforward to setup and run, this is not always implemented and secondly the output...
|
|
|
|
Total Hits: 202 | Today: 0
|
Author: Edgewood Solutions Engineers
|
Rating:
|
|
In a previous tip we discussed 10 items that should be addressed to manage your SQL Server environment. These items included; backups, security, disaster recovery, etc... The third item on the list was to maintain indexes. There have been several tips on the MSSQLTips.com website about index maintenance, but we will take a look at a checklist of things to perform to ensure your indexes are not degrading performance on your system....
|
|
|
|
Total Hits: 179 | Today: 0
|
Author: Edgewood Solutions Engineers
|
Rating:
|
|
When bulk loading data into SQL Server, in most cases you want to have this process run as fast as possible. Depending on the options you select and how indexes are setup on the table, the time to load the data could differ quite drastically. In this tip we will take a look at different options for bulk loading along with examples and the time it takes for each of these operations to complete....
|
|
|
|
Total Hits: 198 | Today: 0
|
Author: Edgewood Solutions Engineers
|
Rating:
|
|
For both old and new DBAs there are fundamental procedures that should be addressed and proper processes put in place to handle various areas of database management for SQL Server. Whether you are a full time DBA or this is one of many job roles that you perform the same basic steps should be implemented and adhered to in order to have some peace of mind that you are performing the correct procedures to ensure a healthy running SQL Server environment. For old DBAs these items should be a no-br...
|
|
|
|
Total Hits: 92 | Today: 0
|
Author: Edgewood Solutions Engineers
|
Rating:
|
|
Do you feel like all of your projects are going in circles with little progress being made on a weekly basis? Do these projects prevent you from working on the latest and greatest technologies? If so, consider taking the first step in trying to move forward with your projects in a more straight forward manner....
|
|
|
|
Total Hits: 178 | Today: 0
|
Author: Edgewood Solutions Engineers
|
Rating:
|
|
At a recent Northern Virginia SQL Server user group meeting, a debate was held about the Microsoft Certified Database Administrator\Microsoft Certified Information Technology Professional : Database Administrator being a 'must-have' for all SQL Server DBAs. As such, let's explore some key questions. Is it worth studying for the MCDBA\MCITP:DBA exams or not? Is this time well spent? How time consuming will the studying be to pass the tests? Is the MCDBA\MCITP:DBA just about studying for and ...
|
|
|
|
Total Hits: 85 | Today: 0
|
Author: Edgewood Solutions Engineers
|
Rating:
|
|
Among many other things, the Internet is a great resource and has revolutionized many things including troubleshooting SQL Server issues. Based on my observations, more often than not, when a SQL Server issue occurs DBAs, Developers or Network Administrators will ask their team if they have seen the issue they are experiencing and for the resolution. Depending on the answer, the next resource that is tapped is their favorite search engine i.e. Google. After a few different keyword searches, ...
|
|
|
|
Total Hits: 193 | 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....
|
|
|
|
|
|
