Identifying Blocking via Extended Events
There are a number of ways that you can identify blocking that is occurring in your SQL instance. You can...
2015-03-05 (first published: 2015-02-24)
10,215 reads
The DBA Who Came In From The Cold
Identifying Blocking via Extended Events
There are a number of ways that you can identify blocking that is occurring in your SQL instance. You can...
2015-02-24
352 reads
Collation Conflicts
I have recently seen some “bad plans” being generated by the optimiser and from investigation, the cause came down to...
2015-01-20
1,704 reads
Happy New Year 2015
I know it’s late but I’ve been away, I hope you all had a good Christmas and New Year.
I...
2015-01-05
634 reads
Book Review – SQL Server Internals: In-Memory OLTP by Kalen Delaney
The new SQL Server 2014 feature In-Memory OLTP (code-named “Hekaton”) has been attracting a lot of interest since its release,...
2014-12-09
1,770 reads
Video – Identifying large queries using Extended Events
A couple of weeks ago I was contacted by Webucator (an online training company) asking if they could use my...
2014-12-11 (first published: 2014-12-05)
2,359 reads
Blogging for a year!
I’m actually quite proud of the fact that I’ve now been doing this for a year now (and that I’m...
2014-11-07
435 reads
Cardinality Estimation in SQL Server
Each time you view a seek/scan operator in an execution plan, you may have noticed that there’s a value for...
2014-11-04
1,255 reads
Identifying large queries using Extended Events
Following on from my last blog post I now want to run through how to identify large queries using Extended...
2014-10-06 (first published: 2014-10-01)
12,119 reads
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,849 reads
Blogs
A New Word: Amoransia
By Steve Jones
amoransia – n. the melodramatic thrill of unrequited love; the longing to pine for...
The Data API Builder Start and Add Extensions in VS Code
By Steve Jones
One of the things that I like about the Data API Builder (DAB) is...
Using OneLake for Excel Files in Microsoft Fabric
By DataOnWheels
Hey data friends! This blog is to discuss an edge case I’ve run into...
Forums
Technical Pain Behaviors
Comments posted to this topic are about the item Technical Pain Behaviors
trying to call powershell from TSQL statement
Hello, trying to call a powershell file I created, locally on the server, but...
Counting Bits
Comments posted to this topic are about the item Counting Bits
Question of the Day
Counting Bits
What does the BIT_COUNT function do in SQL Server?
See possible answers