Recharged on the 4th of July
After a week of vacation, Steve Jones feels recharged and ready to head back to work. Today we celebrate the holiday with a blooper reel.
2009-07-05
497 reads
Articles
A Generic Process to Convert XML Data - Part 1
Longtime author Leo Peysakhovich brings us a new series on converting XML data into regular data. This article examines validating the XML data against a schema.
2009-07-03 (first published: 2008-08-25)
16,828 reads
Paying for Content - SQL Server Knowledge
Someone asked me recently if I subscribed to any services to keep up with SQL Server content. Meaning did I "pay" for content. I said "no" at first, but wanted to follow up with more details. Since this was across Twitter , 140 characters...
2009-07-03
1,442 reads
Remote BLOB Store Provider Library Implementation Specification
This is a specification to be used by those creating a storage provider plug-in library for the SQL Server 2008 Remote BLOB Store feature.
2009-07-03
1,269 reads
Taking Advantage of Sample Reporting Services Reports
Recent installments of our series dedicated to SQL Server 2005 Express Edition have discussed the Reporting Services component. This article provides an overview of sample reports that you can take advantage of in order to familiarize yourself with the more advanced graphical designer features present in SQL Server 2005 Express Edition-based Reporting Services.
2009-07-03
2,764 reads
Configuring SQL Agent Operators - SQL School Video
Operators in SQL Server work hand in hand to ensure that alerts are sent to the proper person. MVP Andy Warren shows how to set these up in this SQL School video.
2009-07-02
3,277 reads
Oracle for the SQL Server Guy - Instances and Databases
Many DBAs need to work with multiple platforms. New author Jagan Kumar brings us an article that helps to explain Oracle's architecture for those people used to working with SQL Server.
2009-07-02
10,794 reads
Avoiding the EAV of Destruction
A forum posting, from someone who wanted a better solution to the common problem of handling global settings in a database, leads Joe Celko into a fascinating discussion of the ramifications of the various solutions.
2009-07-02
2,239 reads
Move SQL Server transaction log files to a different location via T-SQL and SSMS
I am planning on moving the SQL Server log file of my production database on this drive. I am curious about how it will optimize the performance. What are some of the considerations I should take into account and how can I move the SQL Server database log file to a separate physical location?
2009-07-02
3,723 reads
Migrating A SQL Server 2005 Reporting Services Named Instance, The Missing Manual
Microsoft has always been pretty good at one thing, ease on install. One of the things I always says is the greatest thing about SQL Server is any idiot can install it. The other thing I also say is the worst thing about SQL Server is any idiot can install...
2009-07-01
4,332 reads
Blogs
Identity Columns Can’t Be Updated: #SQLNewBlogger
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Forums
Can someone please explain what happens?
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT) returns null when nothing is found instead of 0
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Question of the Day
Creating JSON III
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers