Identifying large queries using Server Side Traces
Who are your worst offenders? By offenders I mean, queries that are consuming the most resources on your server(s).
I know...
2014-09-17 (first published: 2014-09-11)
7,873 reads
SQL – List Primary key and Concatenate composite Keys into a single row separed by comma
The following query lists all the Primary keys of all the table.
OP has requested to list all PK and composite...
2014-09-16 (first published: 2014-09-10)
7,118 reads
VMworld 2014 Wrap Up for Data Professionals
A few weeks ago I was fortunate enough to attend VMware’s VMworld 2014 conference in San Francisco, CA. The show...
2014-09-10
494 reads
September 2014 Las Vegas UG Meeting
Who is up for a little free learning this week? Besides the opulence and feast that was the 24 Hours of PASS (Summit Preview), we have more training in...
2014-09-10
5 reads
September 2014 Las Vegas UG Meeting
Who is up for a little free learning this week? Besides the opulence and feast that was the 24 Hours...
2014-09-10
673 reads
Statistics in SQL Server
I’ve put together a new Curah! of links to some of the better articles on SQL Server Statistics, specifically those...
2014-09-15 (first published: 2014-09-10)
7,399 reads
T-SQL Tuesday #58 – Security Phrases
Today is once again TSQL Tuesday. This month the event and topic are being hosted by Sebastian Meine (blog | twitter). You can read all about the topic this...
2014-09-09
8 reads
T-SQL Tuesday #58 – Security Phrases
Today is once again TSQL Tuesday. This month the event and topic are being hosted by Sebastian Meine (blog | twitter)....
2014-09-12 (first published: 2014-09-09)
6,523 reads
Untested
The 2014 Apple keynote was today, with the announcement of the iPhone 6 and iWatch taking center stage. I was...
2014-09-09
782 reads
[Off-Topic] Beating Childhood Cancer
Note: I feel this post is important enough to post across all my blogs.
September is Childhood Cancer Awareness Month here...
2014-09-09
553 reads
Blogs
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Forums
Four Rules for Adding AI Without Breaking What Already Works
Comments posted to this topic are about the item Four Rules for Adding AI...
SQL Server 2025 section missing?
Hello, the title says it all. Is the SQL Server 2025 section missing?
A design question in a parent child relationship
I am not sure which is the best way to proceed. I have parent...
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers