Standard Query Operators with LINQ
LINQ to Objects and LINQ to Entities have an arsenal of Standard Query Operators that operate on sequences to perform a wide variety of operations.
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.
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.
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
Practical SQL Server Development Tips for Better Database Projects
Working with SQL Server 2022 can be a great learning experience, but development tasks...
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