Data Distribution - Part 1
The start of a new series from Leo Peysakhovich that looks at some of the issues with moving data around between systems and ensuring that it is in sync between them.
Software Vendor Security
This week Steve Jones finds some issues with the security of third party vendor software.
Thinking Time
It's important to have time to think, but quite often we don't find the time. Steve Jones comments on how he's learned just how valuable this can be.
Top Ten Reasons to Attend the 2010 PASS Community Summit
There are some good reasons to think about attending the 2010 PASS Community Summit.
TSQL Challenge 35 - Find the total number of 'Full Attendees' in 24HOP
This challenge has a (fake) reference to the 24 Hours of PASS event and your task is to count the number of attendees who watched the complete presentation of each speaker.
SQL Server CRUD-Generation from System Views
If you are not keen on repetitive typing, you can still rapidly produce production-quality documented code by planning ahead and using Extended properties, and system views. Phil Factor explains, with some Scary SQL
Missing Indexes in SQL Server 2005
Determining which columns to index in a table used to be a very time consuming process that was as much art as science. New author Ranga Narasimhan brings us an article that shows how SQL Server 2005 makes this much easier.
ROWE
ROWE stands for a Results Oriented Work Environment. This Friday Steve Jones asks if you'd like to work in one.
For SQL Server 2005/2008, Consider SecurityAdmin = SysAdmin
In a recent thread here on SQL Server Central, it was pointed out that a member of the securityadmin fixed...
Oracle to SQL Server, Crossing the Great Divide, Part 3
We soon learn, in SQL Server, that heaps are a bad thing, without necessarily understanding how or why. Jonathan Lewis is an Oracle expert who doesn't like to take such strictures for granted, especially when they don't apply to Oracle. Jonathan discovers much about how SQL Server places data, and concludes from his experiments that heaps perform badly in SQL Server because you cannot specify a fill factor for them.
Blogs
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Forums
BCA KCP Pluit Samudra Tlpn/Wa 0853.7373.7551
Jl. Raya Pluit Utara. 85 Blok E Kav. No. 11, RT.4/RW.5, Pluit, Kecamatan Penjaringan,...
BCA KCP Tebet Timur Telpon/WA:08137887595
BCA KCP Tebet Timur Telpon/WA:08137887595.Jl. Tebet Timur Dalam Raya Blok GG No. 97, Tebet...
BCA KCP Gading Riviera Tlpn/Wa 0853.7373.7551
Jl. Raya Kelapa Hibrida, Ruko, Jl. Gading Riviera Raya No.10 Blok PF 21, Daerah...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers