Populating My DBA Database for Power Bi with PowerShell – Databases
Following my post about using Power Bi with my DBA Database I have been asked if I would share the...
2015-09-22
873 reads
Following my post about using Power Bi with my DBA Database I have been asked if I would share the...
2015-09-22
873 reads
Here I continue a series of articles devoted to new options in SQL Server 2014. Today let’s review another useful operation – ONLINE rebuilding some partitions of partitioned objects...
2015-09-22
57 reads
Here I continue a series of articles devoted to new options in SQL Server 2014. Today let’s review another useful operation – ONLINE rebuilding some partitions of partitioned objects...
2015-09-22
46 reads
Here I continue a series of articles devoted to new options in SQL Server 2014. Today let’s review another useful...
2015-09-22
1,047 reads
Welcome back to DR drill series!
In the last post (here), we have highlighted a number of ways to setup disaster...
2015-09-22
1,510 reads
Continuation from the previous 66 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
Continuing from the last couple of blog...
2015-09-22
623 reads
Statistics, in simplest terms, refer to the distribution of data in a column or index. They are represented in a...
2015-09-21
798 reads
One of the hassles of working in a development team is that you will have conflicts between your code and...
2015-09-21
1,062 reads
XML handling with aliases
I find it interesting the difference in behavior with querying XML between column assignment, and quoted alias...
2015-09-21
319 reads
I have spoken a number of times at different SQLSaturdays around the world, including some rather rare editions, such as...
2015-09-21
441 reads
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
This week I was at PASS Data Community Summit in Seattle, and I attended...
By James Serra
(This is the third post in a three-part series on how AI is changing...
Comments posted to this topic are about the item Pay for Performance, which is...
WhatsApp:0817819444 Jl. Mahendradatta Selatan No. 99 AX, Padangsambian, Kec. Denpasar Bar., Kota Denpasar, Bali...
WhatsApp:0817819444 Jl. Raya Sesetan No.301, Sesetan, Denpasar Selatan, Kota Denpasar, Bali 80223
I have a table, dbo.bittest, where I am testing an application response. This has this structure:
CREATE TABLE [dbo].[BitTest] ( [insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()), [a] [bit] NULL ) ON [PRIMARY] GOMy application runs this code:
INSERT dbo.BitTest
(
insertdate,
a
)
VALUES
(DEFAULT, 'true')
GO
See possible answers