DMV Emergency Room!
I had the opportunity to present DMV Emergency Room! at SQLSaturday #169 in Denver, Colorado on September 22, 2012.
I...
2012-09-23
1,147 reads
Blog Posts
Notes from the 2012 Tampa IT Pro Camp & Some Misc Thoughts
I drove down Saturday morning to do a beginner presentation on SQL Security. Event was hosted at Rasmussen College, great...
2012-09-23
672 reads
2012 Fall & Winter Conference Sessions
Fall is a busy time for speaking engagements which include user groups, SQL Saturdays and the PASS Global Summit. I'm...
2012-09-22
713 reads
Automated Disk Space Alerts For Windows Server
PowerShell Style
I recently needed to automate disk alerts for each of our servers, to keep it simple I wrote a...
2012-09-22
113 reads
Connection String from Visual Studio
Querying Microsoft SQL Server : Connection String from Visual Studio: Connection String: A connection string contains connection information need to connect...
2012-09-22
886 reads
Data Types in SQL Server
Querying Microsoft SQL Server : Data Types in SQL Server: Data Type Description Remarks BIGINT Used for large Integer data.(Range -2^63 ...
2012-09-22
395 reads
Error Handling in T-SQL
Error Handling in T-SQL: Error handling in T-SQL: Error handling in T-SQL is similer to other programming languages as C#,C++,Java.A...
2012-09-22
626 reads
Functions in SQL Server
Functions in SQL Server: Functions in SQL Server In SQL Server functions are subrotienes that encapsulate a group of T-SQL...
2012-09-22
603 reads
Vacation and SQLSat149
When I was considering submitting some sessions to SQL Saturday 149 in Minnesota I thought I would have a difficult...
2012-09-22
801 reads
VMware vSphere 5.1 vCenter Data Protection Funny
VMware, why won’t you allow special characters in your root password?
Tweet
2012-09-22
590 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