Evolution and Technology: Data Warehouse Infrastructure
A look an evolution of infrastructures from Bill Immon.
2009-05-21
2,405 reads
Additional Articles
Connectivity Options for Microsoft SQL Server 2008 Integration Services
This white paper provides an overview of the connectivity options that are available for SQL Server 2008 Integration Services.
2009-05-20
1,939 reads
SQL Server user defined function to convert MSDB integer value to time value
In a recent tip I outlined a process for converting a date, stored as an integer into a datetime data type. Date and time information for run history of SQL Server Agent jobs is stored within the msdb..sysjobshistory table as an integer data type, not as a datetime as one would expect. As promised, this tip picks up where we left off. On converting the integer-typed run_time into a format that is more user friendly for presentation purposes.
2009-05-20
2,522 reads
Comparing Files from Different Folders Using SQL Server and XML
Sometimes there is a need to process files in a folder, but first you need to determine which files need to be processed compared to older files that have already been processed. There are several ways that this can be done, but in this tip I show you a way this can be done using SQL Server and XML.
2009-05-19
2,568 reads
Peer-to-Peer Replication in SQL Server 2008 – Add a node and resolve conflict
Add a third node to a two-node Peer-to-Peer replication topology and learn how to resolve an update-update conflict.
2009-05-19
1,936 reads
Tuning Your SSIS Package Data Flow in the Enterprise (SQL Server Video)
This video demonstrates how to improve the performance of the data flow in an Integration Services package. In this video, you will learn how to tune the following phases of the data flow: Extraction, Transformation, Loading
2009-05-18
2,270 reads
Using PowerShell with SQL Server Management Objects (SMO)
I want to know how Windows PowerShell can help me as a SQL Server DBA.
2009-05-18
3,498 reads
Overview of Native XML Web Services for Microsoft SQL Server 2005
Get an overview of how to set up and use XML Web Services using SOAP/HTTP inside SQL Server 2005 (formerly known as "Yukon"). Illustrative examples are included. To get the most from this paper, you should have a basic understanding of Web service technologies including HTTP, SOAP, and WSDL.
2009-05-15
1,725 reads
SQL Server UDF to pad a string
Unlike other relational database management systems that shall remain nameless, SQL Server's underlying coding language, T/SQL, does not have a built-in function for padding string values. I recently took it upon myself to create my own and as you'll see I got a little carried away
2009-05-15
2,910 reads
Data Degradation
The other day at a conference, the subject of data degradation/corrosion arose. The speaker at the conference said that data in a database degraded or corroded over time. The statement was made as if degradation over time applied to all databases. I found this blanket statement to be misguided. Indeed, I think that data does degrade in some databases, but not all.
2009-05-14
2,180 reads
Blogs
A Pursuit of Lifelong Learning
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
Advice I Like: Time and Focus
By Steve Jones
“You don’t need more time because you already have all the time that you...
Book Review: Microsoft 365 Copilot and Agent Administration Fundamentals
I don’t currently manage Microsoft 365 Copilot in an enterprise environment, but it is...
Forums
What is the worst part about existing monitoring solutions?
Hi. What is the most difficult aspect of using monitoring software like idera, redgate,...
MiniMax m3 and SQL Server
Comments posted to this topic are about the item MiniMax m3 and SQL Server
Making an Impression
Comments posted to this topic are about the item Making an Impression
Question of the Day
SQL Server Vector Support I
What are vectors in SQL Server 2025, as related to the new AI features?
See possible answers