Get Dependent Databases, Tables, Columns…
Quite often people need to write a new T-SQL application to replace an existing one for various reasons. For instance,...
2012-07-06 (first published: 2012-06-29)
4,207 reads
Using Excel Macro (.xlsm) Enabled Files in SSIS
Recently while working for a client that was running SQL Server 2008 R2 I was tasked with loading an Excel...
2012-07-05 (first published: 2012-06-29)
6,296 reads
Powershell, SMO, and Add-Member - Not Always BFF
Over the past few weeks, I’ve been working with SMO to implement some maintenance routines across my clients. Because of...
2012-07-04 (first published: 2012-06-28)
3,991 reads
Troubleshooting Database Mirroring Error 1418 Updated
Troubleshooting Database Mirroring Error 1418 Updated
Last night I was helping someone with a database mirroring setup problem via email. It...
2012-06-28
3,848 reads
SQL 2000 TIPS AND TRICKS DECK AND DEMOS
Hello Dear Reader today I'm going to be presenting on SQL 2000 Upgrade tips and tricks for Pragmatic Works Training...
2012-06-28
1,205 reads
Speaker Selection for SQLSaturday Orlando-Group #2
Four more speakers we’re pleased to have joining us at SQLSaturday #151 this fall in Orlando!
Paul Waters
Mike Antonovich
David Liebman
Bradley Schacht
2012-06-28
1,411 reads
Free Training: Performance Tuning with Free Tools!
This week I have two presentations on my schedule. I get to give my Performance Tuning for Pirates presentation twice...
2012-06-28
1,415 reads
Speaker Selection for SQLSaturday Orlando-Group #1
Today we’re starting to announce speakers that will have at least one session on the schedule for SQLSaturday #151 in...
2012-06-28
1,560 reads
Using a Symmetric Key
In my Encryption Primer talk, I do demo on symmetric key use, and wanted to document it here. Encryption is...
2012-06-27
3,030 reads
Microsoft Data Quality Services in SQL Server 2012
SQL Server Data Quality Services (DQS) is a knowledge-driven data quality product that is new to SQL Server 2012. The...
2012-06-27
5,211 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