Indexed views on any core SQL server edition-The video
A few months back I created a blog post showing that you can indeed create and use indexed views on any core SQL server edition. It has proved to...
2015-10-10
3 reads
SQL Server Rocks!
SQL Server Contracting - The first 14 months (or so)
Crikey, where did that time go! I have been so busy adjusting to my new work life style I have...
2015-10-09
185 reads
SQL Server Contracting – The first 14 months (or so)
Crikey, where did that time go! I have been so busy adjusting to my new work life style I have completely neglected my blog.. Well now that I seem...
2015-10-09
6 reads
SQL Server Contracting – The first 14 months (or so)
Crikey, where did that time go! I have been so busy adjusting to my new work life style I have...
2015-10-16 (first published: 2015-10-07)
1,809 reads
XQuery – Accessing the Attributes Axis
Working with a sequence of attributes in XQuery is fairly straight forward with the “attribute” axis even if you don’t...
2014-12-26 (first published: 2014-12-19)
1,557 reads
XQuery - Accessing the Attributes Axis
Working with a sequence of attributes in XQuery is fairly straight forward with the 'attribute' axis even if you don't...
2014-12-19
842 reads
Updated blog Site
This post is mainly to test the syndication still works correctly from my heavily updated web/blog site so apologies for...
2014-11-12
416 reads
Updated blog Site
This post is mainly to test the syndication still works correctly from my heavily updated web/blog site so apologies for...
2014-11-12
148 reads
Creating cards in Trello via the REST API and parsing the returned JSON all in a SQL CLR
I recently blogged about how good I thought Trello was and shortly afterwards I found out that they did provide...
2014-11-12
299 reads
Drop and Recreate all Synonyms
Had a quick job the other day restoring a pair of databases under different names which is all straight forward...
2014-11-06 (first published: 2014-10-27)
18,755 reads
Blogs
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Forums
what data type i should use for roversion col and can i use less than greater
can i use Rowversioncol ( in my database it's synonyme timestamp is used) to...
Radius Latitude Longitude
I have a table with latitude longitude in the format. 45.123456 , -111.123456 ,...
degree of parallelism
Team, I'm trying to figure out what will be the best recommendation to configure...
Question of the Day
A Fun Computer Quote
Which movie featured this quote?
"All programs have a desire to be useful."Happy April Fools! See possible answers