Quantcast

SQL Articles

Microsoft CRM Customization: Integration with third party SQL Application/Database

Microsoft CRM – Client Relationship Management package from Microsoft Business Solutions was initially designed to be customizable with Microsoft Visual Studio.Net and one of its programming languages – C#.Net or VB.Net.

Microsoft Great Plains SQL Querying Trivia

This is beginner level SQL scripting article for DB Administrator, Programmer, IT Specialist.

Microsoft Navision Database: C/SIDE or MS SQL Server – Overview for IT Specialist

Microsoft Business Solutions promotes Navision (former Attain) on US market as excellent manufacturing applications (formerly it was promoting Great Plains).

Embarcadero Releases Embarcadero DBArtisan and DBArtisan Workbench 8.0

New Version of DBArtisan and DBArtisan Workbench Significantly Extends DBA Solutions for DB2, Oracle, SQL Server, and Sybase.

Microsoft CRM Development: SDK, C#, SQL, Exchange, Integration, Crystal Reports overview for programmer

Microsoft CRM is new player on the CRM software market.

Microsoft Navision DB Selection: C/SIDE or MS SQL Server – overview for IT Specialist

Microsoft Business Solutions Navision serves both European and American megamarkets.

Microsoft Great Plains – Typical Problems and Fixes Overview for IT Administrator

If you have Microsoft Great Plains and support it for your company then you need to know typical set of problems you have in Great Plains and their fixes to have Great Plains run smoothly in your company.

Upgrading Great Plains Dexterity Customization Switching to New Technologies: SQL, Crystal, eConnect

This article is for intermediate Great Plains Dexterity developer. It describes the directions to phase out Dexterity functionality and replace it with newer technologies.

Crystal Reports – Geterogeneus databases: SQL Server, Oracle, Unidata, Btrieve tips for developers

Crystal Reports is the most flexible tool on the market and it has market recognition.

Microsoft Great Plains Data Conversion Overview for Developer

Looks like Microsoft Great Plains becomes more and more popular, partly because of Microsoft muscles behind it. Now it is targeted to the whole spectrum of horizontal and vertical market clientele. Small companies use Small Business Manager (which is based on the same technology – Great Plains Dexterity dictionary and runtime), Great Plains Standard on MSDE is for small to midsize clients, and then Great Plains serves the rest of the market up to big corporations.

TenFold Announces SmartSQL Feature

TenFold Corporation today announced SmartSQL, an EnterpriseTenFold feature that automatically generates custom SQL for most popular RDBMS systems.

Microsoft Great Plains Integration with Legacy Systems Overview for Developers

Looks like Microsoft Great Plains becomes more and more popular, partly because of Microsoft muscles behind it. Now it is targeted to the whole spectrum of horizontal and vertical market clientele. Small companies use Small Business Manager (which is based on the same technology – Great Plains Dexterity dictionary and runtime), Great Plains Standard on MSDE is for small to midsize clients, and then Great Plains serves the rest of the market up to big corporations.

Microsoft Great Plains Upgrade things to consider and FAQ

If you have Microsoft Great Plains and support it for your company then you need to know some technical details about Great Plains version upgrade and what is going on behind the scenes, which options do you have in case of Dexterity, VBA, SQL customization, additional complexity comes with migration from ctree/Pervasive to MS SQL/MSDE.

Alert! Alert! Alert! Backup and Restore Baby!

At many organizations I doubt red lights flash with the sound of blaring sirens when backups fail in production environments, but I believe at every organization backups are one of the most critical IT functions. Of all backups, database backups, by most accounts, are considered the most critical. I know this is certainly true for me as a SQL Server DBA. I am sure at one point in all of our careers we were too busy to check all of our backups across all SQL Servers, with a million responsibilities on a daily basis. I know some of us were lucky and made it unscathed, while others were not so lucky with backup failures that caused extensive data loss and long downtimes. Now when IT Departments are forced to “do more with less,” it is time to put the necessary SQL Server Alerts in place for backup and restore operations in order to more easily monitor and streamline this critical process.

…And How Do You Expect Me to Audit SQL Server?

Is your organization faced with pending audits resulting in long and tedious meetings to try to achieve compliance? Have you been hearing a foreign set of acronyms around the water cooler like HIPAA, SOX, GLBA and SAS 70? Have these new sets of requirements been causing consternation for your DBAs, Developers and Management? Have you been trying to figure how you are going to write the code to capture the data needed for the continuous audits in between the remainder of the company projects?

SQL Server Parallel Execution Plans

Microsoft SQL Server introduced parallel query processing capability in version 7.0. The purpose of parallel query execution is to complete a query involving a large amount of data more quickly than possible with a single thread on computers with more than one processor.

Keep Your SQL Servers Synchronized with SQL Compare and SQL Data Compare
· 1

Managing multiple versions of the same database across different environments (i.e. Development, Test, Production, and Disaster Recovery site) is perhaps one of the most important and least favorable Database Administrative duties. Whether it’s synchronizing database objects or actual data, creating utilities to perform this obligatory task is somewhat of a dreaded chore. I mean, think of it, when was the last time you looked forward to creating one of these utility jobs? My point exactly!

How to Interact with SQL Server’s Data and Procedure Cache

As you have worked with SQL Server, you probably have run across the terms data cache and procedure cache, and may have wondered what exactly a cache was. SQL Server is configured to use a physical pool of memory on the server, and it will allocate the majority of this memory pool to hold data pages that have been read, along with the compiled execution plans for all previously-run Transact-SQL statements. It is this dynamic pool of memory that is being referred to by the data cache and procedure cache. Before SQL Server 7.0, the data cache and procedure cache were two separate pools of memory and could be controlled separately. In SQL Server 7.0 and SQL Server 2000, one pool of memory is used both for data and execution plans.

Manage Multiple SQL Server Installations and Databases with OSQL

At one point in time I was tasked with running over 70 databases on more than a dozen servers without any of the costly third-party tools that exist to accomplish such tasks, and I often get asked how can you handle such large numbers of databases. This is a short article that will show you how to use the handy OSQL command line utility, provided with SQL Server, to execute repetitive tasks against large numbers of databases or to manage large numbers of servers.

The Self-Taught DBA

You can’t go to college to become a DBA. Sure, you can take some basic classes on database theory and design, and maybe even a couple classes on specific databases, but there is no comprehensive college program you can take to become a DBA.

How to Search for Date and Time Values Using Microsoft SQL Server 2000
· 1

Suppose you’re writing a query to find all the invoices that were written on January 6, 2003. You know from the control totals that 122 invoices were written that day. But when you run this query: