SQL Injection Issues–Password Hashing
I’ve got a demo for one of my talks that really highlights some issues we have with SQL Injection. It’s...
2014-12-04
1,394 reads
Blog Posts
SQLKonferenz 2015
If you are looking for one of the most awesome and most import conferences in Europe, then surely you need...
2014-12-04
436 reads
INSERT INTO SELECT vs SELECT INTO
INSERT INTO SELECT and SELECT INTO may be very similar commands but they have some important differences. Every now and...
2014-12-03
16,810 reads
Outlier Detection with SQL Server, part 3.1: Grubbs’ Test
By Steve Bolton
…………In the last two installments of this series of amateur self-tutorials, I mentioned that the various means of...
2014-12-03 (first published: 2014-11-29)
11,095 reads
Placeholders for Emergencies
A long time ago I worked in a large corporation where we managed lots of servers, each of which performed...
2014-12-03 (first published: 2014-11-24)
6,814 reads
SQL Saturday NYC Update 1
It has been one week now since SQL Saturday NYC was announced and the planning committee and myself are very...
2014-12-03
372 reads
SSRS SharePoint Integrated Mode – Report Server URL
This is a short, but hopefully sweet post for someone, whom, like me, might have had to end up spending...
2014-12-03
2,703 reads
Clustered Columnstore Indexes – part 45 (“Multi-Dimensional Clustering”)
Continuation from the previous 44 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
I have blogged a couple times (part 29 – “Data Loading for Better...
2014-12-02
365 reads
Exam Prep 70-463: Just the facts, ma’am
This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing...
2014-12-02 (first published: 2014-11-24)
7,988 reads
Get Information on Current Traces Running
This is just a quick informational query to save as a snippet to get some quick information on running traces,...
2014-12-02
953 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
Fulltext filter daemon host (FDHost) process has stopped abnormally
We have performed a side-by-side upgrade, from SQL Server 2016 to 2022 Developer Edition,...
Automating OSM Data Refresh in Power BI’s Azure Maps Reference Layer
Comments posted to this topic are about the item Automating OSM Data Refresh in...
Database Mail Configuration
Comments posted to this topic are about the item Database Mail Configuration
Question of the Day
Database Mail Configuration
If I want to get a list of the configuration settings for Database Mail using T-SQL, how can I do so?
See possible answers