Developers Rate Azure One of Their Favorite Tools
Yeah, Azure.
How we program, what we program and where we program is changing. All the time. This excellent article lays...
2013-09-09
1,275 reads
DMV-14 : Which Table has Max. rows & Size……..sys.dm_db_partition_stats
sys.dm_db_partition_stats DMV (Dynamic Management View), described by BOL as follows: http://msdn.microsoft.com/en-us/library/ms187737.aspx
Returns page and row-count information for every partition in the...
2013-09-09
974 reads
Junk Dimensions with no Loading Needed
When you are working with dimensional modeling there are some situations where several dimensional attributes don’t make since to be...
2013-09-09
1,788 reads
My 2013 PASS Suggestion Tsunami List
Back in August I posted about an approach that Aaron Nelson and I thought of to try to get more...
2013-09-09
798 reads
How do the fixed Database and Server roles map to more specific permissions?
I recently asked what the difference is between granting SELECT to a user (at a database level) and adding the...
2013-09-09
1,037 reads
2013-09-09
6 reads
70-457 Reviewer #12, Restoring SQL Server Databases
This lesson is the third and last part of topic for Managing Data which covers 20% of the certification exam....
2013-09-08
705 reads
A tour of the transaction log: Part 1 INSERT operations
The transaction log is a very important part of SQL Server. Every data modification operation is logged in the transaction...
2013-09-07
749 reads
Be Careful in Business
I like most of the SQL Server people I meet. Most of you are polite, cheerful, friendly, and it’s nice...
2013-09-06
863 reads
PowerShell – Delete Registry Entries – Remote Machines – Example Profile Deletion
#The following SID registry entry to be deleted across all mutiple Machines, SID is a user #who owns this user...
2013-09-06
2,664 reads
Blogs
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Tell It Once: Setting Up Claude With Skills and MCP Servers
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Forums
When And How to Automate?
Comments posted to this topic are about the item When And How to Automate?
Hyperscale Replicas II
Comments posted to this topic are about the item Hyperscale Replicas II
Practical Reporting Queries with CROSS APPLY (Part 3)
Comments posted to this topic are about the item Practical Reporting Queries with CROSS...
Question of the Day
Hyperscale Replicas II
How many Azure SQL DB Hyperscale HA replicas can be configured as of Sept 2026?
See possible answers