Removing a DDL Trigger
In a recent post I talked about how to create a DDL trigger. You’d think to drop that trigger, I’d...
2012-08-07
951 reads
SQL Server: List Explicit Permission on Database for Login and Database Role
As part of security audit of login's, we have discussed earlier about the orphan users , listing server level and database level role...
2012-08-07
5,498 reads
Colorado SQL - August 2012
This month Kevin Kline will be presenting "End to End Troubleshooting" at the Boulder, Colorado Springs, and Denver SQL Meetings
Summary:...
2012-08-07
642 reads
SQL Server 2012 Diagnostic Information Queries (August 2012)
Here is the August 2012 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements...
2012-08-07
1,043 reads
PASS Update #2 - February 2012 Recap
During the January board meeting we were told that attendance at the 2011 Summit exceeded expectations and as a result...
2012-08-07
630 reads
PASS Update #1 - January 2012 Recap
When I ran for the PASS Board of Directors last year I committed to providing a monthly update on PASS...
2012-08-07
965 reads
View Flat File Contents Using PowerShell
We have all been there; you need to take a look at the data inside a file. Sure you can...
2012-08-07
1,784 reads
Book Review: On Writing A Memoir of the Craft by Stephen King
I just finished this book. Literally. Sitting on an airplane in route from Orlando to Charlotte NC. I got up...
2012-08-07
1,017 reads
Can I still buy per socket licenses for installing SQL2008 R2 ?
Many times I have seen this question coming from users - Can I still buy per socket licenses for installing SQL2008...
2012-08-07
741 reads
SQL Server: How Recursive Common Table Expression (CTE) Works ?
Last Friday evening, I forced to look into a procedure which is using Recursive Common Table (CTE) . The procedure was...
2012-08-06
12,293 reads
Blogs
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Forums
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Execute as failure
Security has long been a problem for me. Every time I think I understand...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers