SQL Server : List Login's Database and Server Level Role Permission
In my last post, we have discussed about the orphaned users and fixing the orphaned users. The next step in...
2012-08-05
10,549 reads
In my last post, we have discussed about the orphaned users and fixing the orphaned users. The next step in...
2012-08-05
10,549 reads
Jen McCown (Blog | Twitter) wrote about an interesting topic on the different levels of database professionals. In her article, Jen...
2012-08-04
1,293 reads
Let me start with my sincere apologies first for not blogging consistently.
Primary reason is, my wife gave birth to our...
2012-08-04
1,359 reads
Before I became a SQL Server DBA, I used to be a web developer in ASP3. Since then, I sometimes...
2012-08-04
645 reads
Yesterday I have uploaded my 2nd SQL Server Quickie to YouTube. In this episode I’m talking about Extents, and how...
2012-08-04
649 reads
Yesterday I have uploaded my 2nd SQL Server Quickie to YouTube. In this episode I'm
talking about Extents, and how SQL...
2012-08-04
1,136 reads
Security is one of the most discussed topics for any cloud deployment plans and no organisation would like to compromise...
2012-08-03
702 reads
I was running some code the other day and was surprised by the result.
DECLARE @tmp TABLE (myID INT IDENTITY,MyChar VARCHAR(200))
INSERT...
2012-08-03
2,758 reads
This is really scary. Someone being sued for downloading a porn movie illegally. I have nothing against porn, and I...
2012-08-03
898 reads
Apparently, SQL Saturday isn’t popular in the west. See for yourself. I wanted to see what cities frequently host SQL...
2012-08-03
1,570 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...
Telp/Wa 628218200203 Jl. Jend. Sudirman No.49-51, Terban, Kec. Gondokusuman, Kota Yogyakarta, Daerah Istimewa Yogyakarta...
Telp/Wa 628218200233 Jl. MT. Haryono No.2, Jengglong Timur, Purwodadi, Kec. Purwodadi, Kabupaten Grobogan, Jawa...
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