Social Software
More and more companies are looking to use social software, like Facebook, to link employees, but is this a good thing?
Best Practices when performing maintenance in a DBM environment
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:
How to import an Excel file into SQL Server 2005 using Integration Services
Integration Services, which replaces Data Transformation Services (DTS) in SQL Server 2005, is a tool for extracting, transforming, and loading data.
The Credit Debate
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.
The Credit Debate
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.
The Credit Debate
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.
A Refresher on Joins
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.
Bad Automation
Coming up with ways to do things automatically with software can be a boon to productivity, but not every idea is a good one.
Interview with Chuck Kelley - Part I
An interview with a data warehousing expert Chuck Kelley with some views about the careers in data warehousing.
XML Workshop XVII - Writing a LOOP to process XML elements in TSQL
Jacob Sebastian brings a little more complexity to working with XML documents. Here we learn how to iterate through a document and use each node and perform some action on each one.
Blogs
Monday Monitor Tips: Oracle Custom Metrics
By Steve Jones
One of the popular features of Redgate Monitor has been the ability to add...
Walking Through a Planned Failover: SQL Server Always On Availability Groups on Kubernetes
When building the sql-on-k8s-operator, I wanted to make sure it could handle both planned...
Reading SQL Server File Headers with DBCC FILEHEADER
I’ve been doing a deep dive into SQL Server on-disk structures lately, and one...
Forums
The Vector Data Type
Comments posted to this topic are about the item The Vector Data Type
What Power BI DirectQuery does to your SQL Server (and how to fix it)
Comments posted to this topic are about the item What Power BI DirectQuery does...
The New OS Wars
Comments posted to this topic are about the item The New OS Wars
Question of the Day
The Vector Data Type
What is the vector data type in SQL Server?
See possible answers