PASS Summit 2012 session videos online
All PASS Summit 2012 recordings are now available for free to all PASS members (201 of them!). To view, log on...
2014-03-27
787 reads
James Serra's Blog
Book: Reporting with Microsoft SQL Server 2012
I am happy to say I have published my first book! It is called Reporting with Microsoft SQL Server 2012...
2014-04-04 (first published: 2014-03-25)
3,861 reads
SQL Server 2014 released April 1st!
SQL Server 2014 has been released to manufacturers (RTM) and will be generally available April 1. Here is the official...
2014-03-20
1,127 reads
Parallel Data Warehouse (PDW) benefits made simple
I have heard people say that the Parallel Data Warehouse (PDW) is Microsoft’s best kept secret. So let me give a...
2014-03-18
2,457 reads
Real-time query access with PDW
The Parallel Data Warehouse (PDW) officially supports Analysis Services as a data source, both the Multidimensional model (ROLAP and MOLAP modes) and...
2014-03-13
1,550 reads
Book: Expert Cube Development with SSAS Multidimensional Models
Those of you who use SQL Server Analysis Services (SSAS) are likely familiar with the “bible” for designing cubes: Expert Cube...
2014-03-04
2,317 reads
Introduction to Hadoop
Hadoop was created by the Apache foundation as an open-source software framework capable of processing large amounts of heterogeneous data-sets in...
2014-03-11 (first published: 2014-02-27)
8,329 reads
What is HDInsight?
There are two flavors of HDInsight: Windows Azure HDInsight Service and Microsoft HDInsight Server for Windows (recently quietly killed but...
2014-02-25
2,087 reads
Annoying Recruiters
In a follow-up to my blog post Low-rate recruiters – The bane of my existence, Michael Bramante (website) wrote me a...
2014-02-20
1,297 reads
PolyBase explained
PolyBase is a new technology that integrates Microsoft’s MPP product, SQL Server Parallel Data Warehouse (PDW), with Hadoop. It is designed to...
2014-02-25 (first published: 2014-02-18)
18,171 reads
Blogs
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...
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
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