Interview with Chuck Kelley - Part II
Part two of the interview looks at some design decisions in building a warehouse as well as some of the tools available.
2008-03-27
1,229 reads
Articles
2008-03-27
5,143 reads
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:
2008-03-27
2,029 reads
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.
2008-03-27
4,921 reads
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.
2008-03-27
29 reads
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.
2008-03-27
40 reads
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.
2008-03-27
34 reads
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.
2008-03-26 (first published: 2007-04-24)
19,179 reads
Interview with Chuck Kelley - Part I
An interview with a data warehousing expert Chuck Kelley with some views about the careers in data warehousing.
2008-03-26
1,613 reads
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.
2008-03-26
13,761 reads
Blogs
Measuring RAG Solutions: Are We Retrieving the Right Information?
A RAG pipeline that answers questions in the demo is not the same thing...
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Building a DBA Agent for Your SQL Server Estate with MCP
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Forums
How do I connect to a SQL Server database on my ISP?
I've got a web application for my side business. I've added a SQL Server...
Looking for New Blood
Comments posted to this topic are about the item Looking for New Blood
Server-Level Row Counts for Tables and Views
Comments posted to this topic are about the item Server-Level Row Counts for Tables...
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers