SQLBits XI recently announced
When I saw an email from SQLBits announcing SQLBits XI in East Midlands in my inbox this morning, it simply...
2012-11-14
817 reads
Art
Your online security is only as good as the weakest link
Over the weekend I received an email supposedly from Microsoft Live wanting me to verify my account and provided a...
2012-10-26 (first published: 2012-10-24)
1,653 reads
OVER() clause two simple ways on two different days
I’ve been aware of this clause in TSQL for a long time, but I’ve never really used it. Mainly because...
2012-09-26
1,060 reads
Suppressing namespace attributes in nested select statements when using FOR XML workaround
I was helping out on the forums the other day with a user who had stumbled across the quirk of...
2012-08-28
5,799 reads
Script to find orphaned/unreachable job steps within your SQL jobs
SQL jobs are great as the SQL agent job engine allows for very granular control over jobs that are created...
2012-08-23
2,370 reads
Using XQuery to transform multiple xml nodes to a single xml node with comma separated string value
Not another comma separated string blog post I hear you say! I know that this topic has probably been done...
2012-07-13
6,328 reads
Moving xml child elements to its parent using XQuery
I haven’t been able to do much XQuery development recently which is a shame as I love developing with the...
2012-07-09
4,261 reads
Unable to activate a Windows 2003 VM on Hyper-V behind a proxy
Ok, so this is not strictly a post about SQL itself (and it's about a fairly old OS), but I...
2012-06-25
2,653 reads
Shredding a simple xml structure to a single row flat table
I was helping out a user on the forums the other day where they were asking questions about shredding an...
2012-05-22 (first published: 2012-05-16)
5,327 reads
Command line to configure windows firewall for SQL server access
I regularly deploy SQL Server to new Windows Server 2008 hosts and one thing that I find quite a chore...
2012-05-10
2,955 reads
Blogs
You should be running on SQL Server 2022
It’s me again with my apparently semi-annual blog post. This time we’re going to...
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...
Forums
A Partial Count
Comments posted to this topic are about the item A Partial Count
The Stagnant Career
Comments posted to this topic are about the item The Stagnant Career
Stairway to Database DevOps Level 4: Creating a new Azure Pipeline (with Azure SQL DB Deployment)
Comments posted to this topic are about the item Stairway to Database DevOps Level...
Ask SSC