Importing Flat Files in SSMS 17.x Works
One of the more annoying things I’ve found in SSIS/SSMS is trying to import CSV files for some quick analysis....
2018-09-21 (first published: 2018-09-12)
2,302 reads
Azure Storage – Hot, Cold, Archive
There’s a lot of talk about storage options. When working with customers, I often introduce them to Azure through storage,...
2018-09-12
725 reads
Bulk insert issue with UTF-8 fixed-width file format
Fellow Canadian Doran Douglas brought this issue to my attention recently, and I wanted to share it with you as...
2018-09-12
294 reads
3rd Edition, SQL Server Execution Plans, a Story
Four years ago, after a bunch of dithering and some negotiations with Tony Davis, my editor, I started to update...
2018-09-21 (first published: 2018-09-12)
1,895 reads
SQL Server Operations Studio and VSCode: The wrong default datetimeoffset format
This post is to answer the question: “You are used to seeing in the format of yyyy-MM-dd right?” that I...
2018-09-12
429 reads
MAXDOP and Azure SQL DB
The infamous setting that we all know and love – MAXDOP. Did you know that you can actually control MAXDOP when...
2018-09-12
560 reads
T-SQL Tuesday #106 – The Trouble with Triggers
For this month’s T-SQL Tuesday Steve Jones asks us to talk about our experiences with Triggers:
https://voiceofthedba.com/2018/09/03/t-sql-tuesday-106-trigger-headaches-or-happiness/
In my post I’m going...
2018-09-12
266 reads
Power BI Monthly Digest – September 2018
In this month’s Power BI Digest with my friend Manuel Quintana [Blog | Twitter] and I will again guide you through...
2018-09-25 (first published: 2018-09-12)
2,111 reads
Pride and Prejudice... and Triggers
This post is part of #tsql2sday event 🙂
I know, in the world of the database administrators and developers, the triggers are the ugly duck of the database development.They are...
2018-09-11
16 reads
SQL Admin Best Practices with DMV's at the Houston SQL Server UG
Thanks to the full room of SQL enthusiasts who joined me today for the September Houston SQL Server UG Group Meeting! What a great crowd that enjoyed the hospitality...
2018-09-11
9 reads
Blogs
Take Time to Gain Perspective
By Brian Kelley
Probably the best piece of advice I ever received is to take time to...
The Fringe Festival
By Steve Jones
I was lucky enough to take a vacation a decade ago in Edinburgh with...
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
Forums
Alamat Kantor BCA KCU Karawang Tlp:08217555651
WA CS 628217555651 Jl. Interchange Karawang Barat, Purwadana, Karawang, 41361, Purwadana, Telukjambe Timur, Karawang,...
Learn From History
Comments posted to this topic are about the item Learn From History
The SQL Server MCP Server
Comments posted to this topic are about the item The SQL Server MCP Server
Question of the Day
The SQL Server MCP Server
How do I get an MCP server for my SQL Server 2025 database from Microsoft?
See possible answers