Your SQL Server database just failed, can you restore the backup?
It’s one thing to be able to backup a database, it’s another thing to be able to restore it into...
2012-05-09
4,523 reads
“Thou Shall Not Shrink the Database” #TSQL2sDay
This month, Chris Shaw (Blog | @sqlshaw) is leading the charge on the T-SQL Tuesday. This event is basically a blogging...
2012-05-08
1,004 reads
T-SQL Tuesday #30 TOP 5 Rules for the SQL Community *Screw Ethics
Chris Shaw (@SQLShaw|Blog) is hosting T-SQL Tuesday this month. It has been a while since I participated and this month...
2012-05-08
823 reads
T-SQL Tuesday #30 - Ethics and the DBA
This latest installment of T-SQL Tuesday #30, is hosted by SQL MVP, Chris Shaw who asks us to write on a...
2012-05-08
1,908 reads
Picking Technical Conference Sessions (#SQLRally Edition)
Conferences are awesome. They are full of people and sessions. Almost…TOO many sessions. How on Earth do you get in...
2012-05-08
1,179 reads
T-SQL Tuesday #30 – Ethics
This month the topic is hosted by Chris Shaw, and his topic is ethics.
The blog party is the second Tuesday...
2012-05-08
1,066 reads
Denali — Day 8: Startup Parameter
Denali – Day 8: Startup Parameter
Startup Parameters means you are providing the parameter to sql server at the start of sql...
2012-05-08
773 reads
Workspace database server was not found
You might constantly see a warning message that appears like the one below when creating Analysis Services Tabular projects. It...
2012-05-08
1,115 reads
My Garden Update
It’s been just over two months since I started my small home garden. The initial work to clear the area...
2012-05-08
668 reads
How To Use T-SQL TIMESTAMP (ROWVERSION) in SSIS
In some database designs, you may encounter SQL Server columns with a TIMESTAMP or ROWVERSION data type. What are these, and how do you deal with them in SQL...
2012-05-08
691 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 Mahendradata Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. Mahendradatta Selatan No. 99 AX, Padangsambian, Kec. Denpasar Bar., Kota Denpasar, Bali...
Alamat Telp BCA KCP Sesetan Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. Raya Sesetan No.301, Sesetan, Denpasar Selatan, Kota Denpasar, Bali 80223
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