Rules of Holes #6: Don't Draw Others Into the Hole with You
In the Fifth Rules of Holes, you were encouraged to seek help from others in order to extricate youself from the Hole. And it should have been clear in...
2012-11-20
18 reads
Blogging for Beginners
Last week at the PASS Summit, I had several conversations with several different aspiring bloggers, and found myself saying the...
2012-11-20
996 reads
Rules of Holes #6: Don't Draw Others Into the Hole with You
In the Fifth Rules of Holes, you were encouraged to seek help from others in order to extricate youself from...
2012-11-20
806 reads
Explore file physical structure - fixed length row
1. Create sample db
use master
go
CREATE DATABASE [test] ON PRIMARY
( NAME = N'test', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\master\test.mdf' , SIZE = 3072KB , FILEGROWTH = 1024KB...
2012-11-20
1,096 reads
Master Data Services Web Services API Error
In Master Data Services (MDS), I received an error when using C# code in the script task in SSIS 2012...
2012-11-20
1,059 reads
Lost in Translation – Deprecated System Tables – sysopentapes
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-11-20
873 reads
PASS SQL Saturday World Map
I had the pleasure of helping Karla Landrum (@Karlakay22) for the PASS Summit 2012 by creating two dashboards: SQL Saturday...
2012-11-20
1,019 reads
PASS Summit 2012 – Networking
I was fortunate to attend my 4th PASS Summit. For the past 4 years I have flown out to Seattle...
2012-11-20
682 reads
Login issues with WSS 3.0 || Moss2007 || SharePoint2010
Hey Friends,
Sometime when we build a SharePoint server we can face issues with login. The login prompt keeps on asking...
2012-11-20
591 reads
Top 5 Books on SQL Server 2008 Business Intelligence
Carrying on with book week and answering the question I’m often asked about what books I;d recommend to learn about...
2012-11-20
955 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