SQL Server Create Database Examples
In this article we look at different T-SQL examples to create a new SQL Server database.
Blocking Private Messages
A new feature on SQLServerCentral to allow you more control over who can contact you.
Move Data from SQL Server to Azure Blob Storage with Incremental Changes – Part 1
Learn how to get started uploading data from a SQL Server to Azure Blob Storage.
Quickly Find and Mask Sensitive Data with Data Masker 6.3.1
Khie Biggs, a software developer on the Data Masker team at Redgate, explains how a recent set of Data Masker improvements should make it significantly easier and faster both to determine what data needs to be masked, and then to apply the masking, to protect sensitive and personal data in the tables and columns of your SQL Server databases.
Storage 101: Welcome to the Wonderful World of Storage
Understanding all the storage options available to...
The New Year: A Chance to Start Over
January 1st is the beginning of a new year thanks to Julius Caesar and Pope Gregory XIII. This date is somewhat arbitrary, and many religions and cultures celebrate their own beginning of a new year at different times. Even though these celebrations don’t fall at the same time, I think the sentiment is similar. The […]
OUTPUT Clause Basics (For Inserts and Deletes)
When INSERTING or DELETING rows from a table, the OUTPUT clause can be used to return a dataset containing the changes made. Mat Richardson explains how.
The Best DBA Gifts
Today Steve asks if there is anything you'd want as a gift that would make your job better.
Do You Have REFERENCES?
The logic for referential integrity can be implemented in application code, but to make sure that it is enforced, include foreign key constraints in the database design instead. In this article, Joe Celko talks about the history of references in SQL and the options available today.
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCP Taman Palem Lestari Hub.0813•7887•595
BCA KCP Taman Palem Lestari Hub.0813•7887•595.Komp. Perum Jl. Taman Palem Lestari No.C5 No. 9...
BCA KCP Klampis No.Telp:087757645171
Whatsapp:087757645171 Ruko Sinar Galaxi, Jl. Klampis Jaya No.92-94, Klampis Ngasem, Kec. Sukolilo, Surabaya, Jawa...
BCA KCP Hasyim Ashari Telp:cs.(0821)8171955
Whatsapp:08218171955 Jl. KH. Hasyim Ashari No.5 AA, Petojo Utara, Kecamatan Gambir, Kota Jakarta Pusat,...
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