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,323 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
587 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,637 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
673 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
477 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,528 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
643 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,392 reads
Blogs
“We love to debate minutiae”
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
Advice I Like: Knots
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
Forums
Windows logins for users migrated from DomainA to DomainB
Hi, I have a SQL Server instance where users connect to via Windows Authentication,...
Multiple Deployment Processes
Comments posted to this topic are about the item Multiple Deployment Processes
How to Use sqlpackage to Detect Schema Drift Between Azure SQL Databases
Comments posted to this topic are about the item How to Use sqlpackage to...
Question of the Day
Upgrading Admin Queries
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers