Report Portal in SSRS 2016
SQL Server Reporting Services benefits from a major update in SQL Server 2016, which is obvious from the first interaction...
2016-12-20
578 reads
SQL Server and Hyper-threading
This post is about the CPU utilisation in the Standard, Web and Express editions of SQL Server because there is limitation...
2016-12-20
6,060 reads
Last Restore of a Database – Back to Basics
In this article I explore the basics around how to determine when a database was last restored.
Related Posts:
Changing Default Logs Directory - Back to Basics January 4, 2018
SQL...
2016-12-20
61 reads
Last Restore of a Database – Back to Basics
Remember When…
Back in late December of 2015, a challenge of sorts was issued by Tim Ford (twitter) to write a...
2016-12-20
688 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
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
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
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
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
: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
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