A Tainted PASS Elections
Another PASS Board of Directors election cycle has come and gone, and with the results now announced I'd like to...
2013-10-02
852 reads
Social Engineering: How to prevent unauthorized access to SQL Server using SQL Logins
People are always concerned about Security when it comes to their data. I don’t blame them, I love keeping my...
2013-10-02
729 reads
Filtering Object Explorer
I absolutely love learning new tricks that can be done in SSMS. Everything from opening initial connections to both the...
2013-10-02
899 reads
SharePoint Reporting Services Content Types Missing
Being able to manage the content types in your SharePoint libraries is key to creating a useful portal. Among the...
2013-10-02
2,824 reads
SQL Server – How to Copy or Export an SSIS Package Using Command Prompt Utility – DTUTIL
The command prompt utility dtutil can be very handy when we want to quickly export an SSIS package from either file system...
2013-10-02
1,488 reads
New Blog Series – Origins
I’ve been struggling for months to bring this blog back to life. I’d love to produce content dedicated to the...
2013-10-02
432 reads
Using A Non-correlated Subquery To Avoid DISTINCT
Nobody wants duplicate data. It’s messy, wastes space, and looks really bad on a report – I get that. What I...
2013-10-02
1,326 reads
Free SSIS Tips and Tricks Webinar
On Thursday of this week I will be presenting a webinar for Pragmatic Works Free Training on the T’s. I...
2013-10-02
946 reads
Setting Up a Domain Controller with PowerShell
Quickly setting up a domain controller is a vital step in creating a good demo environment. This post will walk...
2013-10-02
2,037 reads
Enable Instant File Initialization to accelerate database restore
Today my colleague come to me and ask me why her database restore query was hang. She was going to...
2013-10-01
1,255 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