One common problem in querying is to reference the previous row in a data set as part of a calculation. David McKinney brings us an interesting solution using SQL Server 2005.
2010-08-20 (first published: 2008-03-13)
55,440 reads
It's time to integrate social data, enterprise analytics and enterprise data for better social-media strategy.
2010-08-20
1,748 reads
Describes how to convert database mirroring to log shipping in SQL 2005/2008.
2010-08-19
6,127 reads
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
2010-08-19
1,579 reads
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.
2010-08-18
8,729 reads
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?
2010-08-18
3,181 reads
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.
2010-08-17
303 reads
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
2010-08-17 (first published: 2010-08-05)
4,680 reads
DDL triggers enable us to audit DDL changes but there are a few missing events, design decisions and installation complications.
2010-08-17
7,784 reads
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.
2010-08-17
2,348 reads
By James Serra
(This post starts a three-part series on how AI is changing the way we...
I built a free library of runnable SQL Server demos. Each reproduces a real...
By Steve Jones
I was looking over the CHOOSE() function while editing an article at SQL Server...
We're currently in Azure, however as we had a very tight migration timeline when...
I have a section of code similar to the following abstract: DECLARE @loop [int]...
Hello everyone, I am planning to implement a data purging solution that is expected...
In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?
See possible answers