DAX IsFiltered Function
The DAX IsFiltered function returns True when <columnName> is filtered directly and false if there is no direct filter on...
2012-10-11
2,044 reads
Grant Execute Permission on All Stored Procedures
Right out of the box, SQL Server makes it pretty easy to grant SELECT, INSERT, UPDATE, and DELETE to all...
2012-10-10
13,573 reads
Gain exclusive control of a database
Last night a client tried to ruin a script to enable Read_Committed_snapshot on a SQL database. There were so many...
2012-10-10
574 reads
SQL Server:Understanding The Page Free Space (PFS) Page
In my earlier post, we have discussed about GAM and SGAM Page and Data Page. In this postlet us discuss about...
2012-10-10
6,417 reads
X-XMLA: vii. Partition Management with XMLA
In the 7th article of this series, I will discuss how to manage your partitions with XMLA. We will be...
2012-10-10
647 reads
Lose #5 Before #sqlpass
Win Valuable Prizes!
Impress Your Friends!
This week we’re starting up a health and weight loss competition that I hereby dub #PASSGameOn,...
2012-10-10
979 reads
PASS 2012 Countdown – 4 Weeks To Go
One week down and we are now 4-weeks from this years PASS Summit. Hopefully, you have already registered for the...
2012-10-10
1,142 reads
Update with UPDLOCK
Do you think it’s a good idea to add UPDLOCK hint to the table which will be modified in an...
2012-10-10
1,466 reads
Auditing changes in Merge Replication
One trick I have learned from the folks on the Replication Support Team is how to proactively audit data changes...
2012-10-17 (first published: 2012-10-10)
2,943 reads
Generate Uniqueidentifier with SSIS
If you are trying to generate Uniqueidentifier/Newid() in SSIS data flow, you will soon realize that there is no out-of-the-box...
2012-10-16 (first published: 2012-10-10)
11,559 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
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
Choose the Second One
Comments posted to this topic are about the item Choose the Second One
Question of the Day
DML Trigger Types
How many types of DML triggers are there?
See possible answers