Displaying blank sub report
Recently I had to convert a stand alone report into a sub-report. That report was very simple… it had two...
2011-10-28
1,041 reads
Blog Posts
How to hide Calculated Members in MDX SSAS
With some calculated members in MDX it only makes sense to see the calculation if a certain Hierarchy is used....
2011-10-28
2,516 reads
I/O Error On TempDB
I was running a DBCC CHECKDB on a database when I got an error that says:
Msg 0, Level 11, State...
2011-10-28
1,966 reads
PASS Summit 2001 In Review…WOW!!!
It has been a couple of weeks and I have had time to get back in the groove at a...
2011-10-28
1,703 reads
Play the Bob Ross Game
I was in a meeting a few weeks ago, deadlines looming and everyone feeling the stress some. We hit a...
2011-10-28
797 reads
Save a step: Using Computed Columns in a Table Variable (or Temp Table)
One of the databases that I support reports all money values in both the local currency and US Dollars. Very...
2011-10-28
15,197 reads
SQL Server Analysis Services Performance Guide published
Another must read white-paper: Analysis Services 2008 R2 Performance Guide.
This white paper describes how business intelligence developers can apply query...
2011-10-28
2,519 reads
Understanding Kerberos, Part III
Welcome back to both our Kerberos coverage and to another topic for SQL University's Security and Auditing Week. In today's...
2011-10-28
16,169 reads
Webinar on SQL Server Security on November 3, 2011
I have the privilege of being able to give a webinar next Thursday, November 3, at 11 AM EDT. It...
2011-10-28
1,007 reads
Presenting at SQL Saturday #87
On Saturday, October 29, 2011 at 2:45 pm, I’ll be presenting “Table Vars and Temp Tables – What you NEED to...
2011-10-27
700 reads
Blogs
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
A Las Vegas Break
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers