FK Hierarchy v 2.1
Last month I published an update to my Foreign Key Hierarchy script. Today, I am providing a new update for...
2011-08-09
677 reads
Blog Posts
Functionality and User Experience are important, too
There are a few posts and articles around the security-scape lately concluding Windows 7 is more secure than OS X,...
2011-08-09
818 reads
How to setup CMS
If you need to setup a Central Management Server or just want to check it out, then here is how...
2011-08-09
968 reads
PASS Update #61
Just a few quick updates.
First, on the SQLSaturday site we’ll be shortly rolling out an updated logo and layout for...
2011-08-09
628 reads
Server Side Paging with new OFFSET feature in SQL Server Denali
Ever since I was a web developer back in the days, server side paging has been an issues. Back then...
2011-08-09
1,726 reads
SQL MCM Training – Day 1
Today was my first day of SQL MCM training here in Bellevue. We started at 08:30am
and now (05:30pm) Kimberly is...
2011-08-09
1,705 reads
Data Warehousing with SSIS
As a DBA why would I consider attending a pre-con by John Welch at SQL Saturday 89 titled Data Warehousing with...
2011-08-08
1,580 reads
Download free SSMS Add-In to create custom folders for database objects
I’ve just finished promised SSMS add-in which enables creating of custom folders directly in SSMS Object Explorer. Idea for add-in...
2011-08-08
3,189 reads
Droid Apps
A friend of mine recently got his first smart phone, an Android. My wife has also recently moved into the...
2011-08-08
769 reads
Excel Services in SharePoint 2010 Webinar
Tomorrow I will be presenting a webinar at 11 AM eastern time for the Pragmatic Works Training on the T’s. ...
2011-08-08
901 reads
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