Data Warehouse Architecture Presentation Slides
Thanks to everyone who attended my “Data Warehouse Architecture” presentation to the South Florida PASS chapter.
Here is the PowerPoint presentation: Data Warehouse...
2012-11-15
1,693 reads
James Serra's Blog
Dell Quickstart Data Warehouse Appliance 2000
As a follow-up to my blog Dell Quickstart Data Warehouse Appliance for SQL Server 2012, Dell announced the availability of the second...
2012-11-13
901 reads
Data Warehouse Architecture Presentation
I will be presenting the session “Data Warehouse Architecture” to the South Florida PASS chapter on Wednesday, Nov 14th, at...
2012-11-12
1,030 reads
SSIS: Execute SQL task vs Execute T-SQL Statement task
In SSIS there are two tasks than can be used to execute SQL statements: Execute T-SQL Statement and Execute SQL....
2012-11-08
16,364 reads
Problem copying large files to a USB flash drive?
I thought I would write a quick blog on a problem I see frequently: You try to copy a large...
2012-11-06
1,003 reads
Jumping from SSIS 2008 to SSIS 2012
Being a long-time SSIS 2008 developer, I have been working with SSIS 2012 for the past few months, and I...
2012-11-01
2,494 reads
SQL Server 2012: New Business Intelligence features
SQL Server 2012 has many new Business Intelligence (BI) features and enhancements. Here are my top 12, in order of...
2012-10-30
8,661 reads
Using PerformancePoint against tabular data
PerformancePoint (PPS) is typically used against multidimensional data sources (i.e. Analysis Services), but it does have the ability, albeit limited, to work against...
2012-10-25
2,888 reads
Master Data Services (MDS): Miscellaneous tips
I have come across a number of tips while using MDS. These are tips not big enough for their own...
2012-10-23
9,215 reads
Should a placement firm tell you what they are billing the client?
As a 1099 consultant, I usually use a placement firm to find a contract job. I always ask the placement...
2012-10-18
1,191 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