Introduction to Microsoft’s Master Data Services (MDS) Presentation
I will be presenting the session “Introduction to Microsoft’s Master Data Services (MDS)” at the Data Architecture Virtual Chapter on Thursday, Dec...
2012-12-17
784 reads
James Serra's Blog
SQL Server Data Tools (SSDT) – December 2012 update
SQL Server Data Tools (SSDT) has a new update:
VS 2010: December version: 10.3.21208.0, November version 10.3.21101.1, September version: 10.3.20905.0, initial version:...
2012-12-14
1,581 reads
Solution to VSTA editor error in SSIS 2012
The script task in SSIS 2012 is a great tool when you need to use C# or VB code to...
2012-12-13
3,668 reads
Can I use SSDT for the 2008 BI stack?
SQL Server Data Tools (SSDT) that was released with SQL Server 2012 obviously works with the BI stack (SSIS/SSAS/SSRS) for...
2012-12-11
2,417 reads
SQL Server Data Tools (SSDT) – November 2012 update
SQL Server Data Tools (SSDT) has a new update:
VS 2010: new version 10.3.21101.1, September version: 10.3.20905.0, initial version: 10.3.20225.0
VS 2012: new...
2012-12-06
2,987 reads
Power View for Multidimensional Models – Preview Available
Microsoft introduced an interactive data exploration, visualization and presentation experience called Power View with SQL Server 2012. Power View can only consume data...
2012-11-30
2,385 reads
Reasons not to upgrade to SQL Server 2012
As exciting as SQL Server 2012 is, with its multitude of new features, it’s not always possible to upgrade right...
2012-11-29
2,837 reads
Billing rates – other side of the fence
The following is a guest post by Tim Morgan from Sullexis in response to a resent blog of mine:
Thanks for letting...
2012-11-27
1,677 reads
Master Data Services Web Services API Error
In Master Data Services (MDS), I received an error when using C# code in the script task in SSIS 2012...
2012-11-20
1,048 reads
PASS 2012 Announcements
Some announcements and notes from the SQL PASS Summit 2012 last week (If you don’t know what PASS is, check out What is SQL...
2012-11-15
1,163 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