Job: SQL Server DBA (Permanent UK)
A client of mine are looking for a good SQL Server DBA on a permanent basis, the location is flexible...
2013-09-05
717 reads
A Better Braindump (#mcm #mcmstudy)
I’m studying my butt off for the soon-to-be-deprecated Microsoft Certified Master cert’s lab – and the three unfinished prerequisite certs I’ve...
2013-09-05
717 reads
Presentation Slides for Building an Effective Data Warehouse Architecture
Thanks to everyone who attended my session “Building an Effective Data Warehouse Architecture” for the PASS DBA Fundamentals Virtual Chapter. The abstract is...
2013-09-04
721 reads
Azure Capabilities Expand
But then, the capabilities in Azure are always expanding. Here’s the new stuff that was just released in a blog...
2013-09-04
640 reads
SQL Server events in the UK September 2013
Sorry things are a little later this month…Summer (like the MCM program) may be coming to an end, but we...
2013-09-04
691 reads
How to become a better, well-rounded SQL Server DBA
(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)
People are sometimes...
2013-09-04
876 reads
Why Blog?
The main reason I started blogging was a community thing. I leeched from the community to get me to where...
2013-09-04
1,015 reads
Is Microsoft's Certification Program Value Microsoft's Fault?
I'd be interested if anyone says, "No," to that question. Gail Shaw raised a few points in this post about...
2013-09-04
2,009 reads
It's not you; it's us
Mirrored from http://www.sqlservercentral.com/articles/Editorial/101894/
By now I expect this news is no longer new: the MCM, MSA, and renamed versions of those...
2013-09-04
2,102 reads
Replicated Stored Procedure Execution
One feature that many of my clients are unaware of is that the batched execution of a stored procedure can be...
2013-09-04
2,134 reads
Blogs
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...
SSMS Is Getting Smarter—and This Isn’t Just About Writing SQL
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
Yippee-Kai-Yay 2027 Summit in Denver
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
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...
Adding Bits I
Comments posted to this topic are about the item Adding Bits I
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