Ten steps to migrate databases between servers in a .Net environment
How to move databases from one server to another with limited downtime
Granting limited permissions to create views in another schema in SQL Server - Part 2
In a previous tip, Granting limited permissions to create views in another schema in SQL Server, I showed how to use the CREATE VIEW permission and the ALTER SCHEMA permission to allow users to create new views using the same schema as the tables. However, I have found that the users can alter and drop tables in this schema which is beyond what I want them to do. A DENY CREATE TABLE does not work, so what can I do to prevent them from touching the tables in this way? In this tip I will show you how you can use a DDL trigger to prevent this unneeded access.
How SQL Server recovery models impact your SharePoint ...
SharePoint administrators can minimize data loss by selecting the appropriate SQL Server recovery model. But which model is right for your enterprise?
The Joy of Data Modelling.
You may think that the task of teasing out the exact nature
of the data and processes within a company...
Why Should You Network?
Networking is one of those things that so many people say is good for your career? But why? Steve Jones has a few examples today from his own experience.
Why Should You Network?
Networking is one of those things that so many people say is good for your career? But why? Steve Jones has a few examples today from his own experience.
Why Should You Network?
Networking is one of those things that so many people say is good for your career? But why? Steve Jones has a few examples today from his own experience.
Writing Technical Content for PASS
We’ve just posted our core guidelines for technical content on sqlpass.org. The short story is there are three main ways...
Anatomy of an Incremental Load
Microsoft MVP Andy Leonard brings us a great introduction to a common task for all DBAs: importing data. (from Feb 2008)
Choosing a FillFactor
Sharing how you do your job can help others be better at theirs. This Friday's poll asks a technical question. How do you determine which fillfactor to use.
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
BCA KCP Reg.Tanah Abang TLP/WA 08218573837
Ps. Regional Tanah Abang, Blok F, Lt. Dasar, Kp. Bali, Kecamatan Tanah Abang, Kota...
BCA KCP Pantai Indah Kapuk CSTelpon : 0853-73737551
CSTelpon : 0853-73737551 Jl. Pantai Indah Selatan Blok DF No.1 & 2, Kapuk Muara,...
BCA KCP Sahid Sudirman Residence TLP/WA 08216977701
Kantor Sahid Sudirman Residence, Jl. Jenderal Sudirman No.86 Lt. LG Unit 01, Karet Tengsin,...
Question of the Day
The Distance Metric
In the new VECTOR_DISTANCE() function in SQL Server 2025, the first parameter is the distance_metric. What is this?
See possible answers