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
841 reads
Blog Posts
Conferences & Presentations of 2014 in Review
Reviewing the year 2014, I can see that I have truly started improving my life by lowering the number of...
2014-12-18
425 reads
Nominated for the 2014 Tribal Awards
Just like last year, SQLServerCentral.com and Simple Talk are hosting the Tribal Awards. In their words:
The Tribal Awards, co-hosted by Simple-Talk and...
2014-12-18
853 reads
PASS – Connect, Share and Learn
The Professional Association of SQL Server (PASS) has a slogan for what they do – CONNECT, SHARE and LEARN. So, what...
2014-12-18
624 reads
T-SQL Tricks – Trigger Your Memory
I was scanning Twitter the other day and saw a note from someone that they had written a query using...
2014-12-18 (first published: 2014-12-11)
7,878 reads
2014 Tribal Awards Are Open
Yesterday morning I opened my email and was very pleased to find that I have been nominated for the 2014 Tribal...
2014-12-17
393 reads
Analytics Platform System (APS) AU3 released
The Analytics Platform System (APS), which is a renaming of the Parallel Data Warehouse (PDW), has just released an appliance update (AU3),...
2014-12-17
1,305 reads
Building Your First Windows Azure Machine
Recently, I had the pleasure of writing another article that was included the Notes From the Field series that is hosted...
2014-12-17
567 reads
Exam Prep 70-463: SSIS Connection Managers
This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing...
2014-12-17 (first published: 2014-12-11)
8,053 reads
SQL Konferenz
I’ve spoken at lots of events, but all in the US and the UK. Next year I get my first...
2014-12-17
802 reads
Blogs
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Forums
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers