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
2 reads
Art
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...
2015-10-10
450 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-09
183 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
5 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,556 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
839 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
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
413 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
147 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,711 reads
Blogs
Monday Monitor Tips: Learning While Using the Tool
By Steve Jones
A customer was asking about what certain items in Redgate Monitor mean. They have...
Act on Your Certification Test Results
By Brian Kelley
Pass or fail, act on your certification test results.
Catching Up On SQLOrlando
By Andy Warren
Somehow two years have elapsed since my last update; hopefully it won’t be that...
Forums
Switch partition: NULL boundary id
I have table: t1 in schema1 with 19 billion records. I have another table...
Minimally Viable Security
Comments posted to this topic are about the item Minimally Viable Security
Encoding NULL
Comments posted to this topic are about the item Encoding NULL
Question of the Day
Encoding NULL
What is returned from this code in SQL Server 2025?
SELECT BASE64_ENCODE(NULL)See possible answers