SQL Lighthouse
Red Gate is constantly experimenting with technology. Because of a long history working within the Microsoft space, a lot of...
2013-09-19
824 reads
Introduction to Integrity: Data Purity Errors
The final day of this six part series, Introduction to Integrity, sponsored by Idera and their new free tool SQL...
2013-09-19
1,114 reads
What to do next certification wise
I feel rather flat today. I passed the 3rd entry level 2012 exam a few hours ago, data warehousing to...
2013-09-19
711 reads
Hit Fast Forward: Converting and deploying DTS packages
This one is just a quick shout-out to Pragmatic Works, and to Sean. Pragmatic Works made DTS xChange, which I...
2013-09-19
526 reads
How to Split a string by delimited char in SQL Server..............
However I posted this one in one of my post.
Querying Microsoft SQL Server : Functions in SQL Server: Functions in SQL...
2013-09-19
628,666 reads
Extract DacPac Using Command Line
When extracting Dacpacs it’s quite straightforward to go through the UI and extract, however what if you want to do this for more than one database, or automate the...
2013-09-19
56 reads
First Presentation – Post Mortem
So it is done, it being my first presentation at a professional event. As you may recall, I recently presented...
2013-09-18
324 reads
The Dangers of Detach
I ran across a twitter conversation about a post recently. The post talks about detaching or attaching databases in bulk....
2013-09-18
1,108 reads
sp_DBPermissions V2.0
Last month I posted my stored procedures sp_SrvPermissions and sp_DBPermissions. I’m posting V2.0 of each with a few fixes. The...
2013-09-23 (first published: 2013-09-18)
2,465 reads
sp_SrvPermissions V2.0
Last month I posted my stored procedures sp_SrvPermissions and sp_DBPermissions. I’m posting V2.0 of each with a few fixes. The...
2013-09-23 (first published: 2013-09-18)
2,091 reads
Blogs
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...
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
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