Nested Display Folders in SSAS
Recently it was announced that Power BI would now support the SSAS display folders in “exploration mode”. Exploration mode is...
2016-03-16
1,108 reads
Blog Posts
SQL Server 2016 RC0–Management Studio install option has disappeared
If you are trying to install SQL Server 2016 RC0 – which I’m sure you are all doing looking at the...
2016-03-16
727 reads
SQL Server articles
Between attending SQL SKILLS immersion events, trying out for the PFE role at Microsoft I have managed to write some...
2016-03-16
187 reads
SQL Source Control v5.0 Beta–First Migration Script
I joined the beta program for SQL Source Control recently. I know, I work for Redgate, I should be in...
2016-03-16
923 reads
Time Management–Leadership
To many times data professionals flounder in what some call a pool of uncertainty. The countless tasks, tickets, projects, and emails...
2016-03-16
484 reads
What permissions do I need?
Ever wondered how to tell what permissions are required to run a statement or perform a task? Well, sometimes it...
2016-03-16
476 reads
You don’t need to be a sysadmin
Hey, I need sysadmin access to ServerA.
Ok. Why do you need sysadmin?
Well I need to be able to read and...
2016-03-16 (first published: 2016-03-10)
2,321 reads
Annual Business Intelligence Survey
This is a reminder to compete the annual Business Intelligence product survey conducted by BARC Research. I’ve been participating in...
2016-03-15
459 reads
Compression Performance with Low Key Selectivity
[read this post on Mr. Fox SQL blog] When it comes to enabling data compression in SQL Server I suspect most people don’t do a lot of testing as to the impacts of...
2016-03-15
11 reads
Compression Performance with Low Key Selectivity
[read this post on Mr. Fox SQL blog]
When it comes to enabling data compression in SQL Server I suspect most people don’t do a...
2016-03-15
570 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