Let NonAdmins Get Logins
I saw a question recently about how to allow some users to see the logins on a server without being...
2017-02-08
837 reads
Blog Posts
Speaking at SQLSaturday Chicago – 600!
Speaking at SQLSaturday Chicago!
I’m proud to announce that I will be speaking at SQL Saturday Chicago on March 11th 2017! And wow, 600 SQLSaturdays! This one won’t let you down....
2017-02-08
10 reads
Speaking at SQLSaturday Chicago – 600!
Speaking at SQLSaturday Chicago!
I’m proud to announce that I will be speaking at SQL Saturday Chicago on March 11th 2017! And wow,...
2017-02-08
319 reads
TugaIT – Pre-conference workshop on PowerShell on Linux
Where – Thursday, May 18, 2017 Where – TUGA IT – Lisbon, Portugal
Full Day Session – “Open Source PowerShell on Linux – Skills to Manage Your Heterogenous Data Center“ ...
2017-02-08
14 reads
TugaIT – Pre-conference workshop on PowerShell on Linux
Where – Thursday, May 18, 2017
Where – TUGA IT – Lisbon, Portugal
Full Day Session – “Open Source PowerShell on Linux – Skills to Manage Your...
2017-02-08
461 reads
Where is that Preemptive Wait coming from? Database Ownership and Performance: a journey through SQL Server internals with XEvents, Windbg and Wireshark
(EN)
In this article I will bring together several techniques for troubleshooting a performance- and security-related “phenomenon” I recently noticed when...
2017-02-08 (first published: 2017-02-02)
2,095 reads
JSON Support Is The Best New Developer Feature in SQL 2016 — Part 3: Updating, Adding, and Deleting…
This is the third article in my series about learning how to use SQL Server 2016's new JSON functions. If you haven't already, you can read Part 1?—?Parsing JSON...
2017-02-07
37 reads
Not Quite Monday Morning SQL Break – February 7, 2017
It’s Tuesday and time to get Monday’s weekly blog and twitter round-up for last week out the door. It’s late and I need to find a better way to...
2017-02-07
51 reads
Not Quite Monday Morning SQL Break – February 7, 2017
It’s Tuesday and time to get Monday’s weekly blog and twitter round-up for last week out the door. It’s late...
2017-02-07
1,001 reads
Power BI Custom Visuals Class (Module 36 – Box and Whiskers (Brad))
In this module you will learn how to use the Box and Whiskers (Brad) Power BI Custom Visual. This is...
2017-02-07 (first published: 2017-02-03)
1,501 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...
Layanan BCA KCP Magetan Hub/Wa. 0817-819-444
Jl. A. Yani No.25 B, Dusun Onggoprayan, Kepolorejo, Kec. Magetan, Kabupaten Magetan, Jawa Timur...
Layanan BCA KCU MADIUN Hub/Wa. 0817-819-444
9G9F+FFC, Jl. Jend. Sudirman No.79-81, Kejuron, Kec. Taman, Kota Madiun, Jawa Timur 63132
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