Additional Articles

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

SSRS Report Parts Versus Sub Reports FAQ

by Additional Articles

MSSQLTips.com

Reporting Services (SSRS)

I'm trying to decide on a development strategy to satisfy the reporting needs in my organization. I would like to increase our efficiency in responding to report requests, while minimizing our maintenance burden. Two topics that I would like to dig in to are Report Parts and Subreports. Can you provide some considerations for using one versus the other?

2011-03-11

4,261 reads

The EXCEPT and INTERSECT Operators in SQL Server

by Additional Articles

SQLServerCentral.com

T-SQL

The UNION, EXCEPT and INTERSECT operators of SQL enable you to combine more than one SELECT statement to form a single result set. Rob Sheldon explains all, with plenty of examples.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(1)

You rated this post out of 5. Change rating

2011-03-10

6,323 reads

Hiding System Objects in Object Explorer in SQL Server Management Studio

by Additional Articles

MSSQLTips.com

Management Studio (SSMS)

While looking through the new features and improvements in SQL Server Management Studio (SSMS) we found a potentially interesting one to Hide System Objects in Object Explorer in SQL Server Management Studio. In this tip we will take a look at how to Hide System Objects in Object Explorer.

2011-03-09

4,423 reads

Understanding and Using Parallelism in SQL Server

by Additional Articles

SimpleTalk

parallelism

SQL Server is able to make implicit use of parallelism to speed SQL queries. Quite how it does it, and how you can be sure that it is doing so, isn't entirely obvious to most of us. Paul White begins a series that makes it all seem simple, starting at the gentle level of counting Jelly Beans.

2011-03-08

4,900 reads

All authors

Additional Articles

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

SSRS Report Parts Versus Sub Reports FAQ

The EXCEPT and INTERSECT Operators in SQL Server

Hiding System Objects in Object Explorer in SQL Server Management Studio

Understanding and Using Parallelism in SQL Server

Blogs

Resetting on the AI hype train

A New Word: Etherness

Vibe Coding a Login Tracking System

Forums

The Microsoft SQL Year in Review

T-SQL in SQL Server 2025: The || Operator

Your Value from a Conference

Question of the Day

UNISTR Basics