Effective Permissions on a Database
written by David Postlethwaite
Ever wondered who has what access to your database or a particular object within? With the ever...
2011-07-14
2,321 reads
Gethyn Ellis
We have a new contributor…
In order to keep the content fresh and the posts flowing here on my blog I have decided to publish...
2011-07-13
585 reads
Can you delete from a view?
I have seen this question come up several times over the last few months. Can you delete from a view?...
2011-07-11
57,625 reads
vCentre Useful Queries: Part II
After posting on twitter last week that I needed something to write a blog post about my good friend Christian...
2011-06-15
671 reads
vCentre Useful Queries: Part I
After posting on twitter last week that I needed something to write a blog post about my good friend Christian...
2011-06-14
840 reads
Planes Trains and Automobiles
I was going to write a short post showing some useful queries that can help you manage your vCentre environment,...
2011-06-10
474 reads
Calling all UK Bloggers…
Amazingly It’s been just over 4 months since I started my list of UK based SQL Server bloggers, and I...
2011-05-03
595 reads
A Royal Wedding: A Day Off
This is a little off topic:
Well Well, it’s the 29th April and all being well in about 2 hours from...
2011-04-29
1,527 reads
It’s a Deal, It’s a Steal…
Its the sale of the century. To coin a cleaned up phrase from a Guy Ritchie film (either Snatch or...
2011-04-27
641 reads
Microsoft Certification Exams: Costs are Increasing
It was announced yesterday that the cost of taking a Microsoft exam will increase from the 1 July. In the...
2011-04-27
2,391 reads
Blogs
Advice I Like: Ranch Rules
By Steve Jones
Leave a gate behind you the way you first found it. – from Excellent...
Fix Slow, Bloated MSDB: Purge Old History And Add Missing Indexes
By SQLPals
Fix Slow, Bloated MSDB: Purge Old History And Add Missing Indexes ...
Three Ways to Use Snowflake Data in Microsoft Fabric
By James Serra
Organizations increasingly want Snowflake and Microsoft Fabric to coexist without duplicating data or fragmenting...
Forums
You Have Homework
Comments posted to this topic are about the item You Have Homework
SSIS 2019 or 2022 - Microsoft Connector for Oracle
Hello all, I am having one heck of a time installing Microsoft Connector for...
bringing a .bak across the wire without rdp'ing or mapping into the sql server
hi, a peer of mine would like to be self sufficient in bringing small...
Question of the Day
The Query Optimizer and Page Density
If I have a fillfactor set to 70%, this reduces my page density to roughly 70%. Does this affect the query plans that the optimizer chooses?
See possible answers