2008-05-20
44 reads
Articles
2008-05-20
40 reads
What BI Practitioners Can Learn From Operations Research
Growing interest in analytics and the trend toward automated decision making will lead the business intelligence crowd toward the mix of mathematical and statistical techniques used by operations researchers.
2008-05-20
2,346 reads
Name Value Pair - Part II
In this article I will try to address some of the design suggestions and experiences that I had in managing similar database.
2008-05-19
7,856 reads
Pro SQL Server 2005 Integration Services
A look at this book from James Wightman and Apress on the ETL subsystem in SQL Server.
2008-05-19
1,871 reads
Tracking Database Schema Changes with DbPro
Tracking changes to your development environments is important to ensure that your deployments to production go smoothly. Jacob Sebastion brings us a look at how well the Visual Studio Team System Edition for Database Professionals can help you with this task.
2008-05-19 (first published: 2007-07-25)
6,578 reads
Full Text Search Noise Words and Thesaurus Configurations
I have heard that Full Text Search uses a noise words to eliminate meaningless words in searches. I have also heard that a thesaurus is used, but I am not exactly sure how. Can you provide some details related to how both of these technologies are used in Full Text Search? I am interested in more of a background on these specific Full Text Search technologies as well as where the files are located and how I can update them.
2008-05-19
2,630 reads
Who Built This Thing?
Do the people that build SQL Server really work with it? Steve Jones shares a short story from a recent trip to the Pacific Northwest.
2008-05-19
37 reads
Who Built This Thing?
Do the people that build SQL Server really work with it? Steve Jones shares a short story from a recent trip to the Pacific Northwest.
2008-05-19
52 reads
Who Built This Thing?
Do the people that build SQL Server really work with it? Steve Jones shares a short story from a recent trip to the Pacific Northwest.
2008-05-19
41 reads
Blogs
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...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Forums
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Creating JSON III
Comments posted to this topic are about the item Creating JSON III
Testing is Becoming More Important
Comments posted to this topic are about the item Testing is Becoming More Important
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