In-Memory OLTP in SQL 2016

With SQL server 2016 around the corner, I would like to share some of my thought on the usage for...

You Have One Job

I’m sure most if not all of you are familiar with the meme “You had one job”. I was reminded...

Using the ScriptDom without losing comments

The ScriptDom is cool, it lets you parse T-SQL, play around with the AST (tree of statements) and then generate...

Using the ScriptDom without losing comments

The ScriptDom is cool, it lets you parse T-SQL, play around with the AST (tree of statements) and then generate T-SQL again (probably in a different format etc). This...

Using the ScriptDom without losing comments

The ScriptDom is cool, it lets you parse T-SQL, play around with the AST (tree of statements) and then generate...

Using the ScriptDom without losing comments

The ScriptDom is cool, it lets you parse T-SQL, play around with the AST (tree of statements) and then generate...

Calculating Table Partition Sizes in Advance

[read this post on Mr. Fox SQL blog] Continuing on with my Partitioning post series, this is part 7. The partitioning includes several major components of work (and can be linked...

Calculating Table Partition Sizes in Advance

[read this post on Mr. Fox SQL blog]
Continuing on with my Partitioning post series, this is part 7.
The partitioning includes several major...

Using multiple log files

The transaction log is made up of one or more files that are used sequentially. So in other words if...

Cumulative update package 9 for SQL Server 2012 SP2

Microsoft just announced Cumulative update package 9 for SQL Server 2012 SP2

Microsoft reference: [Click Here]

For more updates:
Subscribe for Blog posts [Click Here]
Follow...