Database Administrator
164 Stories
Bulk importing data into SQL Server
Techguide If you work with databases, at some point, you’ll deal with inserting data into SQL Server from outside data files.
Audit data using SQL Server 2005's COLUMNS_UPDATED function
Techguide Take a look at two functions that can track the individual fields that have been modified--useful tools for data audit and debugging database code.
Tags: Databases, Database management, Data security
Oracle, Dell plan server bundle
News Extending a year-old partnership, the two companies are expected to announce a plan to install Oracle's database software on Dell's server hardware.
Policy-Based Management in SQL Server 2008
Techguide New to SQL Server 2008 is Policy-Based Management, which gives administrators more control over their database procedures.
Tags: Servers, Databases, Microsoft SQL Server, Database, Policy, Database Table, stored procedure, DDL, Condition, Facet
Defining SQL Server 2008 policies
Techguide Learn how you can use SQL Server Management Studio to define your own policies.
Tags: Microsoft Windows, Data Management, Microsoft SQL Server, Database, Policy, Microsoft SQL Server Management Studio, stored procedure, database engine, Condition, Facet
10 roles you need for ITIL configuration management
Techguide If you’re serious about building an effective configuration management service, you’ll need to consider who will accomplish 10 key functions. Here’s a brief rundown of the essential roles that should be covered.
Tags: IT Management, Configuration Management, ITIL, Training, Database, Tool, CMDB, Integrator Role, Larry Klosterboer, database administrator
Sun sheds light on its open-source future
Insight Simon Phipps, Sun UK's chief open-source officer, surveys the open-source landscape and reaffirms his company's commitment to open software development.
Tags: Open source, Java, Security, Google Inc., Ubuntu, Sun Microsystems Inc., software, system administrator, database administrator, strategy
Forrester foresees future of tech as 'IT everywhere'
News The evolution of existing trends, rather the advent of revolutionary tech, will shape enterprise IT in the coming years, says the company.
Tags: RFID, Business applications, Web 2.0, Mobile/Wireless, Forrester Research Inc., Technology, Mobile, SOA, business application, social networking
Google helps form 'white space' database coalition
News The search giant and a few other technology firms are helping the U.S. Federal Communications Commission come up with a database for services in the unused slivers of spectrum.
Tags: Open source, Web sites, Microsoft Corp., Motorola Inc., Google Inc., TV, Wireless Broadband, Database, Spectrum, Wireless
Revealed: CIOs' biggest challenges this year
News In 2009, CIOs are challenged to do more with less and proving how vital the IT department is to businesses, new study shows.
Tags: Business Strategies & Functions, IT budgeting, Cost control, ITIL, IT Budget, Survey, Steve Ranger, business skill, CIO, Silicon.com
Reviewing SQL Server permissions
Techguide Find out the importance of database permissions, and how you can use internal SQL Server system views to easily identify which users have access on your system.
Tags: Servers, Server platforms, Database management, Databases, Microsoft SQL Server, Login, Database, Permission, Windows Login, TestLogin
Balance functionality and security in risk management
Insight Learn how to apply the principles of risk management to your corporate data networks.
Tags: Business development/management, Risk Management
U.K. women abandoning tech jobs
News Most damaging for the industry is the loss of experience, contacts and relevant role models when senior female execs leave.
Tags: Human resources, Leadership
Examine user creation scripts before migrating
Techguide Oracle has changed the meaning of the standard CONNECT role in 10g Release 2 (10gR2). Be sure to examine any scripts your organization uses that create new database user accounts before migrating to this version.
Tags: Databases
Microsoft pitches new Visual Studio tools
Architect At a Visual Studio programmer conference in San Francisco, firm touts tools due in its Visual Studio 2005 family of products.
Tags: Programming languages
