SQL Server :Part 1 : Architecture of Transaction Log
In our earlier post, we have discussed in detail about the architecture of the data file and different types of...
2013-09-30
10,021 reads
SQL Saturday #190 Denver Wrap Up
I must admit… Denver is my favorite town in this country. The outdoor things to do, the wide variety of...
2013-09-30
1,266 reads
Last Weeks Top “Reading” Links #51
Monday morning and it’s time for weekly round-up. If you follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet...
2013-09-30
1,491 reads
An Experiment Concludes
That was hard work
You may or may not have noticed, but every single week day for the month of September,...
2013-09-30
1,598 reads
Cumulative Update – 6 for SQL Server 2012 Service Pack 1 Is Now Available !
The 6th cumulative update release for SQL Server 2012 Service Pack 1 is now available. Cumulative Update 6 contains all...
2013-09-30
1,215 reads
The MERGE statement doesn’t have a WHERE clause.
What the heck? Even indexes have WHERE clauses these days. I can’t remember what I was reading when I saw...
2013-09-30
1,367 reads
MDX YTD Calculation Issus
If you are using the templates for MDX calculation built into SSAS 2008 you might run into some strange issues....
2013-09-30
1,258 reads
Speaking Twice on Oct 1, 2013
Carolina Technology Conference:
To start things off, I'll be speaking in the morning at the Carolina Technology Conference. I have a...
2013-09-30
2,815 reads
Disaster Recovery and Business Continuity
Fires, SAN failures, tornados, and car accidents all came up today, yet it was a very good day at work. ...
2013-10-04 (first published: 2013-09-30)
2,174 reads
SQL Server Statistics
INTRODUCTION
Statistics contain information about the data. How the data is distributed inside the table. They are representation of a table....
2013-09-29
3,982 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