Viewing 15 posts - 1 through 15 (of 20 total)
September 5, 2017 at 7:27 am
September 4, 2017 at 2:11 am
Sergiy (10/20/2016)
csj (10/20/2016)
It is possible to add a new column, to modify a column and drop a column, while system_versioning is ON!!!
What happens to the historical data in the column...
October 21, 2016 at 12:49 am
Yev.d (10/20/2016)
It's good to know what's out there even though in many cases you can't really apply it in your workplace.
In regards to history clean-up, I'm...
October 21, 2016 at 12:48 am
csj (10/20/2016)
USE master;
GO
DROP DATABASE IF EXISTS TemporalDB;
GO
CREATE DATABASE TemporalDB;
GO
USE TemporalDB;
GO
CREATE TABLE...
October 20, 2016 at 3:33 am
nicoboey (10/18/2016)
Hi,great post!
Finally SQL Server can handle History data.
Is there any chance that the user that caused the change is also kept in the history file?
Regards,
Nico
Hi Nico,
No -...
October 18, 2016 at 7:23 am
Geoff A (10/18/2016)
one question though.
when you ALTER an existing table and ADD the needed datetime2 columns and then ALTER it again to SET SYSTEM_VERSION...
October 18, 2016 at 6:08 am
gerardo.arevalo (9/10/2015)
Hi! greate post.Kind of confused about whether the .BIML file can be executed directly on the SQL Server without being imported in VisualStudio first. Make sense?
Thanks!
Hi Gerardo,
You'll need to...
September 10, 2015 at 11:52 am
David Allan (9/10/2015)
September 10, 2015 at 5:53 am
dave-dj (9/10/2015)
September 10, 2015 at 5:48 am
Old habits from the time before WCF.
drowling23 (2/6/2011)
Why do you use Newtonsoft.Json? Don't we have a DataContractSerializer that supports Json?
February 7, 2011 at 9:58 am
Yes, Twitter changed their authentication in September. From what I have seen it has not had any impact on the streaming API.
I will update the adapter to work with oAuth...
September 29, 2010 at 2:42 am
I agree the price tag is hefty. Personally I'd prefer if StreamInsight was available as a separate license. Now it's bundled with SQL Server Datacenter Edition, which has a lot...
January 26, 2010 at 12:16 am
I believe the price of 60k per CPU is more aimed at Financial Companies using StreamInsight for algorithmic trading. It should be compared to other CEP vendors prices. There are...
January 25, 2010 at 5:43 am
evald (12/10/2009)
Hello,thanks for this article. Very simple and clear.
A question: what if i want to persist the stock quotes on a database(i.e sql2008)?
What approach would you advice?
Using an outputadpater?
thank you
Yes,...
December 10, 2009 at 10:40 am
Viewing 15 posts - 1 through 15 (of 20 total)