This article outlines a more objective and analytical approach to the ETL and data flow architecture selection based on a set of variables with an objective to enhance the reliability of the overall data warehousing solution.
2009-09-29
4,823 reads
Are IT administrators focusing on the wrong attacks when securing their systems? Should we as DBAs and developers care? Steve Jones argues that we want to be aware of these issues.
2009-09-29
739 reads
Are IT administrators focusing on the wrong attacks when securing their systems? Should we as DBAs and developers care? Steve Jones argues that we want to be aware of these issues.
2009-09-29
471 reads
Are IT administrators focusing on the wrong attacks when securing their systems? Should we as DBAs and developers care? Steve Jones argues that we want to be aware of these issues.
2009-09-29
557 reads
Joe Celko comes back with a puzzle that isn't new, but one where the answer he originally gave now seems archaic: It is a deceptively simple problem, but is it true that the new features of SQL have simplified the solution? We leave it to the readers to provide the answer!
2009-09-28
3,530 reads
This article describes the benefits of asynchronous processing and discusses three possible ways to implement this type of workflow within your own systems.
2009-09-28
2,417 reads
Your servers are only as fast as the slowest part, hard drives.
To feed other parts of the system we have...
2009-09-28
2,687 reads
BI Architect Bill Pearson introduces Storage in Analysis Service 2008. This article begins an extended examination of storage topics, including partitions and aggregations, within a multiple-article subseries.
2009-09-28
3,549 reads
The way that you view the world is often different that the way others might. It can be helpful to remember that when you are trying to work with others, or even critique their work. Steve Jones talks about the need to remember that as you progress in your career.
2009-09-28
90 reads
The way that you view the world is often different that the way others might. It can be helpful to remember that when you are trying to work with others, or even critique their work. Steve Jones talks about the need to remember that as you progress in your career.
2009-09-28
104 reads
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Comments posted to this topic are about the item Database security permissions save script
I have a SQL Agent job for backing up a set of Analysis Services...
Comments posted to this topic are about the item SQL Server 2025 Backup Compression...
I want to use the new BASE64_ENCODE() function in SQL Server 2025, but return a string that isn't large type. What is the longest varbinary string I can pass in and still get a varchar(8000) returned?
See possible answers