Software for Profit
Steve Jones will be attending the Business of Software conference in September and gives a few reasons why this is an interesting topic to him.
2008-07-13
86 reads
Articles
Software for Profit
Steve Jones will be attending the Business of Software conference in September and gives a few reasons why this is an interesting topic to him.
2008-07-13
63 reads
SQL Server 2005 Service Accounts
Are you aware that SQL Server 2005 can have up to ten services running? Working with that many service accounts can be a challenge. Steve Jones takes a look at these services and a few of the things that you will want to know before setting up SQL Server 2005.
2008-07-11 (first published: 2006-03-23)
50,585 reads
VBscript hacks for DTS packages
This article is about using VBscript hacks to overcome two limitations of DTS packages.
2008-07-11
9,681 reads
Intrinsic Member Properties: The MEMBER_KEY Property
Join BI Architect Bill Pearson in an introduction to the intrinsic MEMBER_KEY property. In hands-on exercises, we gain exposure to the use of the property in generating simple lists, as well as datasets to support report parameter picklists.
2008-07-11
2,077 reads
Microsoft Jet 4.0 Sorting APIs: DBCompareStringW and DBLCMapStringW
The Microsoft Jet 4.0 relational database engine utilizes character sorting tables when creating and querying field indexes made up of character data. Two Microsoft Windows APIs are generally utilized for this functionality:
2008-07-11
3,944 reads
The Database Weekly Update for July 14, 2008
Steve Jones talks about data mining in the drug industry and the advantages of cheap software.
2008-07-11
220 reads
The Database Weekly Update for July 14, 2008
Steve Jones talks about data mining in the drug industry and the advantages of cheap software.
2008-07-11
183 reads
The Database Weekly Update for July 14, 2008
Steve Jones will be attending the Business of Software conference in September and gives a few reasons why this is an interesting topic to him.
2008-07-11
219 reads
Building Parent-Child Table Tree information
How many times have you wanted to know which child or grandchild records exists for a parent record? SSMS doesn't make this information easy to find beyond one level. New author Narasimhan Jayachandran brings us an article and a recursive solution.
2008-07-10
12,323 reads
Blogs
Three Ways to Use Snowflake Data in Microsoft Fabric
By James Serra
Organizations increasingly want Snowflake and Microsoft Fabric to coexist without duplicating data or fragmenting...
Deploying an Updated Model with SQL Compare 16
By Steve Jones
In a previous post, I deployed a model to a database using SQL Compare...
Reality (And Limits) of Instant File Initialization for Transaction Logs in SQL Server 2022
By SQLPals
Reality (And Limits) of Instant File Initialization for Transaction Logs in SQL Server 2022 ...
Forums
Automating Database Cleanup for PostgreSQL Using Python
Comments posted to this topic are about the item Automating Database Cleanup for PostgreSQL...
The Query Optimizer and Page Density
Comments posted to this topic are about the item The Query Optimizer and Page...
There Are a Lot of Databases
Comments posted to this topic are about the item There Are a Lot of...
Question of the Day
The Query Optimizer and Page Density
If I have a fillfactor set to 70%, this reduces my page density to roughly 70%. Does this affect the query plans that the optimizer chooses?
See possible answers