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
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
BCA KCP Kawi No.Telpon:083135765355
By CHERRYWIFARM- The Best CBD flowers Europe - Wholesale Hemp Flowers Europe
Whatsapp:083135765355 Jl. Kawi No.36, Gading Kasri, Kec. Klojen, Kota Malang, Jawa Timur 65116
BCA KCP Sukun No.Telpon:083135765355
By CHERRYWIFARM- The Best CBD flowers Europe - Wholesale Hemp Flowers Europe
Whatsapp:083135765355 Jl. S. Supriadi No.65, Sukun, Kec. Sukun, Kota Malang, Jawa Timur 65117
Question of the Day
May the Fourth Be With You Fun
In honor of May the fourth and Star Wars (may the force be with you), finish this quote:
"Do, or do not. ..."See possible answers