Additional Articles

SQL Server random numerics data generation using CLR

by Additional Articles

MSSQLTips.com

SQLCLR

You need to generate random data directly into SQL Server table columns or close to the database engine as variables or expressions. Looking at the SQL Server available functions, you notice that only RAND function offers support for random data generation. Although RAND([seed]) is a built-in function, it can only return a float value between 0 and 1, and has other limitations in regards to seed values. Because your table columns may be of various data types, and each data type may have a lower value and an upper value, you would prefer to create your custom random data generators. This is when SQL Server CLR functions come into play and provide a viable solution.

2011-03-24

3,275 reads

Naturally Increasing Data Value with Hierarchical Structures

by Additional Articles

Other

Data Modeling

Hierarchical structures have an inherent ability for significant data value increases beyond the data collected. This will be shown to exist in hierarchical structures and even more powerfully in their natural hierarchical processing capabilities. These will demonstrate flexible and efficient ways to increase data value automatically and will be discussed in this article. SQL will be used to perform a wide range of hierarchical processing operations that easily demonstrate these increasing data value capabilities.

2011-03-23

3,291 reads

Using Dynamic SQL in Stored Procedures

by Additional Articles

SQLTeam.com

T-SQL

Dynamic SQL allows stored procedures to “write” or dynamically generate their SQL statements. The most common use case for dynamic SQL is stored procedures with optional parameters in the WHERE clause. These are typically called from reports or screens that have multiple, optional search criteria. This article describes how to write these types of stored procedures so they execute well and resist SQL injection attacks.

2011-03-22

7,301 reads

SQL Server Service Broker - External Activation

by Additional Articles

Database Journal

Service Broker (SSSB)

SQL Server Service Broker allows for two types of messaging activation, Internal Activation or External Activation. In this article we discuss External Activation.

2011-03-21

2,453 reads

Mouse Clicks, Reactive Extensions and StreamInsight Mashup

by Additional Articles

sqlis.com

StreamInsight

I had an hour spare this afternoon so I wanted to have another play with Reactive Extensions in .Net and StreamInsight. I also didn’t want to simply use a console window as a way of gathering events so I decided to use a windows form instead. The task I set myself was this. Whenever I click on my form I want to subscribe to the event and output its location to the console window and also the timestamp of the event.

2011-03-18

2,408 reads

SQL Server 2008 and 2008 R2 Integration Services - Managing Local Processes Using Script Task

by Additional Articles

Database Journal

Integration Services (SSIS)

SQL Server 2008 R2 Integration Services includes a number of predefined tasks that implement common administrative actions to help with data extraction, transformation and loading (ETL). While in a majority of cases they are sufficient to deliver required functionality, there might be situations where an extra level of flexibility is desired.

2011-03-17

3,010 reads

Lipoaspiration in your SQL Server Database

by Additional Articles

SimpleTalk

Administration

Once, when disk space was at a premium, DBAs fought hard to keep the size of their database down. Now there seems less motivation to 'fight the flab' of a database. Fabiano Amorim was watching television recently when the subject matter, cosmetic surgery, gave him the theme and inspiration for this guide to keeping your database fit and trim.

2011-03-16

4,312 reads

How to Identify CPU Bottlenecks in SQL Server

by Additional Articles

MSSQLTips.com

Performance Tuning

We experience regular slowdowns on our MS SQL database. After analyzing the memory usage we would like to continue the root cause investigation by examining CPU bottlenecks. What is your recommendation to recognize CPU related bottlenecks in SQL Server?

2011-03-15

6,215 reads

SQL Server CASE Law

by Additional Articles

SimpleTalk

T-SQL

SQLs CASE expressions can be powerful magic, but can trap the unwary that are used to the more familiar CASE statements of procedural languages.

2011-03-14

6,011 reads

Change Management and Source Control

by Additional Articles

SimpleTalk

Version Control Systems (VCS)

So, given the many good reasons for using Version Control systems for managing the changes in database applications, how does one go about the rather different routines of team development, such as testing, continuous integration, and managing data? What are the issues that you're likely to face?

2011-03-11

4,004 reads

All authors

Additional Articles

SQL Server random numerics data generation using CLR

Naturally Increasing Data Value with Hierarchical Structures

Using Dynamic SQL in Stored Procedures

SQL Server Service Broker - External Activation

Mouse Clicks, Reactive Extensions and StreamInsight Mashup

SQL Server 2008 and 2008 R2 Integration Services - Managing Local Processes Using Script Task

Lipoaspiration in your SQL Server Database

How to Identify CPU Bottlenecks in SQL Server

SQL Server CASE Law

Change Management and Source Control

Blogs

Finding Balance: Things Will Come Up

Who Are You Doing It For?

Presenting Twice in May 2026

Forums

what data type i should use for roversion col and can i use less than greater

Radius Latitude Longitude

degree of parallelism

Question of the Day

A Fun Computer Quote