Every SQL Server developer has a preferred method of doing things; mine is what I call molecular queries. These are queries assembled from atomic queries; by which, I mean that they address exactly one table. By combing atoms, I can create molecules.
2006-10-19
3,998 reads
The .NET Framework 2.0 and Visual Studio 2005 make it easy to create a basic but extensible database-monitoring solution without a lot of complexity or coding.
2006-10-18
4,043 reads
Sanchan Saxena gets to grips with the new index-tuning tools and features in SQL 2005
2006-10-17
3,510 reads
Are you up to the latest design challenge? A great way to sharpen our analysis and modeling skills is to continuously address real-world scenarios. A modeling scenario with suggested solutions appears each month in this Design Challenge column. The scenario is emailed to more than 1,000 modelers. The responses are then consolidated into this column.
2006-10-16
2,039 reads
This article examines a variety of ways in which you can execute all the SSIS packages in a folder.
2006-10-13
1,958 reads
This Script will create a copy of your DTS Package; append "_Renamed" to the end of the package name; and rename every task and step in the copied package to Task/Step_TaskType_DescriptionText_Sequence. The resulting package will lose all of it's text annotations, the layout will be the designer default rather than the original latout. It can […]
2006-10-12 (first published: 2005-01-05)
131 reads
Arthur Fuller advises DBAs to try to break their software in order to make sure their SQL Server databases can withstand potential attacks. See if your code can hold up to his suggested tests.
2006-10-12
3,499 reads
Database concurrency conflicts are somewhat of a plague in software development because they're hard to predict and handle. Unfortunately, they're also hard to prevent.
2006-10-11
2,638 reads
This tip shows you how to execute and use the results of prediction queries in multiple ways within the SQL Server relational database engine.
2006-10-10
2,466 reads
Microsoft has come to the rescue for managing large text fields in SQL Server 2005, by creating a few new large value data types. This article explores these new data types.
2006-10-09
2,297 reads
By Ed Elliott
SQL Server Management Studio (SSMS) has recently added support for Github Copilot. This is...
By Steve Jones
If it fails where you thought it would fail that is not a failure....
Quite a long title for a short blog post ??While deploying a DACPAC (from...
Comments posted to this topic are about the item Don't Create Workslop
Comments posted to this topic are about the item What is the original database...
Comments posted to this topic are about the item The DBScan algorithm tutorial
What is returned when this code is run?
SELECT ORIGINAL_DB_NAME()See possible answers