PowerSQL – Get SQL TraceFlag SQL Service and Config Information
Get SQL Server configuration, service info, start type along with enabled Trace Flags of local or remote servers.
This script outputs...
2016-07-26
612 reads
Blog Posts
SELECT * FROM....Writing SQL Queries...
This week is my fourth week on the spin being involved in a Learning Tree Course. This week we have...
2016-07-26
604 reads
Using a Lookup Component in SSIS for Surrogate Keys in a Fact table
There are many suggestions for loading a data warehouse using SQL Server integration Services (SSIS). Once you get started, you...
2016-07-26 (first published: 2016-07-21)
5,331 reads
Webinar Followup: New Security Features in SQL Server 2016
I recently presented a free webinar for Pragmatic Works where I discussed new security features in SQL Server 2016. You can...
2016-07-26
693 reads
Blogger Questions: What should I blog about?
Over the last four years I’ve blogged almost 400 times. It’s become a refuge, a resource, a source of pride,...
2016-07-25
436 reads
Fourth Week in July
This is the fourth week of four of my July training programming and this week we have two courses that...
2016-07-25
342 reads
Speaking at SQL Server Geeks Annual Summit 2016
I am very happy and proud to share the news that I will be speaking in SQL Server Geeks Annual...
2016-07-25
419 reads
Speaking at SQLSaturday Baton Rouge!
I’m proud to announce that I will be speaking at SQL Saturday Baton Rouge on August 6th 2016! This will be my...
2016-07-25
438 reads
Speaking at SQLSaturday Baton Rouge!
I’m proud to announce that I will be speaking at SQL Saturday Baton Rouge on August 6th 2016! This will be my forth SQLSaturday event this year and I’m really excited...
2016-07-25
12 reads
SQL Server CTE – Back to Basics
Quick Flashback
Back in late December of 2015, a challenge of sorts was issued by Tim Ford (twitter) to write a...
2016-07-25 (first published: 2016-07-14)
3,341 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