Database Snapshot and Rollback Transactions
A Rolled back transaction will increase the snapshot sparse file usage. New author Subash brings us an examination of how those database snapshots actually work.
Being Supportive
Steve Jones says we need to stick together in IT, at least from the perspective of the client. Otherwise we can all look bad as an industry.
Being Supportive
Steve Jones says we need to stick together in IT, at least from the perspective of the client. Otherwise we can all look bad as an industry.
Being Supportive
Steve Jones says we need to stick together in IT, at least from the perspective of the client. Otherwise we can all look bad as an industry.
Data searches that leverage existing indexes
Recent installments of our SQL Server 2005 Express Edition series have been discussing its implementation of Full Text Indexing. This article focuses on data searches, which leverage existing indexes, taking into account such features as noise words and thesaurus files.
Logging with SQL Server
This article from Ed Swiedler looks at using SQL Server to log activity from various sources. Service Broker and Windows Services are used to create a generic logging service that will build log files for you to examine outside of any application.
Women in Technology
A guest editorial from Phil Factor today that points out some of the incredibly contributions by women in technology.
Transfer database schema objects and data to another server/database with SMO
In this tip, I am going to show you how you can use SMO (SQL Server Management Objects) classes to transfer database objects and data to another server or database.
Slipping out of the DBA trenches
Today we have a guest editorial from Rodney Landrum who wonders how DBA Managers, removed from the front lines, can keep up to date and retain their edge. Is it inevitable that, slowly but inexorably, they will feel the 'blunting of the blade'?
Those Stubborn Database Rules - Finding Them and Scripting Them
Scripting out database rules to help you remove them from your database solutions.
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 Mal Taman Anggrek Tlpn/wa0853.7373-7551
Tlpn/wa0853.7373-7551 Jl. Letjen S. Parman No.Kav. 21 Lower Ground Lot. C 07, Slipi, Kec....
BCA KCU TANJUNG PINANG TLP/WA 08216977749
Jl. Sunaryo, Kemboja, Kec. Tanjungpinang Bar., Kota Tanjung Pinang, Kepulauan Riau 29112
There's Too Much to Learn
Comments posted to this topic are about the item There's Too Much to Learn
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers