Understanding the SQL Server SELECT @@VERSION command
Check out this tip to learn about the SELECT @@VERSION command in SQL Server.
2011-12-30
4,818 reads
Articles
An Introduction to Integration Services log providers
SSIS features log-providers that can write to five different types of logging destinations; three of them are files, one is the 'dbo.sysssislog' table, and the last is the Windows Event Log.
2011-12-29
4,346 reads
2011-12-29 (first published: 2010-06-09)
8,899 reads
Great SQL Server Debates: Lock Pages in Memory
There has been much debate over the need for the Lock Pages in Memory privilege, on 64-bit versions of SQL Server. Jonathan Kehayias presents a "warts and all" account of its history, the confusions surrounding its use, and why he believes it's still a good default configuration for 64-bit SQL Server instances, even when running Windows Server 2008 and Windows Server 2008R2.
2011-12-29
2,878 reads
Writing New Hash Functions for SQL Server
This blog, explores ideas for extending SQL Server with new, fast hash functions. As will be shown, the high speed, built in functions CHECKSUM and BINARY_CHECKSUM are not always optimal hash functions, when you require the function to spread data evenly over an integer space.
2011-12-28
2,595 reads
Mirroring and different sector sizes? BAD IDEA!
Be carefull when replacing a defective (FLASH) storage device, its sector sizes may vary without you knowing it.
2011-12-27
4,645 reads
2011-12-27 (first published: 2010-06-02)
11,234 reads
Options to reinitialize subscriptions in SQL Server replication
I have transactional replication configured in my production environment with multiple subscribers. The business team has requested that one of the subscriptions be reinitialized, because they think there is some missing data. In this tip we look at the different options that you can use to reinitialize a subscription for transactional replication.
2011-12-27
2,872 reads
2011-12-26
59 reads
Pros and cons of six SQL table tools
This article shows how to use 6 SQL table-based tools to solve the same problem, and gives the pros and cons of each.
2011-12-26
10,118 reads
Blogs
VPN + SQL Server Connections: Why Long-Working Setups Suddenly Fail with Msg 10054 and “Connection Broken”
By Tim Radney
Over the past few weeks, I’ve been contacted by multiple customers experiencing the same...
Future IT Roles – Agentic Architect and AI Boom!!
By Vinay Thakur
These days everything is changing to AI World, IT roles are getting changed and...
Free Webinar about Columnstore Indexes
I’m doing a small series on indexing basics for SQL Server, and on May...
Forums
BCA KCP Saharjo Hubungi Cs.0851•8812•0691
BCA KCP Saharjo Hubungi Cs.0851•8812•0691 Jl. Dr. Saharjo No.149 G-H, Manggarai Sel., Kec. Tebet,...
Call Center Batik Air 24 jam Bebas Pulsa
Anda bisa menghubungi Call Center Batik Air Bebas Pulsa Melalui WhatsApp 0838 97 00...
BCA KCU MUARA KARANG TLP/WA 08216366654
Jl. Muara Karang Timur, Blok B VIII No.116-117, Daerah Khusus Ibukota Jakarta 14450
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers