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.
2009-01-19
3,390 reads
Articles
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?
2009-01-19
4,183 reads
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...
2009-01-19
198 reads
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!
2009-01-19
160 reads
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.
2009-01-17
69 reads
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.
2009-01-17
805 reads
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.
2009-01-17
517 reads
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.
2009-01-17
472 reads
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.
2009-01-16 (first published: 2007-12-06)
60,384 reads
Adobe AIR: Running SQL Commands Against a Local Database
Once you've established a connection between an Adobe AIR application and a local database, you can run SQL commands (CREATE TABLE, INSERT, DELETE, SELECT, etc.) using the flash.data.SQLStatement class. Find out how.
2009-01-16
4,334 reads
Blogs
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Forums
Creating JSON II
Comments posted to this topic are about the item Creating JSON II
Engineer Lessons
Comments posted to this topic are about the item Engineer Lessons
Question of the Day
Creating JSON II
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers