This, the first in a series of three articles, describes the history of information workers and discusses their characteristics. The next article will describe how to leverage the latest BI technologies, and the final article will address how to improve information consumability.
2009-11-03
2,375 reads
This tip is going to cover recommendations related to the SQL Server Destination Adapter, asynchronous transformations, DefaultBufferMaxSize and DefaultBufferMaxRows, BufferTempStoragePath and BLOBTempStoragePath as well as the DelayValidation property.
2009-11-03
6,012 reads
For those of you still using SQL Server 2000, learn how to use SQL-DMO to create DML scripts to deploy new records or data changes to other servers. From Oscar Garcia.
2009-11-02
3,472 reads
In the first installment of this discussion, I talked about the challenges facing database professionals and others with respect to...
2009-11-02
2,304 reads
There are many ways to perform disaster recovery with Microsoft SQL Server Reporting Services (SSRS). Based upon customer experience and internal testing, this technical note provides guidance around best practices to design and manage robust end-to-end disaster recovery (DR). This DR method will involve both automatic and manual failover in the form of content switches, SQL Server failover clustering, and database mirroring. This case study focuses on the lessons learned from CareGroup Healthcare System.
2009-11-02
2,310 reads
This paper discusses the integration of SAP NetWeaver BI ® with Microsoft ® SQL Server ® 2008 Reporting Services (SSRS). The paper provides an overview of using the Reporting Services SAP Netweaver BI data provider and related query designer, to build high quality reports against SAP NetWeaver BI sources. For Reporting Services users who are new to working with SAP NetWeaver BI, this paper will help you connect and build datasets. For users already familiar with SAP NetWeaver, the paper will show how some of that system’s notable features can be leveraged in Reporting Services reports. It also presents some tips and tricks that can help you make the most of the integration between the two products.
2009-11-02
2,111 reads
One of the very common things that is needed in SQL Server is performing a restore of a database. It's also one of the most important things that needs to take place. So why isn't this a simpler process? Steve Jones wonders why we can't make this a simpler process.
2009-11-02
493 reads
One of the very common things that is needed in SQL Server is performing a restore of a database. It's also one of the most important things that needs to take place. So why isn't this a simpler process? Steve Jones wonders why we can't make this a simpler process.
2009-11-02
577 reads
One of the very common things that is needed in SQL Server is performing a restore of a database. It's also one of the most important things that needs to take place. So why isn't this a simpler process? Steve Jones wonders why we can't make this a simpler process.
2009-11-02
546 reads
How can you delete only some duplicates? Without Identity's, Temp tables, Cursors, loops or ROW_NUMBER()? Would you believe, go back to the 70's?
2009-10-30 (first published: 2008-08-05)
32,587 reads
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
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