Power BI Q&A Preview now works on your data
As I mentioned in Power BI first impressions, Power BI Q&A is an instantaneous search experience that uses a natural language query....
2014-01-02
728 reads
James Serra's Blog
Entity Data Modeling with Visual Studio
While there are a lot of tools out there for data modeling, there is one option that is free if...
2013-12-30 (first published: 2013-12-26)
13,057 reads
Power Query load settings
One point of confusion I see with Power Query is some people believe Power Query adheres to the Excel limit...
2013-12-23
1,397 reads
I’m presenting at the PASS Business Analytics Conference
I am fortunate enough to have been selected to give a presentation at the PASS Business Analytics Conference in San Jose, CA...
2013-12-19
654 reads
Power Query Preview December Update
Microsoft keep turning out updates to Power Query. For December, some of the new features (download):
Connection to three more data...
2013-12-17
951 reads
Power BI for Office 365 FAQ
As I have been giving demos on Power BI for Office 365, I have received a tremendous amount of positive feedback,...
2013-12-12
1,781 reads
Certification Updates for SQL Server 2014
Info from Microsoft on how the MCSA and MCSE certifications will be altered for SQL Server 2014:
In reviewing the SQL...
2013-12-10
5,410 reads
Power Query Preview November Update
As I mentioned in my previous post (see Power BI first impressions), Power Query is a great new tool and Microsoft...
2013-12-05
1,507 reads
Power BI for Office 365 requirements
“Power BI” is an umbrella name for a lot of products, which I explain at Power BI first impressions (also I have...
2013-12-12 (first published: 2013-12-03)
3,458 reads
SQL Server Data Tools (SSDT) – October 2013 update
Since my last post about the SSDT update for August, there have been two updates, each containing one fix:
The September...
2013-11-26
1,198 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