The risks of Delayed Durability
It’s T-SQL Tuesday again and this month we are hosted by Jens Vestergaard (b/t) who want’s us to talk about...
2016-04-18 (first published: 2016-04-12)
1,696 reads
It’s T-SQL Tuesday again and this month we are hosted by Jens Vestergaard (b/t) who want’s us to talk about...
2016-04-18 (first published: 2016-04-12)
1,696 reads
Happy Tuesday . Here's the latest technology based blogs and articles I have been reading this week. Mainly SQL Server themed...
2016-04-12
391 reads
If you are a SQL Server professional and are interested in spending a day with a bunch of other like-minded...
2016-04-12
115 reads
It finally comes to this date, 12th April 2016, the end of support for SQL server 2005! SQL 2005 is...
2016-04-12
692 reads
SQL Server 2005 is now out of support. I remember going to a SQL Server 2005 launch event at the...
2016-04-11
406 reads
One of my blog reader requested me to get the DB details(Server,DBName,Size,SpaceAvailable,LogSize,PercentUsed Log Space,compatiblilty mode, recovery model etc:-) using PowerShell...
2016-04-18 (first published: 2016-04-11)
1,501 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2016-04-15 (first published: 2016-04-11)
2,354 reads
I spoke at Visual Studio Live in Vegas on two topics. While the presentations have been uploaded to the site and were...
2016-04-11
426 reads
var sum = 0; db.getMongo().getDBs()[“databases”].forEach(function(x) { sum += db.getMongo().getDB(x.name).stats().dataSize }); print(sum );
OR
db = db.getSiblingDB(“admin”);
dbs = db.runCommand({ “listDatabases”: 1 }).databases;
var sum1=0;dbs.forEach(function(database) { sum1+=db.getMongo().getDB(database.name).stats().dataSize }); print(sum1);
2016-04-11
449 reads
Sometime we need to know how much table space are used to store the data and also wish to know...
2016-04-11
177 reads
By Steve Jones
I wrote about Flyway Desktop Object History in a previous tip. This feature has...
By Arun Sirpal
AgentDBA (the database agent I have been building) has more than 1000 automated tests,...
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
Comments posted to this topic are about the item Server-level Roles
Comments posted to this topic are about the item Pay for Performance
Comments posted to this topic are about the item Tracking Inserted, Updated, and Deleted...
In SQL Server 2025, can I alter a fixed server role?
See possible answers