Recording Audio of Meetings
As a consultant I am often starting from the ground floor on a new data warehouse/business intelligence project, and usually...
2013-10-22
760 reads
James Serra's Blog
Presentation Slides for Transitioning to a BI role
Thanks to everyone who attended my session “Transitioning to a BI role” at the PASS SQL Saturday Charlotte. The abstract is below. Another...
2013-10-21
695 reads
Presentation Slides for Building an Effective Data Warehouse Architecture
Thanks to everyone who attended my session “Building an Effective Data Warehouse Architecture” at the PASS Summit 2013. The abstract is below. It...
2013-10-21
766 reads
PASS Summit 2013
The PASS Summit 2013 is almost here! Check out all the great sessions and speakers. I feel very fortunate to be able to speak...
2013-10-10
630 reads
Data Warehouse Maturity Model
I have talked about the Business Intelligence Maturity Model (see Business Intelligence Maturity Assessment), but I wanted to dig further into...
2013-10-08
2,210 reads
Does Business Intelligence equal Data Warehousing?
I have seen many times at clients where the terms business intelligence and data warehousing are used interchangeably. In reality, these...
2013-10-03
934 reads
I’m a Microsoft SQL Server Most Valuable Professional (MVP)!
I have been honored to be chosen a Microsoft SQL Server Most Valuable Professional (MVP). Here is a video on my...
2013-10-01
2,356 reads
SQL Server 2014: Partition Improvements
SQL Server 2014 has enhancements to two common database maintenance operations:Partition Switching and Online Index Rebuild. This will greatly increase...
2013-09-26
1,223 reads
Data Warehouse vs Master Data Managment
Sometimes I see confusion on the difference between a data warehouse (DW) and master data management (MDM). Below is a...
2013-09-24
1,447 reads
Power BI for Office 365 preview released
I first blogged about Power BI for Office 365 two months ago (see Power BI for Office 365) when it was...
2013-09-19
1,081 reads
Blogs
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
Monday Monitor Tips: A New Analysis Page
By Steve Jones
We have multiple teams (8) working on Redgate Monitor. Some work on the Standard...
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...
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