T-SQL Tuesday – Cloud Atlas – #TSQL2sDay
This month, Jorge Segarra (Blog | @SQLChicken) is running T-SQL Tuesday on the cloud. T-SQL Tuesday is a monthly blogging event where a number...
2013-11-12
794 reads
The Cloud Is Scary – #TSQL2sDay #49
It’s T-SQL Tuesday time! I haven’t contributed in a while, so I really wanted to participate this time. The topic...
2013-11-12
646 reads
T-SQL Tuesday #48 – Cloud Atlas
T-SQL Tuesday is a recurring blog party, that is started by Adam Machanic (Blog | @AdamMachanic). Each month a blog will...
2013-11-12
556 reads
In-Memory OLTP and the Identity Column
Over the past month I've been playing around with the new In-Memory OLTP (code name: "Hekaton") features within SQL Server...
2013-11-12
1,533 reads
Index Fragmentation : Quick Tip
Fragmentation can cause issues for performance to the point of having queries not resolve at all. Your normally scheduled maintenance...
2013-11-12
443 reads
Prevent creating stored procedures with RECOMPILE hint – Policy Based Management is your friend !
I got motivated to write this post as there was a question on twitter which was like -
The user was...
2013-11-12
1,266 reads
How SQL Server Full Backups Work
I’m writing this in support of a few talks I give that talk about backups. This is how I see...
2013-11-11
930 reads
Last Weeks Top “Reading” Links #57
Monday morning and it’s time for weekly round-up. If you follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet...
2013-11-11
1,170 reads
For the Aspiring DBA
Getting started as a data professional is an incredibly daunting task. If you’re not concerned that you’re going to mess...
2013-11-18 (first published: 2013-11-11)
1,494 reads
PowerShell – Service Comparison GUI Tool
Service Comparison GUI Tool does comparison of all the services of any given two servers. The output is a grid view...
2013-11-11
1,694 reads
Blogs
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...
SSMS Is Getting Smarter—and This Isn’t Just About Writing SQL
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
Yippee-Kai-Yay 2027 Summit in Denver
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Layanan BCA KCP Magetan Hub/Wa. 0817-819-444
Jl. A. Yani No.25 B, Dusun Onggoprayan, Kepolorejo, Kec. Magetan, Kabupaten Magetan, Jawa Timur...
Layanan BCA KCU MADIUN Hub/Wa. 0817-819-444
9G9F+FFC, Jl. Jend. Sudirman No.79-81, Kejuron, Kec. Taman, Kota Madiun, Jawa Timur 63132
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