The Visit of the Recovery Testers.
Phil has a nasty surprise when a team of testers turn up to test an n-tier system
Using FOR XML clause to generate KML
Creating KML files for many of the GIS applications such as Google Earth can be an easy and rich part of your business intelligence efforts
Combining SQL Server & Flash Technologies - Floor Plan example
Starting the summer 2002, for about a year or so, the team and I embarked on a project to develop business for local utilities giant Hydro Quebec, by developing a web site for the twenty-first International Commission on Large Dams' congress in Montreal, where it was hosted in 2003.
Connecting Oracle BI Publisher to SQL Server
One of the main features of Oracle Business Intelligence Publisher (BIP) is its ability to connect to pretty much every major RDBMS on the market. Steve Callan shares the little documented steps of how to establish a connection to SQL Server.
Dropping multiple objects with a single DROP statement
Most SQL Server users drop one object at a time using either SSMS or a single drop statement. In many scenarios we may need to drop several objects of the same type. Is there a way to drop several objects through less lines of code?
The March 2009 Car Update
This month Steve Jones looks at the problems in the auto industry along with a link to the cars most likely to be caught speeding.
The March 2009 Car Update
This month Steve Jones looks at the problems in the auto industry along with a link to the cars most likely to be caught speeding.
The March 2009 Car Update
This month Steve Jones looks at the problems in the auto industry along with a link to the cars most likely to be caught speeding.
Tip for determining I/O Heavy Queries
When it comes to performance tuning, locating the problem index is one of the first steps and being able to very quickly narrow the focus of your efforts makes for a much more efficient DBA.
SQL Q & A: Database Consistency, Temporary Tables, and More
Why does DBCC CHECKDB find corruption errors that disappear? Does tempdb really cause performance issues? Are there any drawbacks to using the FILESTREAM datatype? Paul Randal answers these reader questions and more.
Blogs
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Creating a SQL Stored Procedure to Load a SCD2
By DataOnWheels
This is a blog that I am writing for future me and hopefully it’ll...
Funny Money: #SQLNewBlogger
By Steve Jones
While wandering around the documentation looking for some Question of the Day topics, I...
Forums
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
SQL ART: Who's Blocking Who? Visualising SQL Server Blocking With Spatial Geometry
Comments posted to this topic are about the item SQL ART: Who's Blocking Who?...
Running SQLCMD II
Comments posted to this topic are about the item Running SQLCMD II
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers