Webcast Follow-Up: Choosing Your Clustered Index
Earlier this month, I presented a session for Pragmatic WorksTraining on the T’s on the selecting the clustered index for a...
2013-10-23
972 reads
PASS Summit 2014-Networking Dinner & After Hours
Yes, it is early, but I’ve set up the invitation for the fifth annual Monday Night Networking Dinner at the...
2013-10-23
749 reads
Unexpected truncation in FETCH
Yes I’m talking about FETCH as in a cursor, yes everyone hates cursors. But you know cursors are like anything...
2013-10-23
730 reads
Get list of dates using recursive Common Table Expression (CTE)
Many times we need a list of consecutive dates or time at runtime mainly for a recursive ETL process. This...
2013-10-23
1,122 reads
PASS Summit 2013 - Examples Package
I was asked by some attendees of my PASS 2013 Session, Unseen Minions : Improving parallel processing in SSIS, if I had any...
2013-10-22
455 reads
Quick note: Redgate SQL Data Compare using the command line
I’ve been working on an automated data compare process for one client. I’ve been struggling a little with odd hangups...
2013-10-22
1,148 reads
Windows 8.1 Upgrade Deletes VirtualBox Host-Only Network Adapter
Windows 8.1 was released to the Windows Store last week and aside from having to download the same 3.9 GB...
2013-10-22
1,209 reads
Back to basics: Transact-SQL programming fundamentals – (Part 2)
In the first of this three-part series, you will learned how to use scripts and batches, and basics of T-SQL...
2013-10-22
1,220 reads
Back to basics: Transact-SQL programming fundamentals – (Part 1)
SQL Server users use Transact-SQL programming to create sets of statements for ad-hoc execution. The aim of the Transact-SQL programming...
2013-10-22
1,139 reads
Children at Technical Conferences
I have had the pleasure of taking my son with me on a number of trips where I was a...
2013-10-22
833 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