Advanced new features in SSMS 2008
SQL Server Management Studio 2008 has several new features, including the T-SQL Debugger for easier debugging and a new Object Explorer Details window that's easier to use.
Analyzing the SQL Server Plan Cache
Keeping in mind the importance of the cache mechanism, how could one get the plans and their usage statistics in SQL Server?
The Hassles of Travel - Part 2
I didn't want to go on this trip, but I agreed to do it. Now I regret it. My flight to Chicago was fairly uneventful, but it was running late. At 4:30CST the pilot says we should be on the ground in 30 minutes, which is good since I have to get to...
The Story of the TV Stand
We all have those things that happen at work that somehow turn into something other than expected, and sometimes in quite humorous fashion. I've got a few to share over the next couple months, but had to start with this one!
Managing Your IT Data
A new application manages data from your IT machines and software, but doesn't use a database. Steve Jones talks a little about this.
Virtual Memory - Database Weekly (Jan 19, 2009)
Virtual memory is something we deal with in Windows systems, but Steve Jones talks about a different kind of virtual memory this week.
Virtual Memory - Database Weekly (Jan 19, 2009)
Virtual memory is something we deal with in Windows systems, but Steve Jones talks about a different kind of virtual memory this week.
Virtual Memory - Database Weekly (Jan 19, 2009)
Virtual memory is something we deal with in Windows systems, but Steve Jones talks about a different kind of virtual memory this week.
Hidden RBAR: Triangular Joins
Just because it looks set based, doesn't mean it is. T-SQL Crackerjack Jeff Moden takes a look at a mistake that many query writers make.
Open Source Pay
Steve Jones talks about salaries and whether or not there's value in disclosing them. Respond to this Friday poll.
Blogs
The Book of Redgate: Do the Right Things
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
Forums
Let's Talk Community Events!
Comments posted to this topic are about the item Let's Talk Community Events!
that one limitation in replication
Hi as shown below a replication target requires a primary key. if we want...
Local Agents
Comments posted to this topic are about the item Local Agents
Question of the Day
Detecting Deadlocks
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers