SSIS Security Presentation today, May 29th
Andy Leonard (blog | twitter) and I are teaming up to do a security presentation today on SSIS. It's scheduled for 11 AM...
2013-05-29
841 reads
Back to Plan A
At the end of April I posted a bit on my change in plans and what I thought I’d be...
2013-05-28
793 reads
New Immersion Event Classes at SQLskills
There are three new upcoming Immersion Event classes from SQLskills, including one that I will be teaching, which is the...
2013-05-28
846 reads
Security Questions: Authentication Performance
As I mentioned in the introductory post, during the Introduction to SQL Server Security session for Pragmatic Work’sTraining on the T’s, I...
2013-05-28
758 reads
SMO vs Invoke-Sqlcmd in Azure
I’m working on a series of Powershell scripts for the pre-conference seminars on Windows Azure SQL Database that I’m going to be...
2013-05-28
1,082 reads
Business Intelligence Requirements Gathering
There are three fundamental steps in building a data warehouse for a BI solution (see Why you need Business Intelligence):
Identify...
2013-05-28
4,900 reads
Internet Security Advice For The Family
Constant Vigilance!For today’s post I’m channeling my inner Brian Kelley (Blog | Twitter) and talking about security, in particular Internet security....
2013-05-28
997 reads
Using CROSS APPLY to calculate an aggregate across a single row.
I’ve had CROSS APPLY on the mind recently. You could probably tell since its been the subject of my last...
2013-05-28
1,481 reads
SQL Server – Filtering objects in Object Explorer – Management Studio
When you are working on a database with a large number of objects sometimes it becomes a challenge to locate...
2013-05-28
1,026 reads
Using the SSIS Object Variable as a Result Set Enumerator
In the first post in this series, I covered the basics of object typed variables in SQL Server Integration Services,...
2013-05-28
1,886 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