Off to Redmond
Actually I’m off to Bellevue this week for the annual MVP Summit that Microsoft puts on each year. This is...
2013-02-18
798 reads
Building My Next Workstation–Part 1
It’s been four years – maybe more – since I last bought a workstation to use for development and lab work. It’s...
2013-02-18
751 reads
Get Data Warehouse Training and Help a Neat School
If you're located relatively near the Atlanta, Georgia area, I wanted to bring your attention to data warehousing training on...
2013-02-18
1,113 reads
Configuring PerformancePoint Data Source for Time Intelligence
PerformancePoint provides functionality to map several time dimensions across multiple data sources to a ‘Master Time Dimension’. Data sources that...
2013-02-18
1,858 reads
Script Out Foreign Keys With Multiple Keys
It's easy enough to use sys.foreign_keys and sys.foreign_key_columns to identify foreign keys. But what if you want to script out your foreign...
2013-02-18
1,204 reads
Inserting Binary Data
There are a number of articles on dealing with the insertion of binary data into SQL Server using BULK INSERT,...
2013-02-17
20,915 reads
Using Foreign Keys to Determine Table Insertion Order
Here's a script to determine, based on your database's foreign key relationships, what the insertion order would be for, say,...
2013-02-17
1,550 reads
A year of SQL Lunchs
Time does fly, and happy birthday SQL Lunch UK.
It has been a year since the first SQLLunch UK, and over...
2013-02-17
714 reads
A Month of PowerShell – Day 17 (Databases: Views)
Welcome to Day 17 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-02-17
694 reads
Fun with dates
Every year me and a group of friends attend the Royal International Air Tattoo (RIAT) at RAF Fairford, for us it...
2013-02-17
803 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