I’m presenting at the PASS SQL Saturday in Chicago
I have been selected to present at the SQL Saturday in Chicago on April 13th. This works out nicely as the...
2013-02-21
958 reads
James Serra's Blog
Using Team Foundation Service
Team Foundation Service (TFS) is the “cloud” version of Team Foundation Server 2012. Up to 5 users are free, plus for a...
2013-02-19
1,274 reads
“DBA: Transitioning to a BI Role” Presentation Slides
Thanks to everyone who attended my presentation “DBA: Transitioning to a BI Role” at the PASS Professional Development Virtual Chapter. The recording...
2013-02-14
1,757 reads
Introduction to Microsoft’s Master Data Services (MDS) Presentation Slides
Thanks to everyone who attended my presentation “Introduction to Microsoft’s Master Data Services (MDS)” at the Houston Area SQL Server User Group...
2013-02-13
1,894 reads
“DBA: Transitioning to a BI Role” Presentation
Tomorrow (Wednesday, Feb 13th) at Noon CST I will be presenting the session “DBA: Transitioning to a BI Role” at...
2013-02-12
753 reads
Introduction to Microsoft’s Master Data Services (MDS) Presentation
Tomorrow (Tuesday, Feb 12th) at 11:30am CST, I will be presenting the session “Introduction to Microsoft’s Master Data Services (MDS)” at...
2013-02-11
943 reads
24 Hours of PASS: Business Analytics Edition videos online
On January 30, BA and BI experts took to the virtual stage for the 24 Hours of PASS: Business Analytics Edition to...
2013-02-07
771 reads
Installing Team Foundation Server (TFS) 2012
My experience installing Team Foundation Server (TFS) 2012 to house my business intelligence projects built in Visual Studio 2010:
I am installing...
2013-02-05
6,016 reads
SSIS 2012: Empty toolbox?
This is an annoying problem I have had a few times: I open a SQL Server Integration Services (SSIS) project...
2013-01-29
5,065 reads
Missing Data Quality Service (DQS) buttons in Excel
The Master Data Services add-in for Excel has Data Quality Services functionality to help you match data before publishing it...
2013-01-24
1,369 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