Denormalization in SQL Server for Fun and Profit
Normalization is standard practice in database design, however, an over-normalized database can have issues. This article examines the case for denormalization.
SQLRally Call for Speakers Closes December 15, 2010
The call for speakers is open through December 15, 2010, and I hope many of you will take the chance...
Costing Cool Projects
Can you accurately determine the cost or benefit of a new, cool project up front? Steve Jones thinks not, but coming up with new projects can be a way to set yourself apart from others.
24HOP Needs Women!
“Next 24 Hours of PASS on March 15-16 2011, celebrating Women’s History Month with 24 female speakers!”
Thus goes the announcement on...
Getting Started with Maps in SQL Server 2008 R2 Reporting Services
I noticed a new feature in SQL Server 2008 R2 Reporting Services that allows you to render maps in your reports. Can you provide some details on this new feature and can I take advantage of it even though don't have any spatial columns in my data warehouse?
What happens when a query is submitted?
I know, We cant cover life span of query in short. here is my another try to list some high level information...
Early December 2010 Free Training from PASS Virtual Chapters
The Performance, DBA, and B/I Virtual Chapters of PASS are back with free training.
Elections
Steve Jones found a very fascinating way that might keep elections more secure, verifiable, and also more open.
Managing Data in the Cloud
Crunching data or having access to vast amounts of data is crucial for many applications.
The Basics of Troubleshooting
After seeing several cases in the past couple of months where I felt the basics of troubleshooting were violated, I...
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