PASS Business Analytics Conference Presentation Slides
Thanks to everyone who attended my sessions “Overview of Microsoft Appliances” and “Building an Effective Data Warehouse Architecture” at the PASS Business Analytics...
2013-04-15
708 reads
Thanks to everyone who attended my sessions “Overview of Microsoft Appliances” and “Building an Effective Data Warehouse Architecture” at the PASS Business Analytics...
2013-04-15
708 reads
This one is basic but still something that can catch you unawares if you aren’t careful. Most DBAs and developers...
2013-04-15
1,545 reads
Its been a fair few years since I started blogging on SQLBlogCasts and the time has now come to find...
2013-04-14
633 reads
SQL Server stores all informational messages, warning messages, and errors in operating system and application log files. As a database...
2013-04-14
945 reads
Microsoft SQL Server provides DBAs and Developers with several index related dynamic management views and functions, which they can use...
2013-04-14
847 reads
After lunch, I led the session “What Are You Waiting For?” at SQL Saturday Chicago #211. It was another well-received...
2013-04-13
522 reads
Consider adding Troy Hunt to your feed listGreat post about the role of staffing firms in your job search and...
2013-04-13
649 reads
Just got done with my morning session, titled ”Discovering the Plan Cache“, for SQL Saturday Chicago #211 and wanted to get...
2013-04-13
449 reads
I’ve been looking for better ways of learning and improving my SQL Server skills. Blogs, BOL, webcasts, and training videos...
2013-04-13
741 reads
Do It In Bulk
I usually don’t run queries on just one server. Most of the time I need to get...
2013-04-12
1,277 reads
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
This week I was at PASS Data Community Summit in Seattle, and I attended...
By James Serra
(This is the third post in a three-part series on how AI is changing...
Comments posted to this topic are about the item Pay for Performance, which is...
Comments posted to this topic are about the item Helping an English Student with...
Comments posted to this topic are about the item 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