Dreams of the Future
Steve Jones looks ahead to an interesting trip for the future of a couple of technical geeks.
How to Break Replication
David Poole is a regular author at SQLServerCentral.com, sharing many of his knowledge and experiences with us over the years. This time he examines some of the issues that you might have with replication.
Loading a 24x7 Data Warehouse
More and more companies are using data warehouses as a way of consolidating business critical information. And more and more of these companies want the warehouse available 24 hours a day, 7 days a week. This presents interesting challenges for the DBA involved in ETL processing. Longtime author Leo Peysakhovich brings us one solution for this problem.
Dimensional Model Components: Dimensions Part II
Business Intelligence Architect Bill Pearson continues his subseries surrounding components of the Analysis Services dimensional model. In the second half of this article, we extend our focus on dimensions to include property settings for Cube Dimensions.
Featured Blog: iFTS Performance – DocidMap
This next post from MVP Simon Sabin examines one of the major improvements in performance of search.
Masking Data
As DBAs we go to great lengths to ensure the security of our production data. But what happens when it moves off of a production server?
Masking Data
As DBAs we go to great lengths to ensure the security of our production data. But what happens when it moves off of a production server?
Masking Data
As DBAs we go to great lengths to ensure the security of our production data. But what happens when it moves off of a production server?
The Stewardship Approach to Data Governance: Chapter 8
This is the eighth article in a continuing series, and this installment discusses the Data Steward Coordinator.
Backing Up a Database with SMO
In SQL Server 2005, the management object framework changed substantially from the DMO framework in prior verisons. Now we have SMO, RMO, and other .NET assemblies that can be used to manage SQL Server. New author Brandie Tarvin brings us a short look at how SMO can be used to perform one of those critical tasks in SQL Server.
Blogs
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
Learning Tool – Deepstash
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Forums
Understanding Temp Tables and Table Variables in SQL Server
Comments posted to this topic are about the item Understanding Temp Tables and Table...
The Data API Builder MCP Server Tools
Comments posted to this topic are about the item The Data API Builder MCP...
Collecting Data Is Hard
Comments posted to this topic are about the item Collecting Data Is Hard
Question of the Day
The Data API Builder MCP Server Tools
The Data API Builder MCP Server, v2.x, includes a number of tools. What actions can these tools perform in your database?
See possible answers