Getting Started with PowerBI: Building Graphs (Part 3)
This is part 3 of the Getting Started with Power BI series. Power BI is a powerful reporting and dashboarding...
2017-02-16
185 reads
Deadlock on ALTER DATABASE
I had an interesting problem recently. A database was stuck in single user mode. How exactly was it stuck you...
2017-02-16
1,438 reads
Managing Bad Data
In the last post in my ongoing series about ETL best practices, I discussed the importance of error handling in ETL...
2017-02-21 (first published: 2017-02-16)
2,212 reads
True story: Encryption in progress stuck
Working with a couple of databases that needed TDE I noticed when I enabled one of them that it was...
2017-02-16
382 reads
Resolution of Database Consistency Error in SQL Server
There are so many facilities and amenities in SQL Server along with built-in methods, which assist users in some bad...
2017-02-16
1,954 reads
PowerShell Virtual Group of PASS February Newsletter
We had a schedule conflict so today’s meeting will be pushed until next Wednesday. However, we have a last-minute meeting tonight (this afternoon, tomorrow, whichever time zone you’re in)....
2017-02-15
14 reads
PowerShell Virtual Group of PASS February Newsletter
We had a schedule conflict so today’s meeting will be pushed until next Wednesday. However, we have a last-minute meeting tonight (this afternoon, tomorrow, whichever time zone you’re in)....
2017-02-15
26 reads
PowerShell Virtual Group of PASS February Newsletter
We had a schedule conflict so today’s meeting will be pushed until next Wednesday. However, we have a last-minute meeting...
2017-02-15
496 reads
Upcoming list of webinars
SQL folks, upcoming list of webinars from SQL PASS.
Webinar title / Registration link / more infoSpeakerDate / Time"Why Your Data Type Choices Matter" https://attendee.gotowebinar.com/register/4226815545680860675Andy...
2017-02-15
260 reads
Viewing container logs
I’ve been going over some demos for a presentation that I’ll be giving this year and I thought I’d write...
2017-02-15
439 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