A big issue when try to Alter user define table type structure TIP #108
I hope all of you aware of User define table type (a table value parameter) which we discussed earlier in...
2015-08-08
1,342 reads
Blog Posts
#PowerBI and #SSAS Tabular: A Natural Fit with the Power BI SSAS Connector
In late June last month, the Microsoft Power BI team released the Microsoft Power BI Analysis Services Connector. The Power...
2015-08-07
1,094 reads
Another Career Podcast – Working at Microsoft
I have to admit, I had a lot of fun at SQL Saturday in Philly this last June; I mean...
2015-08-07
495 reads
Career Progression
Deciding to change jobs can be one of the most difficult decisions you can make. At Dell I was part...
2015-08-07
490 reads
Grant’s Fly-by-night Leadership Course – The Plan
Get a better nameDefine my personal goals for the courseI won’t be sharing these with you. I may share them...
2015-08-07 (first published: 2015-07-28)
1,885 reads
HealthySQL – A Review
A quick look into the book by Robert Pearl: Healthy SQL.
Related Posts:
My Book Contributions November 30, 2018
Profiler for Extended Events: Quick Settings March 5, 2018
How to be...
2015-08-07
9 reads
Machine Learning Data Sets
Machine Learning Data Sets
When starting out with data mining and machine learning you will need to have access to sample...
2015-08-07 (first published: 2015-08-04)
2,879 reads
SET NOEXEC is my new friend
Have never really played around with the option: SET NOEXEC ON
Turns out this can be a helpful way to validate...
2015-08-07
3,602 reads
Speaking at SQLSaturday Omaha
In just one week, I’ll be traveling west to Omaha to speak at SQLSaturday there. It’s been a while since...
2015-08-07
401 reads
SQL Sentry Grows in the UK and Beyond
Announcing two new UK-based SQL Sentry global technology evangelists. Please help me welcome John Martin and Richard Douglas.
The post SQL Sentry Grows in the UK and Beyond appeared first...
2015-08-07
13 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