WITH DATA_PURITY (from recent experience, the key to knowing if patching to 14.0.3015.40 was okay)
So there I am, all keen on keeping ahead of the latest security issue, as usual, whilst handling my patching...
2018-01-07
481 reads
HuggyBear
- Interests: Lately (2019): windfoiling or windsurfing with a Skroka foil....amongst many other supposedly 'extreme' sports, but which are really just the norm for people raised in Lotusland aka Vancouver, BC, lower-mainland region, Sea-to-Sky country as we know it.
- Blog: http://dbhive.blogspot.com/
- Jobs: SQL DBA, Data Engineer, Migrator, Clusterer, Security Implementor
- Website: https://ca.linkedin.com/in/intellabase
- LinkedIn: https://ca.linkedin.com/in/intellabase
Vigilant SQL DBA Vulnerability Management & 1st Look at Azure Vulnerability Assessments (Baltimore SSUG Session last week)
Just a quick note to share last Wednesday night's presentation on how to manage SQL Server vulnerabilities, plus a first...
2017-11-27
556 reads
Happy Belated 150th Birthday Canada, and the Importance of Compliance, Especially Vulnerability Assessments
Assess your vulnerabilities before a system compromise brings it all down: just like what wasn't done early morning on Zhiggy's...
2017-07-26
798 reads
Uninstalling SQL Server from the Command Line to Remove Unwanted Background Instances
I had a note (or ‘action item’) to make sure that people were informed regarding the ‘uninstall’ of SQL Server,...
2016-07-12 (first published: 2016-06-29)
87,953 reads
Speaking next Wednesday July 22nd, at Vermont SQL PASS group, thanks to Roman Rehak? for the invite!
Speaking next Wednesday, Vermont SQL PASS group, thanks to Roman Rehak? for the invite! http://www.meetup.com/VTCode/events/223946011/
I'll be doing an update to...
2015-07-17
708 reads
Improve Your Wifi Connection Speed with the Use of a Simple 6’/2m USB Cable Extension
For years now we have dropped using Cat6 at home for Wifi,
since the Cat5e cables in the house we moved...
2015-01-04
1,163 reads
A Wonderful Weekend in Riyadh, Kingdom of Saudi Arabia, Speaking SQLGulf #1, Alfaisal University
Thanks to the perseverance of SQL MVP Shehap El-Nagar’s invite last year, this brave
man from the Saudi Ministry of Higher...
2014-09-11
1,541 reads
Security Updates released in MS14-044, and An Approach Microsoft’s Incremental Servicing Model
On August 12th, 2014, another infamous ‘patch-Tuesday,’ Microsoft released a series of Security Updates for multiple versions of SQL Server,...
2014-08-22
1,986 reads
How to Fix that Never-Ending Join Dragging Down the Whole DB Server Instance – Pre-Populate the Largest Bugger in Temp with Indexes
Now that it has been a
good five years I have been blogging away here and on SSC, the editors recently thanked
us...
2014-05-12
1,041 reads
Microsoft Project Migration Template for the move to SQL 2012
For those planning a move to SQL Server 2012, although this process can apply for many Database Migrations, perhaps this Microsoft...
2014-01-13
10,794 reads
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
BCA KCP S. Parman CSTelpon : 0853-73737551
Jl. S. Parman No.184, Ulak Karang Sel., Kec. Padang Utara, Kota Padang, Sumatera Barat...
BCA KCU PADANG CSTelpon : 0853-73737551
Jl. H. Agus Salim No.10 A, Sawahan, Kec. Padang Tim., Kota Padang, Sumatera Barat...
BCA KCP Soekarno Hatta CSTelpon : 0853-73737551
CSTelpon : 0853-73737551 Jl. Soekarno Hatta No.RT. 29, Batu Ampar, Kec. Balikpapan Utara, Kota...
Question of the Day
The Distance Metric
In the new VECTOR_DISTANCE() function in SQL Server 2025, the first parameter is the distance_metric. What is this?
See possible answers