This tool is excellent when investigating what is going on in your StreamInsight Streams. I was looking through the menu items recently and went to Query => Event Fields I found that there were a couple of columns not added by default to the event viewer (Reminds me of the fact that the Variables viewer in SSIS hides columns also) Latency NewEndTime EnqueueTime Here they all are together. This gives us even more information about what is going on

Can you set a pagefile more than 4GB?

by Stanley Chan

SQLServerCentral.com

Administration

Can you set a pagefile on a Windows machine to more than 4GB? Stanley Chan shows us how after an issue with a crashed Windows machine.

Penalties

by Steve Jones

SQLServerCentral.com

Editorial

Terry Childs gets sentenced for refusing to turn over passwords to his boss. Steve Jones reminds us that we work for someone and that we have to remember that when taking a stand.

Run SQL Command Against Multiple Instances Without CMS

by Additional Articles

MSSQLTips.com

Administration

I understand that I can use Central Management Servers to run a T/SQL query against multiple instances at once - can I do this without CMS though?

Beginning SQL Server

by Steve Jones

SQLServerCentral.com

Presentations

A presentation by Steve Jones that talks about the technical basics of what SQL Server is and how it works with some hints about backups, security, and more.

Improving database development with SQL Source Control

by Press Release

SQLServerCentral.com

A webinar sponsored by Red Gate Software showing you how easy it can be to source control your database code. Thursday, August 19, 2010 12:00 PM EDT

Keeping Engaged

by Steve Jones

SQLServerCentral.com

Editorial

How can you better keep employees engaged in your company? Keep them happy and hopefully retain them for a long time? Steve Jones has some comments today.

SQL 2008 & 2005 DDL Auditing - Full Server Self Maintaining Solution

by Sean Elliott

SQLServerCentral.com

DDL triggers enable us to audit DDL changes but there are a few missing events, design decisions and installation complications.

Performing a Left Anti Semi Join in StreamInsight

by Additional Articles

sqlis.com

StreamInsight

Performing a LEFT OUTER JOIN in TSQL is easy. The same logic in StreamInsight requires a little more work. In this presentation I show exactly how you can perform a LEFT OUTER JOIN on your event streams. Your browser cannot play this video. Learn how to fix this.

A Server is Not a Machine

by Steve Jones

SQLServerCentral.com

Editorial

With cloud computing use growing, and SQL Server Azure becoming more popular, Steve Jones wishes this would become a product that the rest of us could deploy.

Additional Columns in StreamInsight Event Flow Debugger

Can you set a pagefile more than 4GB?

Penalties

Run SQL Command Against Multiple Instances Without CMS

Beginning SQL Server

Improving database development with SQL Source Control

Keeping Engaged

SQL 2008 & 2005 DDL Auditing - Full Server Self Maintaining Solution

Performing a Left Anti Semi Join in StreamInsight

A Server is Not a Machine

Blogs

Scooby Dooing Episode 9: The Case of the Artificially Intelligent Villain

The Book of Redgate: Don’t be an a**hole

Beyond Pipelines: How Fabric Reinvents Data Movement for the Modern Enterprise

Forums

Create an HTML Report on the Status of SQL Server Agent Jobs

Line number in error message doesn't match up with line number in code

Building a RESTful API with FastAPI and PostgreSQL

Question of the Day

A Common Split