The Agile Cult
Lots of developers have embraced Agile development, and Steve Jones thinks it's a good way to build software. However, it's not necessarily as easy as you might think.
2008-09-22
79 reads
Articles
The Agile Cult
Lots of developers have embraced Agile development, and Steve Jones thinks it's a good way to build software. However, it's not necessarily as easy as you might think.
2008-09-22
61 reads
Face to Face
The cost of fuel is rising, telecommuting is becoming more widespread, and the advance of digital technologies has us often working virtually, even in the same office. Steve Jones thinks we shouldn't forget the value of a little face time and and then.
2008-09-21
105 reads
Face to Face
The cost of fuel is rising, telecommuting is becoming more widespread, and the advance of digital technologies has us often working virtually, even in the same office. Steve Jones thinks we shouldn't forget the value of a little face time and and then.
2008-09-21
76 reads
Face to Face
The cost of fuel is rising, telecommuting is becoming more widespread, and the advance of digital technologies has us often working virtually, even in the same office. Steve Jones thinks we shouldn't forget the value of a little face time and and then.
2008-09-21
67 reads
2008-09-19
13,027 reads
Build a Metadata-Driven ETL Platform by Extending Microsoft SQL Server Integration Services
SQL Server 2008 Integration Services (SSIS) provides a flexible and scalable architecture that enables high-performance data extract, transform, and load (ETL). The Microsoft Business Intelligence Center of Excellence has extended SSIS to a metadata-driven platform to more effectively build, deploy, and manage ETL processes in large data warehousing environments.
2008-09-19
3,818 reads
Data Warehouse Capacity Planning as Capacity Enforcement
Capacity planning is a problem for a data warehouse because it sets contrasting functional requirements against each other. On one hand, data warehouse customers consume data warehouse capacity as they query the data in the data warehouse business intelligence (BI) reporting. Meanwhile, applications consume data warehouse capacity as they load data into a data warehouse through the extract, transform and load (ETL) process.
2008-09-19
3,269 reads
Good Data Loss - Database Weekly (Sept 22, 2008)
As we retain more and more data, it becomes important not just to decide how long to retain different types of data, but also to identify that data that can be removed. Steve Jones talks about some of the challenges of this with databases.
2008-09-19
518 reads
Good Data Loss - Database Weekly (Sept 22, 2008)
As we retain more and more data, it becomes important not just to decide how long to retain different types of data, but also to identify that data that can be removed. Steve Jones talks about some of the challenges of this with databases.
2008-09-19
766 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
Adding new column with DEFAULT
Comments posted to this topic are about the item Adding new column with DEFAULT
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
Question of the Day
Adding new column with DEFAULT
Which number will the COUNT() return after executing the following statements:
DROP TABLE IF EXISTS #test; CREATE TABLE #test (id INT) INSERT INTO #test (id) SELECT * FROM GENERATE_SERIES(1, 3) AS gs ; ALTER TABLE #test ADD flag BIT CONSTRAINT DF_#test_flag DEFAULT 0; go UPDATE #test SET flag = 0 WHERE id = 1 UPDATE #test SET flag = 1 WHERE id = 2 INSERT INTO #test (id) VALUES (4) SELECT COUNT(*) FROM #test AS t WHERE flag = 0See possible answers