SQL Server

Source: techrepublic.com.com --- 1 hour ago
Tim Chapman shows how to create system stored procedures that will allow you to loop through and execute statements against any type of object in SQL Server 2005. ...

Source: whitepapers.techrepublic.com.com --- 7 hours ago
L-3 Vertex Aerospace has more than 11,000 staff at 300 locations around the world to service 3,500 aircraft, including 89 distinct types, primarily for the U.S. government. Bidding on new contracts requires drawing on millions of rows of accounting and inventory data, which had been stored on an IBM 3090 mainframe computer that was difficult and expensive to maintain. As L-3 Vertex's business grew, it needed a more flexible system that was easier to use. The company moved the system to Microsoft SQL Server 2005, which dramatically reduced costs, cut the turnaround time on queries from weeks to days, and allowed users to run their own analytics using SQL Server 2005 Reporting Services. ...

Source: it.seek.com.au --- 21 hours ago
Latest jobs from www.seek.com.au. Australia's #1 job site Date & time listed: 8/07/2008 11:02:14 AM Job ad summary: Global company has excellent role available for an experienced SQL Server DBA to work on interesting troubleshooting/database improvement projects!!!! Create a new feed with different search criteria Send us feedback about these feeds. ...

Source: it.seek.com.au --- 23 minutes ago
Latest jobs from www.seek.com.au. Australia's #1 job site Date & time listed: 9/07/2008 2:00:18 PM Job ad summary: Want some extra cash whilst waiting for your next position? This immediate start, 2 week contract will keep your mind active and wallet full! Create a new feed with different search criteria Send us feedback about these feeds. ...

Source: it.seek.com.au --- 1 day ago
Latest jobs from www.seek.com.au. Australia's #1 job site Date & time listed: 8/07/2008 10:31:49 AM Job ad summary: An exciting permanent opportunity for an experienced SQL Server administrator/developer with a 90K permanent package Salary: $80,000 - $110,000 pkg depending on experience Create a new feed with different search criteria Send us feedback about these feeds. ...

Source: searchsecurity.techtarget.com --- 1 day ago
Microsoft said it would repair vulnerabilities in SQL Server and Windows that could allow an elevation of privilege, spoofing and remote code execution. ...

Source: searchsqlserver.techtarget.com --- 23 hours ago
The Service Broker feature in SQL Server 2005 allows you to queue data of stored procedures and other application development components. Instead of processing the data, it's sent to a queue where it can be automatically read at a later date and processed within the message. Follow these steps for setting up Service Broker and experience a rock solid communications' platform for transmitting data from one SQL Server system to another. ...

Source: itknowledgeexchange.techtarget.com --- 23 hours ago
New Question Created by Zini ...

Source: itknowledgeexchange.techtarget.com --- 23 hours ago
New Question Created by Zini ...

Source: www.devx.com --- 13 hours ago
Histograms help people analyze large amounts of data, whether you display them as tables or as charts. This article shows you how to do both. ...

Source: www.derkeiler.com --- 2 hours ago
Bugtraq: iDefense Security Advisory 07.08.08: Microsoft SQL Server Restore Integer Underflow Vulnerability ...

Source: secunia.com --- 8 hours ago
Four vulnerabilities have been reported in Microsoft SQL Server, which can be exploited by malicious users to gain escalated privileges. Be sure to check if your system is missing security updates or have insecure applications installed: http://secunia.com/software_inspector/ Feature Overview - The Secunia Software Inspector: * Detects insecure versions of applications installed * Verifies that all Microsoft patches are applied * Assists you in updating your system and applications * Runs through your browser. No installation or download is required. ...

Source: www.dbforums.com --- 1 day ago
I am trying to import one big table around 3m rows from access db to SQL Server 2000, but it gave me the error as belows: Error at destination fro row number 2756760. errors encountered so far in this task:1. The log file for database ‘du_repository_xx’ is full. Backup the transaction log for the... ...

Source: forums.databasejournal.com --- 1 day ago
Forum: Ask an Expert Posted By: teixeira Post Time: 07-07-2008 at 12:16 PM ...

Source: www.sqlservercentral.com --- 1 day ago
In the previous installment of our series, we presented a variety of reasons that might influence your decision to upgrade a full-fledged member of the SQL Server 2005 family. This article discusses the actual implementation of this process, pointing out additional factors that might affect its complexity. ...

Source: www.computerweekly.com --- 1 day ago
Microsoft will issue four security patches next week to address vulnerabilities... ...

Source: www.sqlservercentral.com --- 1 day ago
Storage area networks (SANs) improve SQL Server performance. Set up SANs on SQL Server with these best practices on migrating to, and configuring SANs. ...

Source: www.seclists.org --- 3 hours ago
Just to clarify, the following SQL Server vulnerabilities vulnerabilities: SQL Server Buffer Overrun Vulnerability - CVE-2008-0106 SQL Server Memory Corruption Vulnerability - CVE-2008-0107 Convert Buffer Overrun - CVE-2008-0086 can be exploited to take complete control of the system on Windows 2003, ... ...

Source: whatis.techtarget.com --- 12 hours ago
SQL Server 2005 T-SQL includes a set of functions that let you rank the rows in your result set. SQL Server expert Robert Sheldon defines and gives examples of how to use the four ranking functions: ROW_NUMBER, RANK, DENSE_RANK and NTILE. Include one or more of these functions in your query SELECT clause and automatically assign a rank to each row in your result. ...

Source: whatis.techtarget.com --- 7 hours ago
Four security bulletins address a DNS Server spoofing vulnerability and a flaw in SQL Server that could allow an elevation of privilege of an authenticated attacker. ...