The New PASS Logo and More
Change is not always easy. In fact, change is hard.
“Change” is a word from which some people shy away, and...
2016-12-20
351 reads
Blog Posts
:OUT :OUT darn results!
Years ago I worked for a company that had a rather cool way of handling requests. When we ran the...
2016-12-19
471 reads
Announcing Tuga IT 2017
Its the right time & the right moment of the year to announce the 2nd edition of the ultimate portuguese IT...
2016-12-19
303 reads
Database Clone
There are a bunch of ways you could create a database clone. Backup and restore is one method. Export/Import is...
2016-12-19 (first published: 2016-11-28)
2,656 reads
Delivering workshop at SQLBits 17
Its the end of the another great year (2016) and I already have received an incredible news for the next...
2016-12-19
311 reads
Invoke-SqlCmd and error results
Don’t trust Invoke-SqlCmd and error resultsI love to call Invoke-sqlcmd from powershell but one must beware of the risk of...
2016-12-19
27,272 reads
New whitepaper with ScaleArc
I’m pleased to announce a new collaborative whitepaper with ScaleArc entitled “Improving uptime and performance of legacy apps on Microsoft...
2016-12-19
357 reads
PASS Board: Year-End Wrap-Up
This month concludes my second full year on the PASS Board of Directors and my first full year on the...
2016-12-19
422 reads
PowerShell : Monitoring and Notification – Disk Space Alerts
“Microsoft Technet Guru – Gold Medal Winning Article- Nov, 2016”
Abstract
Monitoring disk space utilization of server(s) is the critical and important job for...
2016-12-19
1,035 reads
Replay your workload through the Query Store Replay script!
One of the great features of the Query Store is that it stores query execution plans and runtime performance on-disk...
2016-12-19
1,384 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