Talking Career and Unstructured Data
The Denver SQL Saturday is coming in less than two weeks, SQL Saturday #169 is our second event in Denver,...
2012-09-11
939 reads
Blog Posts
T-SQL Tuesday – Help! I Need Somebody
By Jennifer Salvo
Today is T-SQL Tuesday #34 hosted by Rob Volk (B, T). This month’s topic is ‘Help! I Need...
2012-09-11
889 reads
T-SQL Tuesday #34 – Help! I Need Somebody
I couldn’t resist, so here goes….
Help, I need some data,
Help, not just any data,
Help, I was told you...
2012-09-11
985 reads
Colorado SQL - September 2012
COLORADO SPRINGS SQL
September 19, 2012 at 5:30 p.m.
Meeting Location: Hyatt Place - Garden of the Gods, 503 West Garden of the Gods...
2012-09-10
872 reads
Demystifying SQL Server Differential Database Backups
Odd Man Out
SQL Server has three backup types. Two you have heard of and used. One, while useful, isn’t very well understood.
Let’s...
2012-09-10 (first published: 2012-09-06)
2,803 reads
EXECUTE AS USER = ‘Somebody else’
As a database administrator I get lots of security requests. “Please grant me read authority on this table, write on that table,...
2012-09-10
744 reads
Have You Seen This Error?
location: AppendOnlyVerStoreMgr.cpp:776
Expression: 0
SPID: 64
Process ID: 4912
Description: Cannot locate version record and page is not allocated. Status = 3
Msg 3624, Level 20,...
2012-09-10
1,351 reads
Master Data Services: Changing a model with a subscription view
I have been working heavily with Microsoft Data Services (MDS) in SQL Server 2012 over the past few months, and...
2012-09-10
2,624 reads
No Full Outer Join in Access
Recently I needed to help a colleague with a small inventory true up task. We needed to know items that...
2012-09-10
794 reads
PASS ProfDev VC presentation recording available
Back on August 15th I did a webinar for the PASS Professional Development virtual chapter on my talk Being the...
2012-09-10
1,131 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
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
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?...
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