People That Get It Done
Today we have a guest editorial from Andy Warren. This one follows on from his "are you easy to work with" piece.
Why SHRINKFILE is a very bad thing, and what to do about it.
This article talks about why SHRINKFILE is a very bad thing, and what to do about it if you must shrink a database file.
Building Ranges using T-SQL
We often use excel for any running repetitive calculations since it is a very convenient user friendly interface which allows us to just enter a formula in a cell and simply drag and drop the formulas to generate a complete output.
Careful with your Smartphone
Do you connect to your work network with your smartphone? If so, you should be careful and ensure you are taking precautions to prevent any security issues.
Jeff Moden: DBA of the Day
Jeff Moden's election to the Exceptional DBA of the Year award for 2011 was a popular one. Although all the finalists were exceptional, Jeff has impressed everyone with his energy, stamina and wit, particularly with his work on SQL Server Central. In conversation with Richard Morris, Jeff comes up with several nuggets of advice and opinion that are valuable for any DBA or database developer.
PASS Data Architecture VC presents Row Versioned Data Warehouses with Jeremy Huppatz
On Thursday December 15th at 8PM Pacific, Jeremy will discuss the strengths and disadvantages of a row-versioned data warehouse design in the context of a real world case study, sharing lessons learnt and demonstrating some of the technologies and techniques used to build a row-versioned data warehouse
Propose this to your boss
If you would like to tackle an interesting project at work or find yourself something new to do next year, read this idea from Steve Jones.
Stairway to T-SQL DML Level 6: The Basics of Sorting Data Using the ORDER BY Clause
In this Level you will see how to use the ORDER BY clause to return your data in a sorted order.
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 Kepa Duri Tlpn/wa0853.7373-7551
Jl. Mangga Raya No.20, Duri Kepa, Kec. Kb. Jeruk, Kota Jakarta Barat, Daerah Khusus...
Layanan Call Center Batik Air 24 jam
Layanan Call Center Batik Air 24 jam Info. Saluran Resmi Customer service Batik Air...
BCA KCP Fatmawati Hubungi Cs.0851•8812•0691
BCA KCP Fatmawati Hubungi Cs.0851•8812•0691 Jl. Komp. Rs. Fatmawati No.1, Cilandak Bar., Kec. Cilandak,...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers