Get User In Reporting Services-Question of the Day
Get User In Reporting Services is my newest question to be published at SQLServerCentral.com as a “Question of the Day”....
2014-05-27
514 reads
Blog Posts
How Much Value Would a SQLSaturday Certificate of Completion Have?
Note: Posted May 27, 2014, additions posted May 28, 2014 further down.
I think it’s been discussed a time or two,...
2014-05-27
716 reads
NodeXL – Accessible Network Graph Analysis, part 3 (Twitter)
This is the third blog post in the series dedicated to the Network Graph Analysis Tool – NodeXL.
If you are interested,...
2014-05-27
386 reads
SQL Server 2014 Launch Party Mississauga Ontario (Toronto) June 21, 2014
This event promises to be a highlight of the Canadian SQL Server calendar year.
The presenters are all 'first class'.
All...
2014-05-27
829 reads
Webcast Follow-Up: 5 SQL Server Indexing Myths
Similar to yesterday’s post, I have a follow-up for another Pragmatic WorksTraining on the T’s session that I delivered last month....
2014-05-27
905 reads
Attaching All Databases with PowerShell–Finding My MDF Files
I wrote a PowerShell script recently to actually accomplish a task I that I needed. What’s more, this was the...
2014-05-26
1,542 reads
Database Backup Encryption with SQL Server 2014
A brand new & long awaited feature “Backup Encryption” along with SQL Server 2014. Microsoft reveled this upcoming feature in PASS...
2014-05-26 (first published: 2014-05-19)
5,772 reads
Dealing with SQL Server LOCK resource errors.
I was recently doing some testing that required a fairly large table. I created the test table, and set it...
2014-05-26
828 reads
How Database Mail works in SQL Server ?
Database Mail is email feature in SQL Server from SQL Server 2005 onwards. This feature used for mailing alerts, notification,...
2014-05-26
1,093 reads
It’s Time to End Password Reuse
Last week Ebay announced that some accounts were compromised, including passwords with as yet unstated encryption. Those who aren’t tech...
2014-05-26
689 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