Many DBAs need to work with multiple platforms. New author Jagan Kumar brings us an article that helps to explain Oracle's architecture for those people used to working with SQL Server.
2009-07-02
10,633 reads
Use of event handlers provided in SSIS package to handle runtime errors while the package is running and logging the error information in the database.
2009-06-26
13,492 reads
Face it, you never intended to become a SQL Server expert, but the proliferation of this database engine – and its many editions – requires somebody to feed and care for it. You're the "Microsoft Guy" (or Gal), so whether you wanted to be or not, you were elected. This series of articles is all about making you more effective with SQL Server as an administrator, not a programmer.
2009-06-25
7,556 reads
Learn about the benefits of SQL Server 2008 consolidation on Windows 2008, with details on the different consolidation strategies available to organizations.
2009-04-07
2,707 reads
I'm continually trying to track down what service packs are installed on various SQL Servers I support. I can never find the right support page on Microsoft's site. So here's an article with all the SQL Server version information I can track down. If you know of any older versions or can help me fill out any missing data, please post in the comments and I'll update the article.
2009-02-04
3,287 reads
An interview with Herain Oberoi, group project manager for the SQL Server Business Intelligence and Data Warehouse product.
2009-01-02
2,872 reads
This refresher on SQL Server examines when to use a database as well when not to, along with some of the key terms used with SQL Server.
2008-09-09
3,025 reads
Backup all DBs of a SQL-Server Instance depending on Environment Variable "DBBackupPath". The script also distinguishes between Instances
2008-05-22 (first published: 2008-03-28)
2,402 reads
2008-02-27
3,362 reads
Interviewing, Google as a monopoly, Cumulative Update 5 and more.
2007-12-31
113 reads
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
By Brian Kelley
Another security fundamentals topic is authentication versus authorization. For those who have a clear...
Thesis help services offer expert guidance and topic selection to final submission. They provide...
Experts, I am learning some skills so I can troubleshoot some performance-related issues. I...
What happens when I run this code:
SELECT p.ProductName , p.ProductCategory FROM dbo.Product AS p WITH (NOLOCK, TABLOCK);See possible answers