2013-03-26 (first published: 2013-03-15)
837 reads
Scripts
Monitor current transactions and get all required information
Check which transactions are running, query text, percent complete , query_plan, wait_type, and how long they have been running etc. - with one command.
2013-03-25 (first published: 2013-03-15)
2,334 reads
Powershell - Document your environment
This script is an improvement from my original script entitled "Powershell - Query SQL Servers Operating system details".
2013-03-22 (first published: 2013-02-27)
2,439 reads
2013-03-21 (first published: 2013-02-27)
1,287 reads
2013-03-19 (first published: 2013-03-01)
1,096 reads
Script to get max dates on tables that contain a certain column.
This script will allow you to get maximum date associated with tables that contain a certain column.
2013-03-18 (first published: 2013-02-22)
1,203 reads
2013-03-15 (first published: 2013-02-21)
7,943 reads
2013-03-11 (first published: 2013-02-20)
2,226 reads
2013-03-08 (first published: 2009-10-02)
3,422 reads
SQL 2012 Always On Status Report
This script will produce a report on the status of the Always On replication.
2013-03-05 (first published: 2013-02-08)
4,119 reads
Blogs
How I Built RAG for My Accounting App on Bedrock and pgvector
The first version of my accounting assistant could not find a single purchase of...
Why AI isn’t paying off yet, and what to invest in first
Why isn’t AI paying off yet? Drawing on lessons from digital transformation, Joyful Craftsmen...
Flyway Tips: Analytics Platforms (Snowflake and Databricks)
By Steve Jones
I’m really excited about some growth in Flyway support. I’ve been asking about this...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Slow - Linked server query
Hi I have this slow query that is pulling data from a linked server....
Too Many Choices
Comments posted to this topic are about the item Too Many Choices
Question of the Day
Too Many Choices
I have a table, dbo.MasterBrands, with this data:
BrandID OfficialName 1 Samsung 2 Apple 3 Microsoft 4 Adidas 5 Coca-ColaI run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel') FROM dbo.MasterBrands;See possible answers