Using Microsoft R in Enterprise Environments
This article talks about using the the positive aspects of setting up R in enterprise environment and give instructions on first steps how to do it.
2016-08-25
2,360 reads
enterprise
Disaster Recovery in the Enterprise – Paying the Price to Avoid Extra Costs
Data Protection and Disaster Recovery (DR) are IT tasks that seldom get the same level of attention as development… until disaster strikes. Only if planning is adequate can an organisation be resilient in the face of unexpected problems. There are several steps that are needed to achieve an adequate DR process and the ability to restore business operations after a disaster.
2013-04-18
3,227 reads
Enterprise wide Backup Audit
Enterprise wide Backup Audit that produces backup information in a csv format.
2010-08-06 (first published: 2009-11-10)
1,813 reads
RE: SHOWCONTIG Data
You could always try an online defrag, but we all know how transaction log hungry that is.Sounds like there's a whole lot of insert/update/delete activity going on so maybe it's down to a badly designed system (with it being a vendor supplied database I wouldn't be suprised, we've had some really terrible ones in a […]
2005-03-31
RE: Update with insert of zero
How about something like this:select CASE PATINDEX( '%[a-Z]%', col1) WHEN 0 THEN stuff('000',4-len(col1),len(col1),col1) ELSE stuff('000',4-PATINDEX( '%[a-Z]%', col1)+1,len(col1),col1) END from test1Where test1 is the table in question and col1 is the column you are working on.
2004-10-06
RE: Can you write out multiple views automatically?
Man it goes down hill fast when posts are shorter than "short stories"
2004-01-30
RE: Merge Replication!
I thought to change to 0 (it is 128 for replicated tables) the field relpinfo in sysobject of desired table alter the column and then reset it to 128 ! Althought i havent tried this! Altering from the sp will get you to the same err message Luani
2003-07-03
RE: cpu utilization
Often my first action in such circumstances is to run profiler interactively (locally if possible) to capture SQL with a CPU > zero. I tend to run it for 15-30 mins, or for 20,000-50,000 lines, whichever comes first. Saving it to a development table for analysis thru SQL queries I've come across a query that […]
2003-06-30
Blogs
Set a Runtime Variable in an Azure DevOps Pipeline
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
A New Word: Symptomania
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
Query Store Keeps Switching Itself Off, Getting it Moving Again
I recently received a complaint that Query Store for a particular database was turned...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers