I was talking with someone recently who was building a dynamic process that generated its own code at runtime to process ETL files based on a set of rules. It was an impressive system, and reminded me of how BIML can dynamically produce code and build packages.
However then I started to wonder. If you produce code at runtime that then runs, how well is that code tested? I suspect most people would test the code generation process. Is this producing the code I expect, but how many would then write additional tests for the generated code as it executes? I suppose people might also just test the generated code, but if that's the case, are they really testing the generation process extensively?
I'm not sure there's an easy answer, and not sure if there's actually a strong testing framework that exists to help here. As BIML becomes more popular and even ETL frameworks are used more and more in our software processes, I hope that we develop new testing methods to better ensure we are building quality code. I know some SSIS test frameworks exist, and there has been some writing on the topic, but I wonder how many SSIS developers bother to perform anything more than cursory tests? My suspicion is very, very few.
Ultimately I think we as an industry need to learn to build better software by improving our techniques, samples, skills, and testing.
In this Stairway, Sebastian will be covering the details of SQL Server transactional and merge replication, from understanding the basic terminology and methodology of setting up replication, to describing how it works and how the basic replication processes can be monitored. More »
Three SQL Server MVPs (Jonathan Kehayias, Ted Krueger and Gail Shaw) provide fascinating insight into the most common SQL Server problems, why they occur, and how they can be diagnosed using tools such as Performance Monitor, Dynamic Management Views and server-side tracing. The focus is on practical solutions for removing root causes of these problems, rather than "papering over the cracks". More »
In-Memory table or what Microsoft refers to as In-Memory OLTP, or Hekaton is a new type of table is available with SQL Server 2014. In this article Greg Larsen discusses the different types of indexes you can place on your In-Memory tables, and how those indexes support different search criteria. More »
If you decide to park a database in read-only mode for a long period of time, go ahead and alter... More »
Question of the Day
Today's Question (by P Sibi):
Which edition of SQL Server supports "Data compression and the vardecimal storage format"?
Think you know the answer? Click here, and find out if you are right.
We keep track of your score to give you bragging rights against your peers.
This question is worth
1 point in this category: editions.
We'd love to give you credit for your own question and answer.
To submit a QOD, simply log in to the
Yesterday's Question of the Day
(by Mike Hays):
In SQL Server 2008 and beyond, automatic page repair is supported by database mirroring and by AlwaysOn Availability Groups. Which three page types can the page repair process not automatically repair?
Global Allocation Map (GAM) page
File Header page
The Automatic page repair cannot repair the following control page types: File header page, the database boot page, & the Global Allocation Map (GAM) page.
bulk export of xml column
- with reference to http://technet.microsoft.com/en-us/library/ms191184.aspx
res\db_features\bulk_import\examples_of_bulk>bcp practise..xTable out a-wn_x.out
-x -T -S user-PC\sqlexpress
Enter the file storage type of field xCol [nvarchar(max)]: varybin
XML Export File
- Hi Friends,
The below i have mentioned the sample data and Table structure
[code="sql"]CREATE TABLE [dbo].[Xml_Export](
[City] [nvarchar](200) NULL,
[Company] [nvarchar](300) NOT NULL,
- Hii Guys
what are Isolation Levels ? how to apply various isolation levels and please give me a detailed information in understanding...
Updating ID field
I have a table:
CREATE TABLE [dbo].[FIM_GLOBAL_ID](
[GlobalID] AS ('RH'+right(''+CONVERT([varchar],[ID]),(10))),
[ID] [int] IDENTITY(100100,1) NOT NULL,
[FirstName] [varchar](50) NULL,
[LastName] [nvarchar](50) NULL,
[PreferredName] [varchar](50) NULL,
[DisplayName] [varchar](50) NULL,
Error with packages in 64-bit environment
- Version information on my computer :
Visual Studio 2005 Professional, Version 8.0.50727.42 (RTM.050727-4200)
.NET Framework 2.0.50727 SP2
Integration Services Version 9.00.2047.00
SQL Server version...
This newsletter was sent to you because you signed up at SQLServerCentral.com.
Feel free to forward this to any colleagues that you think might be interested.
If you have received this email from a colleague, you can register to receive it here.