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,802 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
804 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,047 reads
2013-09-09
13 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
712 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
759 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,666 reads
Reblog: August 30 to September 5
I’ve always been a fan of the feeling when I find an old blog post that’s got just the information...
2013-09-06
848 reads
Speaker of the Month: September 2013
This is my second post in what I hope will be an ongoing series. You can see the rules for...
2013-09-06
870 reads
Blogs
A Pursuit of Lifelong Learning
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
Advice I Like: Time and Focus
By Steve Jones
“You don’t need more time because you already have all the time that you...
Book Review: Microsoft 365 Copilot and Agent Administration Fundamentals
I don’t currently manage Microsoft 365 Copilot in an enterprise environment, but it is...
Forums
What Did Healthy Look Like?
Comments posted to this topic are about the item What Did Healthy Look Like?
DML Trigger Types
Comments posted to this topic are about the item DML Trigger Types
PostgreSQL in action with Opensearch
Comments posted to this topic are about the item PostgreSQL in action with Opensearch
Question of the Day
DML Trigger Types
How many types of DML triggers are there?
See possible answers