Exploring SQL 2005’s Ranking Functions – NTILE() and ROW_NUMBER()
Part 20 of the "SqlCredit – Developing a Complete SQL Server OLTP Database Project" examines SQL 2005’s NTILE() and ROW_NUMBER() Ranking Functions.
Operations Manager: A Big Tinker Set
To illustrate the great possibilities of Systems Center Operations Manager 2007, Thomas shows how to create a Custom Monitor for SQL Agent Jobs, and concludes that Operations Manager is nothing more than a big tinker set.
Bootstrap
Steve Jones talks about starting your own business and some of the challenges and advantages.
Build Great Looking Excel Spreadsheets
Exporting data from your database and building reports is easy with Reporting Services, but sometimes you need to use other sources
SQL Server User Group in Luxembourg
A new SQL Server user group is starting up in Luxembourg. Be sure you read this if you are in the area and want to participate.
SQL Server Schema Binding and Indexed Views
How do you handle this error? "Cannot create index on view, because the view is not schema bound".
Super Sizing Columns in SQL Server
This article describes how to work with large objects in SQL Server using the MAX Specifier
Testing Service Pack 3
Who is responsible for Service Pack testing? Ultimately it's Microsoft, but Steve Jones reminds us we make a difference as well.
Testing Service Pack 3
Who is responsible for Service Pack testing? Ultimately it's Microsoft, but Steve Jones reminds us we make a difference as well.
Testing Service Pack 3
Who is responsible for Service Pack testing? Ultimately it's Microsoft, but Steve Jones reminds us we make a difference as well.
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 Tanah Abang Zona 3 Tlp/Wa 08216977701
Gedung Tanah Abang Zona III Lantai 3A L03A, Jl. KH. Fachrudin, Kp. Bali, Kecamatan...
BCA KCP Kramat Jaya Baru Tlp/WA 08216977701
Jl. Percetakan Negara II No.16 B-C, RT.3/RW.3, Johar Baru, Kec. Johar Baru, Kota Jakarta...
BCA KCP City Center TLP/WA 08216977701
Kawasan Terpadu Pusat Kota, Gedung Perkantoran Tower One, Lantai Dasar, Jl. KH Mas Mansyur...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers