We’ve Got The Power: “Power BI”, New Microsoft BI Suite Announced
Power BI: a new suite of Business Intelligence tools Over the past few months, teams at Microsoft have made several...
2013-07-09
726 reads
SQL Server: Part 5 : All About SQL Server Statistics : How to Detect outdated Statistics ?
In the last post, we have discussed about the auto update statistics threshold and concluded that auto updated statistics threshold are good enough to get optimal performance in some workload. In...
2013-07-09
38 reads
SQL Server: Part 5 : All About SQL Server Statistics : How to Detect outdated Statistics ?
In the last post, we have discussed about the auto update statistics threshold and concluded that auto updated statistics threshold are good...
2013-07-08
1,636 reads
Run real-time SQL tracing at application level with a ORM….
If you ever need to know exactly what dml your application is running as you have an ORM as your...
2013-07-08
464 reads
Run real-time SQL tracing at application level with a ORM….
If you ever need to know exactly what dml your application is running as you have an ORM as your...
2013-07-08
473 reads
Last Weeks Top “Reading” Links #40
For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of...
2013-07-08
1,184 reads
Ordering steps in a SQL Agent job
Generally if I need to do any form of complicated control flow I’ll end up using SSIS, however there is...
2013-07-15 (first published: 2013-07-08)
2,200 reads
My 1st Blog – out of memory exceptions in SSDT… yes its technical
When unit testing a stored procedure in visual studio 2012 (SSDT); sometimes you can get a out of memory exception...
2013-07-08
443 reads
My 1st Blog – out of memory exceptions in SSDT… yes its technical
When unit testing a stored procedure in visual studio 2012 (SSDT); sometimes you can get a out of memory exception...
2013-07-08
979 reads
A Page-Splitting Headache - Page Split Mini-Series
Page splits are a normal occurring process in an OLTP system. However, too many page splits can cause performance issues...
2013-07-11 (first published: 2013-07-08)
9,764 reads
Blogs
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
Learning Tool – Deepstash
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
Forums
Understanding Temp Tables and Table Variables in SQL Server
Comments posted to this topic are about the item Understanding Temp Tables and Table...
The Data API Builder MCP Server Tools
Comments posted to this topic are about the item The Data API Builder MCP...
Collecting Data Is Hard
Comments posted to this topic are about the item Collecting Data Is Hard
Question of the Day
The Data API Builder MCP Server Tools
The Data API Builder MCP Server, v2.x, includes a number of tools. What actions can these tools perform in your database?
See possible answers