Securing the Things
The Internet of Things is coming, and bringing lots of data, but security needs to be included as well.
2017-06-15
35 reads
Internet of things
The Great and Powerful Internet of Things
A look at the good, and bad, of the IoT world along with the potential future.
2017-02-02
91 reads
The Future is Now - An Internet of Things Infographic
A look at the positive and negative aspects of IoT in this infographic.
2017-02-01
238 reads
Hadoop For SQL Folks: Architecture, MapReduce and Powering IoT
As the de-facto big data processing and analytics engine, the Hadoop ecosystem is also leading the way in powering Internet of Things (IOT)
2016-12-02 (first published: 2015-08-06)
12,050 reads
RE: Database size
Try it without the "TO FILEGROUP PRIMARY" And if you haven't converted to NTFS then the initial and max sizes need to be below 4GB. SIZE = 5GB, MAXSIZE = 10GB, FILEGROWTH = 1 GB Why don't you convert to NTFS?
2005-01-31
RE: how to add one second
That's unfair!select getdate() , datediff(ss,cast('7/4/2004' as datetime), getdate())%60 ------------------------------------------------------ ----------- 2004-12-28 16:00:59.590 59(1 row(s) affected)Now add 1 and get 0 => No time difference between both date. q.e.d.
2004-12-28
RE: access the questions
First of all Thank you for your reply. Also, I would like to apologize if I did not make myself clear. I do know that we see the answer right after we complete the question of the day, but what I try to see is the answer for the old question which located on the […]
2004-12-23
qurey hangs with distributed transactions
If I write an insert directly to a linked server then it works. If I do exactly the same via a distributed transaction it hangs. The syntax is 100% correct including the xact_abort on I'm using sql2000 sp2 with a domain service account. I can't believe the answer is upgrade to sp3a. Any suggestions gratefully received.
2004-07-29
2 reads
RE: Permissions in sql server 2000 (URGENT)
HI robbac, yes, Users are under NT group.AppDev How use ddl_admin to create/alter/execute procedure/functions and not to create /alter table/constraints/indexes.Thanks,Sheilesh
2004-07-26
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