Finding DDL Triggers
Triggers are the types of objects in SQL Server that are easy to lose track of. There isn’t an obvious...
2012-09-13
10,980 reads
Blog Posts
Implementing a Data Warehouse with Microsoft SQL Server 2012 exam (70-463) – My Thoughts
Well I finally got around to completing the MCSA aspect of the SQL Server 2012 Certification and I’m pleased to...
2012-09-13
1,317 reads
Reading Reviews, Ordering a Laptop, and Lenovo
Since earlier this year I’ve been thinking to replace my aging but still useful laptop, mostly to get something lighter,...
2012-09-13 (first published: 2012-09-08)
1,878 reads
SQL Server: String Pattern Matching
It is common scenario that, we might need to extract the data from the SQL server based on some pattern....
2012-09-13
11,703 reads
Winner Winner Chicken Dinner!
I have spent a lot of time on the road this year with work but over the summer I was...
2012-09-13
648 reads
Yesterday I was hacked
That’s right, for all my years in IT yesterday I was the victim of a vicious and deeply distressing incident....
2012-09-13
1,046 reads
You don’t want to miss this out,Serious SQLServer training – 24 Hours of PASS event !
Back to back quality SQLServer sessions! Yes, you heard it right and that’s what 24 Hours of PASS is all...
2012-09-13
739 reads
Interview on RunAsRadio #281 with Richard Campbell
I recently had a chance to record a 33 minute podcast interview on RunAs Radio #281 with Richard Campbell, where...
2012-09-12
1,184 reads
Labor Day Bloopers
The raw footage of all the mistakes I’ve made since the Fourth of July.
Part 1
Part 2
Filed under: Blog Tagged: Humor,...
2012-09-12
1,001 reads
Master Data Services Terminology Overview
When moving from a data warehouse world to MDM, there is some new terminology to learn. Each of the terms...
2012-09-12
993 reads
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
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...
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