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
471 reads
So there I am, all keen on keeping ahead of the latest security issue, as usual, whilst handling my patching...
2018-01-07
471 reads
Just a quick note to share last Wednesday night's presentation on how to manage SQL Server vulnerabilities, plus a first...
2017-11-27
547 reads
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
793 reads
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)
77,746 reads
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
701 reads
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,144 reads
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,519 reads
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,978 reads
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,022 reads
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,736 reads
By Brian Kelley
In information security (INFOSEC), there several foundational concepts and principles. One of the ones...
By Steve Jones
the standard blues– n. the dispiriting awareness that the twists and turns of your...
By Chris Yates
A brief introduction to the tool and its advantages for database migrations DevOps is...
I'm tracing activity on one database and would like to include the client_app_name in...
select Custno, Addr1, City, Res_Phone, Bus_Phone, Fax_Phone, Marine_Phone, Pager_Phone, Other_Phone, email1, email2 from customer...
I'm only processing 50,000 records not everything from the Table where there are 250,00...
I want to mark a transaction in the log as a recovery point. How do I do this in my code if I use the transaction, myTran?
See possible answers