SQL Compare 12 Beta
The Beta is out. I’ve been waiting for this, and was glad to see Carly’s post on the product. I’ve...
2016-06-06
1,342 reads
Blog Posts
SQLSaturday Iowa City is this weekend!
If you’re within driving distance of Iowa City, IA, I’d love to see you at SQLSaturday Iowa City this weekend!...
2016-06-06
435 reads
Why use a Date Dimension Table in a Data Warehouse
In the Data Mart, or the Data Warehouse world, there is a date dimension table in all schemas if you...
2016-06-06 (first published: 2016-05-29)
7,154 reads
SQL Server Admin Best Practices with DMV's at SQLSaturday Pensacola 2016
Great attendance and awesome questions from my 1130AM session on "SQL Server Admin Best Practices with DMV's". As promised, all...
2016-06-05
597 reads
Deletes Ignore Check Constraints
I know it sounds a bit odd but DELETE statements really do ignore table constraints. Running the code below in...
2016-06-03 (first published: 2016-05-30)
3,558 reads
How To Get A Free SQL Server Indexing Book – Week 1
Free indexing books, awesome! Before I tell you how, lets start with what we are talking about here. If you weren’t aware, last summer I worked with Grant Fritchey...
2016-06-03
14 reads
How To Get A Free SQL Server Indexing Book – Week 1
Free indexing books, awesome!
Before I tell you how, lets start with what we are talking about here. If you weren’t...
2016-06-03
484 reads
Reblog: Unexpected result with the File System Task
SQLKover update: nowadays you would probably use package parameters to pass the directory value. However, they still have a default...
2016-06-03 (first published: 2016-05-24)
1,184 reads
Attendee Questions from My #24HoP Presentation
I want to once again thank everyone who attended my 24 Hours of PASS session last week. I especially appreciate...
2016-06-02
794 reads
Restore a SQL Server Database with Different Methods
Database backups are generated as part of the business continuity planning procedure. Disasters with server or its database are a...
2016-06-02 (first published: 2016-05-28)
4,106 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