Step By Step Logshipping configuration
Log shipping provides a means to maintain a secondary server on an automated basisusing a chain of transaction log backups. This chapter explains the basic confi guration oflog shipping...
2017-03-02
35 reads
Step By Step Logshipping configuration
Log shipping provides a means to maintain a secondary server on an automated basis
using a chain of transaction log backups....
2017-03-02
21,722 reads
SQL Server Permissions – Database Roles
A fundamental component of SQL Server is the security layer. This article covers three common security misconfigurations in SQL Server.
Related Posts:
When Too Much is Not a Good Thing December...
2017-03-02
104 reads
SQL Server Permissions – Database Roles
EZ PZ Permission Squeezee
Given the critical level of importance related to permissions, one may think it is a concept that...
2017-03-02
1,463 reads
Random Blog Post Challenge
OK, for no particular reason at all or maybe because I had too much food at lunch or just because...
2017-03-02
400 reads
The Psychology of Value
J.C. Penney is one of the oldest and most storied retailers still in existence in the United States. For years,...
2017-03-02
386 reads
Tempdb settings in SQL Server 2016
A nice little error log feature that I noticed in SQL Server 2016 regarding tempdb. Tempdb, a system database in...
2017-03-02
421 reads
Do you need a degree to be DBA?
This question gets asked a lot and reoccurs over the years. Do you need a degree to be DBA? I have seen...
2017-03-02
442 reads
Power BI Hands-On Workshops in April, 2017
During the month of April, I will be delivering three full-day Power BI hands-On workshops. Each of these events will...
2017-03-02
375 reads
ERRORLOG records max out at 2049 characters
Stupid question… what's the schema of a table with sys.sp_readerrorlog output? Well you might be surprised if you're used to...
2017-03-02
144 reads
Blogs
A New Word: Semaphorism
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
SQL Server Linux Container Images Got Smaller: Image Size and Startup Time Across Cumulative Updates
This week I was at PASS Data Community Summit in Seattle, and I attended...
Using AI to Build Semantic Models, Ontologies, and Fabric Data Agents
By James Serra
(This is the third post in a three-part series on how AI is changing...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Layanan BCA KCP Rembang Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. Pemuda No.3 C, Tawangsari, Leteh, Kec. Rembang, Kabupaten Rembang, Jawa Tengah 59217
Layanan BCA KCP Blora Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. Pemuda No.57B, Blora, Tempelan, Kec. Blora, Kabupaten Blora, Jawa Tengah 58211
Question of the Day
Adding Bits I
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