SSIS 2012 Design Patterns by Andy Leonard, Matt Masson, Tim Mitchell, Jessica Moss and Michelle Ufford
During my vacations at the end of 2014 I have finally finished a book on “SQL Server 2012 Integration Services...
2015-01-07
616 reads
Blog Posts
Using Power BI to access on-premise data
The following blog describes how to use certain cloud-based Power BI for Office 365 products (Power View and Q&A) on...
2015-01-07
2,232 reads
Execution Plans, Performance Tuning and Rum
This is me on the last cruise
In just a few more weeks I’ll be setting sail on the first of...
2015-01-06
1,083 reads
IT Pro Airlift 2015 Portugal – Microsoft Data Platform
On 22 of January 2015, Microsoft Portugal is organising a new IT Pro Airlift 2015 – – Microsoft Data Platform event. This...
2015-01-06
1,066 reads
Looking back on 2014
When a new year comes around it is always a great time to reflect on the previous year.
2014 was a...
2015-01-06
421 reads
Things I Learned in 2014
2015 is here!
Last year I wrote about what I had learned in 2013, and I try to make it a...
2015-01-06
756 reads
T-SQL Tuesday #62 - Invitation to HealthySQL
Greetings ALL and Happy New Year 2015! I wish everyone an excellent year ahead, and
that 2015 will bring peace and...
2015-01-06
5,911 reads
Using an alternate TypeScript compiler inside Visual Studio
TypeScript team member Daniel Rosenwasser provided instructions for replacing the TypeScript compiler and language service used by Visual Studio here:
https://github.com/Microsoft/TypeScript/issues/1110#issuecomment-62451204
He...
2015-01-06
1,167 reads
Website Updated
Over the Christmas holiday period the gethynellis.com website has had a bit of revamp.
In terms of what has changed,...
2015-01-06
407 reads
Beware of Login Issues for Privileged Accounts
In a recent post, I described an attack against a privileged account using a simple SQL Injection technique of updating...
2015-01-05
847 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