How to Create a Reporting Services 2005/2008 Template
At most large companies one business requirement is that all reports have the same look and feel. This may vary...
2009-11-20
12,569 reads
Blog Posts
I’m Missing Data
One of the things that I thought about doing after the 2008 PASS Summit was to bring someone along with...
2009-11-20
704 reads
MDX, DMX, and XMLA Templates
One of the most underused features in SSMS is the additional templates that are available for MDX, DMX, and XMLA....
2009-11-20
3,127 reads
PASS Summit 2009 Final Thoughts…or What I've Learned From The 2009 Summit
Last week I wrote a day by day recount of my PASS Summit experience (Monday, Tuesday, Wednesday, Thursday, Friday). Since...
2009-11-20
714 reads
Should DBAs have local administrator rights?
This was actually spurred by a post from Ted Krueger (@onpnt), which led to a short, but hearty, discussion on...
2009-11-20
14,009 reads
SQL Job Ownership Article on SSC.Com
Today, Please see my featured article appearing on SQLServerCentral.com discussing SQL Agent Job Ownership.
Have you ever had a situation...
2009-11-19
628 reads
Book Review: The Cleaner
I read The Deceived a few weeks back and enjoyed it, even though it was the 2nd book in the...
2009-11-19
499 reads
Licensing For Everyone
I used to really try not to over-license in the small companies I worked at. It seems I’d spend a...
2009-11-19
788 reads
Load Windows 7 with a Thumb Drive
With the explosion of Netbooks, it has become important to find new ways to load operating systems. I recently picked...
2009-11-19
395 reads
PDC 2009 Laptop Giveaway
During Steven Sinofsky’s keynote address at PDC09 today, he started telling a story about how some of the engineers in...
2009-11-19
1,022 reads
Blogs
Case Studies: Real-World Success Stories of FinOps Implementation
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
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...
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