Listing server and database roles for all logins and users in SQL Server – Part 2 – Remote Servers
Building upon the code in my previous post, I will be retrieving permissions information from remote servers that I have...
2012-10-15
422 reads
Building upon the code in my previous post, I will be retrieving permissions information from remote servers that I have...
2012-10-15
422 reads
Issue :
Today, I received one request from my old friend.
He wants to insert text in different languages in table. He...
2012-10-15
3,001 reads
Last Thursday I found myself on a journey of sorts. There weren’t any lions or tigers or bears, but there were plenty of “Oh My”‘s. It all began on...
2012-10-15
15 reads
Last Thursday I found myself on a journey of sorts. There weren’t any lions or tigers or bears, but there...
2012-10-15
981 reads
Databases are an important reservoir of sensitive information, and that is why it is important for us as a DBA...
2012-10-15
860 reads
Reblogged from Basit's SQL Server Tips:
SQL Server 2012 allows you to store file/directories in a special table called FileTable that...
2012-10-15
1,041 reads
In one of my presentations recently I was recommending DBCC CHECKDB on every database every day. I realize that isn’t...
2012-10-15
1,489 reads
I recently passed my MCTS 2008 Development (70-433). Yay me! That made my 3rd 2008 certification. This one was probably the...
2012-10-15
1,866 reads
It’s just a query against the database. If things are running slow, buy some more memory, a faster CPU or...
2012-10-17 (first published: 2012-10-15)
3,009 reads
Throughout the week, I like to tweet links to the things that I’ve been reading. Since they all come out...
2012-10-15
721 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...
Comments posted to this topic are about the item Helping an English Student with...
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