Monitor Query Statistics
One of the most common tasks that DBAs are required to perform is monitoring. This is not just a task....
2015-03-10 (first published: 2015-02-26)
8,485 reads
One of the most common tasks that DBAs are required to perform is monitoring. This is not just a task....
2015-03-10 (first published: 2015-02-26)
8,485 reads
This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing...
2015-03-17 (first published: 2015-02-26)
8,680 reads
You recognize that you need to provide a pipeline for database deployments, that you need to automate as much support...
2015-02-26
1,466 reads
Dynamic Data Masking
FEBRUARY 26, 2015
Have you ever wanted to only show parts of a field to certain sets of users such as credit card numbers, telephone numbers or last...
2015-02-26
17 reads
Dynamic Data MaskingFEBRUARY 26, 2015
Have you ever wanted to only show parts of a field to certain sets of users...
2015-03-11 (first published: 2015-02-26)
8,920 reads
I’m continuing on with my project to grab SQL Saturday data and automatically insert it into a SQL Server database....
2015-02-25
1,445 reads
It’s been a while since I posted an updated to usp_DBPermissions and usp_SrvPermissions. Sorry. I got lazy with my posting....
2015-02-25
1,301 reads
That’s right! I will solve a performance issue by adding a UNION into the query. Interested? Read on!
I recently encountered...
2015-03-09 (first published: 2015-02-25)
8,832 reads
I the last tip TIP#88 we saw how to encrypt a password. Now in this tip I would like to...
2015-02-25
958 reads
Security is always a concern for every database developer. How to secure valuable information is one of the major and...
2015-02-24
436 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. Pemuda No.3 C, Tawangsari, Leteh, Kec. Rembang, Kabupaten Rembang, Jawa Tengah 59217
WhatsApp:0817819444 Jl. Pemuda No.57B, Blora, Tempelan, Kec. Blora, Kabupaten Blora, Jawa Tengah 58211
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