Identify the cause of SQL Server blocking
In my previous article (Different techniques to identify blocking in SQL Server) on MSSQLTips.com, I discussed about locks and blocks,...
2013-04-24
913 reads
The Public Role – a potential high risk security concern for DBAs
The public role is a special fixed-database role, which exists in every SQL Server database. The public role is different from all other database-level...
2013-04-24
11,150 reads
SQL Server index related dynamic management views and functions (Part 2)
SQL Server uses indexes to sort and organize table data. It creates indexes based on ordering values from one or...
2013-04-24
789 reads
The 200 Billion Dollar Tweet
Hello Dear Reader! Ever try to convince someone that they should be paying attention to Twitter? A co-worker, Vice President...
2013-04-24
1,139 reads
Building My HDInsight Server Cluster
After all the hype about Big Data, Hadoop, and now HDInsight, I decided to build out my own big data...
2013-04-24
974 reads
SQL Power Doc Update - Version 1.0.1.0
A quick note to let you know that SQL Power Doc version 1.0.1.0 is now live. This release fixes issues...
2013-04-24
1,040 reads
How do I tell the stored procedure name from inside the stored procedure?
I’ve occasionally had the problem of trying to put “smart” logging messages into a process. You know the ones, you’re...
2013-04-24
836 reads
Estimate Table Size based on the Metadata from INFORMATION_SCHEMA.COLUMNS
A problem I face often is not knowing the size of a new table that I’m creating. I put some...
2013-04-24
721 reads
VMworld Presentation Voting – I Would Appreciate Your Votes
This year is the first year that I have submitted a session to VMware’sVMworld 2013, to be held in San...
2013-04-24
613 reads
Looking Back
In July 2011 I took what felt like a big chance and a detour to lead a large and complex...
2013-04-24
739 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