SQL – Find encrypted objects using sql_modules or Powershell
sys.sql_modules catalog view which got introduced from SQL 2005 onwards. The sql_modules which includes the objects of type P, RF, V, TR, FN, IF, TF,...
2014-04-14
740 reads
SQL – Find encrypted objects using sql_modules or Powershell
sys.sql_modules catalog view which got introduced from SQL 2005 onwards. The sql_modules which includes the objects of type P, RF, V, TR, FN, IF, TF,...
2014-04-14
833 reads
SQL Server – How To Find SQL Virtual Name From Host Name in SQL Failover Clustering Using PowerShell
Often times it is required to find out the SQL name from the host names in a clustered environment so you...
2014-04-14
1,180 reads
Oracle Tips for MSBI Devs #6: Supporting SSAS Tabular Development
As SQL Server Analysis Services Tabular Models become more popular, models will use Oracle databases as sources. One of the...
2014-04-14
1,125 reads
Last Weeks Top “Reading” Links #79
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-04-14
718 reads
It’s Not All About The Keys–Question Of The Day
My latest question is live today, called It’s Not All About The Keys. It’s a three pointer, if score matters...
2014-04-14
440 reads
Sharing a Good Idea
I posted earlier about my experiments with Microsoft Curah!. (yes, technically the period should follow the exclamation since the exclamation...
2014-04-14
585 reads
MidnightDBA at SQL Saturday Houston – May 10
Sean and I will be speaking at SQL Saturday Houston on May 10, at San Jacinto College – South Campus 13735...
2014-04-14
648 reads
Collation: Correction -> Instance
I had a recent run in with collation problems and it got me started reading about them. As I read...
2014-04-14
463 reads
Collation: Correction -> Instance
I had a recent run in with collation problems and it got me started reading about them. As I read...
2014-04-14
668 reads
Blogs
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
Forums
Practical Ways to Approach SQL Server Problems and Case Studies
Working with SQL Server can involve more than just writing queries. Understanding database design,...
Measuring Productivity
Comments posted to this topic are about the item Measuring Productivity
Importing Excel files into SQL Server using DuckDB and Python
Comments posted to this topic are about the item Importing Excel files into SQL...
Question of the Day
Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers