SQL Saturday #149 Session Materials
This past weekend I attended this year’s SQL Saturday in Minnesota. It was a good time, and it was on...
2012-10-05
681 reads
Blog Posts
Create a portable virtual machine with OVF or OVA
Today a great client asked me how to export a VM to an OVF or OVA so he could transport...
2012-10-04
1,694 reads
Finally, it has happened…
Last month I blogged about my absence from the blogosphere. If you want, you can read about it again – here. Granted, it has been a month and I...
2012-10-04
9 reads
Finally, it has happened…
Last month I blogged about my absence from the blogosphere. If you want, you can read about it again – here....
2012-10-04
949 reads
Jacksonville Code Camp 2012
Hello one, hello all. It has been quite a while since I have blogged. I am looking forward to starting...
2012-10-04
1,182 reads
Master Data Services (MDS): Bug deleting an attribute
UPDATE on 11/28/2012: I had this same error when trying to delete a model. Fortunately, SQL Server 2012 SP1 has...
2012-10-04
1,429 reads
Parallel Data Warehouse (PDW) How-To: Using BACKUP and RESTORE DATABASE on PDW
Before we get to the backup and restore syntax, its worth noting that the Parallel Data Warehouse (PDW) appliance architecture offers...
2012-10-04
5,452 reads
SharePoint dependencies
Microsoft has made a big push the last few years to have all its end-user BI tools integrate with SharePoint,...
2012-10-04
705 reads
SQL Server: Sending Email in HTML Table Format Using TSQL
As part of our DBA life , we have to configure many alert or statistical mails which gives an idea about...
2012-10-04
1,514 reads
Tale of detaching a database which was enabled for replication!
In development environments I prefer to use ‘detach’ database option to move around databases. It’s simple, fast and easy.
Almost all...
2012-10-04
1,317 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...
Helping an English Student with R
Comments posted to this topic are about the item Helping an English Student with...
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