SQL Server 2008 R2, SQL Server 2008, SQL Server 2005, SQL Server 2000
T-SQL, Performance Tuning, Security, Stored Procedures, Replication, Availability and Scalability, Backup and Recovery, Tools and Utilities, Interoperability, Installation
Analysis Services, Integration Services, Reporting Services, BI Strategies, Data Warehousing, Data Visualization
Migration and Planning, Compliance, Consolidation and Virtualization, Career Advice, Competitors
Definition
SQL (Structured Query Language) is a standard interactive and programming language for getting information from and updating a database. Although SQL is both an ANSI and an ISO standard, many database products support SQL with proprietary extensions to the standard language. Queries take the form of a command language that lets you select, insert, update, find out the location of data, and so forth. There is also a programming interface.
Several fault-tolerance configuration options are available with SQL Server 2008, from the traditional (failover clustering) to the updated (database mirroring).
Learn to troubleshoot an error that occurs when running the Service Pack 2 install for SQL Server 2005 that claims the account is not able to rename a file.
Maybe you're already using SANs in your SQL Server environment, but is it the optimal setup? Consider these pointers for a disk system design that yields a high performing and scalable SQL Server environment.
The Paradies Shops’ search for BI tools to access data quickly and break away from Excel spreadsheets started with data discovery vendors but didn’t end with them.
New research reveals businesses’ relative lack of “big data” maturity and the hurdles in both technology and analytics techniques they need to overcome.
Interest in mobile BI is growing, but democratizing data also presents hurdles for building a business case, according to new research from TDWI.
An addendum to the ASHRAE 90.1-2010 energy standard could ease energy efficiency requirements on anyone building or significantly expanding data centers in the U.S.
A well-timed mainframe database reorg can result in much improved response.
Point tools or management frameworks? Set realistic goals and criteria before choosing a systems management tool.
A popular auto club is using Dell Boomi cloud integration tools to drive an aggressive cloud computing strategy.
There’s no lack of choices to consider if you’re looking at a possible data virtualization deployment -- both in terms of the vendors offering tools and the potential uses for the technology.
Informatica and IBM are the top dogs in the data virtualization software market, thanks to a strong combination of “enterprise-class” features, according to Forrester Research Inc.
IT leaders need to get information governance right if MDM is to help cut costs, stoke productivity and mitigate risk, according to Gartner on the eve of the MDM summit.
Gartner’s BI London summit will show a landscape beset by strategic misalignment, intra-organisational struggle and weak cloud adoption. Yet mobile BI is becoming a reality.
Find out where to hone your business intelligence, data management and data warehouse skills with this list of training courses for 2012.
One reader asks how to set up a report in Oracle SQL so that Monday is the first day of the week.
Oracle Advanced Analytics is the company’s newest announcement around data analytics, a market that Oracle seeks to blanket with products.
Oracle has finalized its $1.5 billion acquisition of CRM SaaS provider RightNow Technologies, and to celebrate executives held a webcast outlining their future plans for all the CRM and cloud products the two have on the table.
Web content management is not just about publishing Web pages any more, according to one industry expert. It has become a way to use content to power useful business applications for the enterprise.
Digital archiving and the longevity of electronic information is being overlooked by enterprise content management professionals at the enterprise’s peril. Digital doesn’t necessarily mean permanent.
After technical infrastructure issues continually crashed Lancaster Bible College’s website over the course of a year, the school switched to a cloud Web content management system.
Remote Desktop Gateway secures Internet access for Remote Desktop Services applications – if you set it up properly.
Are you looking for scalability or performance? It's important to understand your needs before choosing a Windows Server hardware solution.
The Kerberos authentication protocol ensures safe connections between multiple platforms. Find out just how it creates secure connections in this overview.