XML Attribute VS Element Assignment when working with SQL
XML handling with aliases
I find it interesting the difference in behavior with querying XML between column assignment, and quoted alias...
2015-09-21
294 reads
XML handling with aliases
I find it interesting the difference in behavior with querying XML between column assignment, and quoted alias...
2015-09-21
294 reads
XML handling with aliases
I find it interesting the difference in behavior with querying XML between column assignment, and quoted alias...
2015-09-21
185 reads
Split personality text editing in SSMS with Sublime Text 3
My preview post showed a demonstration of the multi-cursor editing power...
2015-09-14
188 reads
Split personality text editing in SSMS with Sublime Text 3
My preview post showed a demonstration of the multi-cursor editing power...
2015-09-14
1,070 reads
Yes… multicursor editing is epic No… SSMS doesn’t support multi-cursor editing the way it should. Yes… you can do some...
2015-09-10
1,829 reads
- Yes… multicursor editing is epic
- No… SSMS doesn’t support multi-cursor editing the way it should.
- Yes… you can do some...
2015-09-09
162 reads
It was entertaining to listen to a technical wizard fighting the obsession with waiting to eat chocolate with 3k viewers...
2015-08-27
301 reads
It was entertaining to listen to a technical wizard fighting the obsession with waiting to eat chocolate with 3k viewers...
2015-08-27
200 reads
Monitoring SQL Server on a budget
Cheap ain’t easy
There’s a lot of tools out there, and very few that are polished,...
2015-08-18
312 reads
Monitoring SQL Server on a budget
Cheap ain’t easy
There’s a lot of tools out there, and very few that are polished,...
2015-08-18
361 reads
In the realm of data science, SQL (Structured Query Language) reigns supreme. It's your...
By Brian Kelley
The bottom line here is this: the idea that a CSP takes care of...
In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your...
The below code works for backup files only from local drives. When replaced with...
I have been asked to fine-tune the following SQL that was written by a...
In this scenario, I seek assistance in implementing row-level permissions for a table named...
What are the initial config sizes for the tempdb primary data files, secondary data files, and log files in SQL Server 2022?
See possible answers