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
1 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
438 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
170 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
1 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,543 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
329 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
266 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
406 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
142 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)
17,293 reads
Blogs
Removing a PowerShell Array Element–#SQLNewBlogger
By Steve Jones
I saw an article on this and realized I had no idea how to...
PostgreSQL Backup Failure
In this blog post I wrote a tip about fixing the PostgreSQL backup failure...
Dynamic Data Masking – SQL Server
By Tim Radney
Use Dynamic Data Masking to protect your data The post Dynamic Data Masking – SQL...
Forums
Need help with the query
How do I add 0 in the beginning but the length of the value...
GitHub Copilot - Our Best Ally for T-SQL
Comments posted to this topic are about the item GitHub Copilot - Our Best...
Lead Updates Not Working, Only Rendering Nulls
I hav a table that holds sports betting lines that i am using in...
Ask SSC