SSMS Masks Some Error Messages
So the other day I was working on a linked server problem where we wanted to run queries against a linked server to a SQL Server Analysis Services database so that a SQL Server stored procedure could hit the SSAS database directly. I was just running a sample query against a database that I knew […]
Recommended reading from mrdenny for January 25, 2013
This week I’ve found some great things for you to read. These are a few of my favorites that I’ve found this week. PASS Summit: What’s all the hype? Server Dump Teaching a Man to Fish With a Computer CTO Says Al-Khabaz Expulsion Shows CS Departments Stuck In “Pre-Internet Era” This weeks SQL Server […]
NOLOCK is not a turbo button
All to often when talking to developers they put the WITH (NOLOCK) table hint in place to speed up queries without understanding what the table hint does. I’ve even run across companies that have policies in place that every select statement must have the WITH (NOLOCK) table hint. The WITH (NOLOCK) table hint isn’t a […]
Recommended reading from mrdenny for January 18, 2013
This week I’ve found some great things for you to read. These are a few of my favorites that I’ve found this week. Learn to Speak DBA Slang VMware vCloud 5.1 Networking for dummies Backup File Naming Convention Another Java Exploit For Sale Windows 8 without Metro – Looks like this post was removed after […]