More and more companies are looking to use social software, like Facebook, to link employees, but is this a good thing?
If you have configured database mirroring in synchronous with or without automatic failover mode, you can switch to the mirror server instance and make it available to the clients while you perform hardware or software maintenance on the principal server instance. So let’s see how we can do this:
Integration Services, which replaces Data Transformation Services (DTS) in SQL Server 2005, is a tool for extracting, transforming, and loading data.
As databases grow, we store more and more types of data. This Friday's poll asks what types of data you don't want to store.
As databases grow, we store more and more types of data. This Friday's poll asks what types of data you don't want to store.
As databases grow, we store more and more types of data. This Friday's poll asks what types of data you don't want to store.
Knowing the various types of joins can greatly expand your T-SQL skills. Jambu Krishnamurthy brings us a refresher article on the various types of joins and how to write them.
Coming up with ways to do things automatically with software can be a boon to productivity, but not every idea is a good one.
An interview with a data warehousing expert Chuck Kelley with some views about the careers in data warehousing.
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...
I have a SQL Server 2019 Enterprise Edition on CU 25. It has in-memory...
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