TSQL Tuesday #60: Something New Learned – What permissions does have?
What have I learned recently? Well as it happens I learned something rather interesting recently and was actually trying to...
2014-11-11
1,670 reads
SQLStudies
TSQL Tuesday #60: Something New Learned – What permissions does
How to remove additional (unwanted) log files
Using multiple data files is a common best practice for a number of reasons, but multiple log files? Typically a...
2014-11-05
1,283 reads
My DTS Package won’t load with the error “here were errors loading package”
You are trying to open a DTS package (yes some people still use DTS packages) and receive the following error:
Error...
2014-11-03
787 reads
Playing with the log – Before the first full backup
The log file tends to fascinate me. In fact one of my favorite posts is where I looked into the...
2014-10-29
1,822 reads
A script to list the DTS connection information for every package on the instance.
For those of you who have moved completely to SQL 2012 & 2014, Lucky you and don’t judge! For the rest...
2014-10-27
673 reads
Force only certain values to be unique
I thought of something rather interesting the other day while answering a question asking for help with some table structures....
2014-11-03 (first published: 2014-10-22)
6,579 reads
Update to “The clustered index columns are in all of the non clustered indexes.”
I certainly hadn’t planned on creating a part two of my post on clustered index columns but in the comments...
2014-10-29 (first published: 2014-10-20)
6,082 reads
UNION vs UNION ALL
You might be wondering why I’m going into such a simple subject. Well the way I see it there are...
2014-10-16
2,760 reads
TSQL Tuesday #59: My Hero, My Inspiration, My Wife
TSQL Tuesday is a blog party started by Adam Machanic (b/t) almost 5 years ago. This month Tracey McKibben (b/t)...
2014-10-14
1,165 reads
Required reading before upgrading SQL Server.
I was watching a great presentation by Brent Ozar(b/t) on why to move to SQL 2014 and in the Q...
2014-10-08
1,301 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
When the Token Meter is Zero
Comments posted to this topic are about the item When the Token Meter is...
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...
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