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
By submitting your registration information to SearchSQLServer.com you agree to receive email communications from TechTarget and TechTarget partners. We encourage you to read our Privacy Policy which contains important disclosures about how we collect and use your registration and other information. If you reside outside of the United States, by submitting this registration information you consent to having your personal data transferred to and processed in the United States. Your use of SearchSQLServer.com is governed by our Terms of Use. You may contact us at [email protected].
SQL Server 2000: SELECT * FROM master.dbo. sysdatabases
SQL Server 2005: SELECT * FROM master.sys.databases
This was first published in February 2008
Tag clouds are dead, according to the presenters at the eighth annual Text Analytics Summit who made a case for advanced text visualization techniques.
Text analytics consultant Seth Grimes opened the Text Analytics Summit by delving into what has been big this year in text analytics and what the future holds.
TWDI director of research Philip Russom deconstructs the 12 most misconstrued Hadoop characteristics and replaces rumor with fact.
Whether they automate disaster recovery or ensure continuous delivery of applications, data center pros push Opscode’s Chef beyond simple configuration management.
IBM DB2 10 users report the upgrade can cut administration costs, boost mission-critical apps and bring other benefits to your business.
Going overboard with server consolidation is as bad as not doing enough, but IT trends are keeping unchecked growth under control.
Two surveys found that many companies are moving to become more data-driven and that "big data" initiatives are among the items on their to-do lists.
Data accuracy is critical in technology-driven business processes, making it a must to involve business users in data quality efforts, analysts say.
A business intelligence data integration initiative can easily go off track because of problems such as data quality and data loading issues.
Big data MDM projects encounter a green field in the form of social media. And all big data is enterprise data, by definition. Business leaders will look to IT to derive serious business value.
Infosecurity and data management are failing to harmonise in complex corporate organisations, say data experts. Business value is the common ground that can bridge the divide.
The MDM market is not so mature that bad choices are difficult to make. Beware the hype of multi domain, and don't expect technology to solve governance problems, in isolation.
An Oracle Applications Users Group (OAUG) member explains her company's best practices around Oracle User Productivity Kit (UPK).
An Oracle Applications Users Group (OAUG) director explains her company's best practices for Oracle User Productivity Kit, also known as Oracle UPK.
An Infosys expert lays out four major ways to increase JD Edwards ERP adoption using the Oracle User Productivity Kit.
Combine basic SharePoint 2010 infrastructure management with end-user monitoring and third-party tools to effectively manage SharePoint for a dispersed organization, says consultant Shawn Shell.
The European Court of Human Rights website redesign uses Microsoft FAST enterprise search and SkyDox technology so visitors can easily find 90,000 documents related to rulings in 47 nations.
Get advice on who should be involved in determining an organization’s document retention schedule for best results.
Resultant Set of Policy? Group Policy Management Console? What does it all mean? Learn how to talk the talk with this Group Policy glossary.
The GUI is great for some things, but these scripts will help make your Group Policy administration much more efficient.
Mulling over an upgrade to Windows Server 2012? You're bound to have some questions. Our expert answers the most common ones.
Join the conversationComment
Share
Comments
Results
Contribute to the conversation