Benefits of using views in a BI solution
Using SQL Server views throughout a Business Intelligence (BI) solution can provide a tremendous amount of benefits. Here is a...
2013-03-19
734 reads
James Serra's Blog
Why you need Business Intelligence
First lets define what Business Intelligence (BI) is. My favorite definitions:
Forrester Research: “Business Intelligence is a set of methodologies, processes,...
2013-03-14
2,053 reads
Top BI Enhancements for SQL Server 2012 Presentation Slides
Thanks to everyone who attended my session “Top BI Enhancements for SQL Server 2012” at the Houston Area SQL Server User Group Monthly Meeting.
Here...
2013-03-13
997 reads
Parallel Data Warehouse (PDW) Version 2
Version 2 of Parallel Data Warehouse (PDW) is apparently due this month (and can be ordered as of March 1st). The official...
2013-03-12
2,707 reads
Top BI Enhancements for SQL Server 2012 Presentation
Next Tuesday, March 12th at 1:15pm CST, I will be presenting the session “Top BI Enhancements for SQL Server 2012” at...
2013-03-08
832 reads
Profisee Master Data Maestro
I have been using Microsoft’s Master Data Services (MDS) on a daily basis for the last 8 months. I also...
2013-03-07
3,107 reads
Visual Studio 2012 now supports BI!
My most popular blog has been Visual Studio 2012 does not support BI. In short, this means VS 2012 does...
2013-03-06
2,793 reads
Microsoft Data Explorer
Data Explorer (download), which I first mentioned in my blog about PASS Summit 2011 (SQL Server 2012 and other PASS...
2013-03-05
1,983 reads
Data Warehouse Architecture Presentation Slides
Thanks to everyone who attended my session “Data Warehouse Architecture” to the PASS DBA virtual chapter. There were over 200 attendees! The recording of...
2013-02-28
1,626 reads
Data Warehouse Architecture Presentation
I will be presenting the session “Data Warehouse Architecture” this Wednesday, Feb 27th at 11:00am CST to the PASS DBA virtual...
2013-02-26
946 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