Day 19 of 31 Days of Disaster Recovery: How Much Log Can a Backup Log
It’s day 19 of my 31 Days of Disaster Recovery series, and today I want to talk about how much...
2013-01-24
1,201 reads
Frequently asked Scripts during Interviews
1.Select no of Months between two dates:
SELECT DATEDIFF(MONTH,'4/1/2011','01/23/2013')+ CASE WHENDAY('4/1/2011')<DAY('01/23/2013') THEN 1 ELSE 0 END
Output:
----------------
22
2.What will be the
output of following...
2013-01-24
511 reads
A Rickety Stairway to SQL Server Data Mining, Algorithm 4: Logistic Regression
by Steve Bolton
In the last installment of this series of self-tutorials on SQL Server Data Mining (SSDM), A Rickety...
2013-01-23
2,755 reads
5 MCM Readiness Indexing Videos You Should Watch
Earlier this year, I finally passed the Microsoft Certified Master (MCM) for SQL Server 2008 certification. In the process of...
2013-01-23
1,410 reads
SSRS 101 – Prerequisites
Before I actually start explaining and demonstrating how to build SQL Server Reporting Service (SSRS) reports there are few things...
2013-02-01 (first published: 2013-01-23)
4,284 reads
PASS Business Analytics Conference Presentation
I am fortunate enough to have been selected to give a presentation at the PASS Business Analytics Conference in Chicago...
2013-01-23
1,409 reads
New Year Aspirations – Gavin Payne – MCA
Thanks for agreeing to do this Gavin. It’s great to be able to interview an MCA as there are so...
2013-01-23
958 reads
Saving Execution Plans on Azure SQL Database
In my previous post showing how to get to execution plans in the Database Management Portal, I showed that it’s...
2013-01-23
1,854 reads
IsMSShipped
I just wanted to do a brief highlight of a handy little object property. For those of you who aren’t...
2013-01-23
1,597 reads
Day 18 of 31 Days of Disaster Recovery: How to CHECKDB Like a Boss
Day 18 of my 31 Days of Disaster Recovery series is drawing to a close. It’s 11:22 PM here, and...
2013-01-23
1,198 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