Using XQuery to remove duplicate values or duplicate nodes from an xml instance
Sometimes we need to retrieve a list distinct values from within an xml instance or even distinct nodes and this...
2012-12-20 (first published: 2012-12-13)
19,558 reads
The Great DBA Getaway
Free, at last!
It’s holiday season which means it’s a time for you all to buy me gifts super busy time for Data...
2012-12-12
1,036 reads
PASSMN–Passing the Baton: A Board Transition Story
Each year the Minnesota SQL Server User Group elects new board members and resets its leadership team. I have been...
2012-12-12
775 reads
Working with Excel Destinations in SSIS - 0xC0202025, 0x80040E21
Working with Excel in SSIS is not fun and something I whole-heartedly discourage. With that said, I had a not...
2012-12-12
1,526 reads
You Need to Manage Passwords
I saw a note this week from CNet about a system built to crack passwords (also on ArsTechnica). It reminded...
2012-12-18 (first published: 2012-12-12)
2,735 reads
Where is my backup?
We recently added responsibility for ~80 more servers to our team. This means that my team-mates and I are working...
2012-12-19 (first published: 2012-12-12)
2,043 reads
The Surface Meta-App
Just a quick little blog post about one more app you’re going to want to track down for your Surface....
2012-12-12
958 reads
TSQL Tuesday #37 – Joins and Implicit Conversions
Here we are at TSQL Tuesday #37 – the start of the fourth year. Sebastian Meine (@sqlity / blog) is hosting this...
2012-12-11
2,016 reads
SQL Server 2012 security: Changes for the newest version
Database infrastructure security is extremely crucial for any organization, which is why Microsoft has invested heavily in SQL Server security...
2012-12-11
1,190 reads
Does my SQL Server database use any Edition specific features?
Today, I received a phone call from a friend who is thinking to downgrade the database hosted in SQL Server...
2012-12-11
678 reads
Blogs
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Local Models Using GPUs with Ollama
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
Forums
Absolute and Relative References
Comments posted to this topic are about the item Absolute and Relative References
Moving Beyond the Reboot: Finding the Culprit Behind Memory Pressure
Comments posted to this topic are about the item Moving Beyond the Reboot: Finding...
Reserved Words I
Comments posted to this topic are about the item Reserved Words I