SQL Saturday #231 Cocoa Beach
Join us for a free day of SQL Server training and networking on July 27 in Cocoa Beach, Florida.
Parameter Sniffing and Sniffing Memory
This article aims to demonstrate bad parameter sniffing and its effects on memory grants.
The Desktop
Steve Jones talks about laptops and desktop machines, and the potential issues that IT professionals have with one or the other.
Using DAX to retrieve tabular data
Data Analysis Expressions (DAX), originally the formula language for PowerPivot workbooks, can also be used within the MDX query window of SSMS to directly access data from a tabular SSAS database, an in-memory database that uses the xVelocity analytics engine and compression. Robert Sheldon shows how easy it is to retrieve data from a tabular database.
Sending E-Mail from SQL 2008 Express
This article provides a comprehensive solution to sending email from SQL Express 2008 and Express 2008 R2.
The Vacation Struggle
It can be hard to take all your time off each year and Steve Jones is in that situation right now. However he reminds us that life is more important than work.
Security for SQL Server User Defined Data Types
I have a group of developers that I support and they are reporting they cannot see columns within their tables. I have granted them db_datareader permissions which is a standard at my company for QA environments. Why can't they see their column definitions? Check out this tip to learn more.
Dynamically Truncate a Partitioned Table
Wouldn't be great if you could truncate any partition of a partitioned table with one T-SQL statement? This article shows you how.
SQL Server: How Important Are Index Statistics
In this article Greg Larsen will show you how to identify when your index statistics were updated last, what method was used to gather statistics, and how to update your statistics.
Blogs
The DIY Cost of Masking Test Data For Smaller Organizations
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
T-SQL Tuesday #196 – Two risky career decisions I made
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
T-SQL Tuesday #192: What career risks have you taken?
This T-SQL Tuesday is hosted by the one and only James Serra – literally...
Forums
XACT_ABORT being set to ON by web services
We have two "identical" instances of an ASP.NET web service (or so I have...
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers