Creating a deep hierarchy with FOR XML
I have two tables in an application that I support. One is called [Report], and the other is [ReportParameter].
--SAMPLE...
2011-01-27
18,918 reads
Using the MERGE statement
I love MERGE. You know all those awful IF BEGIN END ELSE BEGIN END blocks you need to write for...
2011-01-17
4,067 reads
Wiring up a common click event handler in an ASP.NET page
I was just refactoring a server-side control and ran into some horrible code. Basicaly there was a big listbox that...
2010-12-30
3,105 reads
How to tell if a property exists by name
I recently was working on a library to manage reports in an application (probably a good candidate for an open source project)...
2010-12-29
670 reads
Blogs
Limiting Results with TEXTSIZE in SQL Server: #SQLNewBlogger
By Steve Jones
There is a SET command in SQL Server that changes how much data is...
Secret management using Pulumi ESC SDK and Azure Key Vault
This is a submission for the Pulumi Deploy and Document Challenge: Shhh, It’s a Secret!What...
The Book of Redgate–Being Reasonable
By Steve Jones
As a part of the Book of Redgate, we have a series of (red,...
Forums
install sql express
I yesterday dowload a sqlexpress and intalled on one of a testing database for...
The User Login
Comments posted to this topic are about the item The User Login
Using Feature Flags
Comments posted to this topic are about the item Using Feature Flags
Question of the Day
The User Login
When I create a user in a SQL Server 2022 database, on which types of logins in the master database can it be based?
See possible answers